About this deal
Cause: The specified SQL query is invalid. The cause might be that the query doesn't return any data.
Cause: If the issue occurs on the SQL sink and the error is related to SqlDateTime overflow, the data value exceeds the allowed range in the sink table. For Azure SQL, if the error message contains the string "SqlErrorNumber=47073", it means that public network access is denied in the connectivity setting.
Menu di navigazione
If the error message contains Login failed for user '
Appaiono dappertutto, anche dove nessuno se li aspetta. Non c'è angolo della terra dove non si possano trovare."
Validate the stored procedure by using SQL Tools. Make sure that the stored procedure can return data. Resolutions: Provision a storage account in a subscription that does not use the new Azure Storage DNS partition feature (currently in Public Preview).