Hi , Thank you for the video, Once we have deployed it to ADF and we need to change somthing , do we just change it in ADF or we have to change SSIS package and redeploy? Thanks
We are working to migrate SSIS packages from VM SQL to Azure SQL MI . We have multiple excel output files generated in the VM server (by SSIS script tasks) that should be saved in the Storage account. According to our analysis, we must first construct a CSV file, which we will then convert to Excel as the excel files can't be created by SSIS inside the storage accounts. This necessitated significant adjustments (Script tasks) to our SSIS. Is there a method to fix this problem?
Hi, Its really a nice video. Can you please explain how to migrate file system system ssis package to ADF and migrate the pipeline to prod environment from test environment?
Hi, great tutorial, however I'm facing execution issues with my package as it has ODBC connections (fails the connection manager). Do you wonder how can I solve this? thanks!
@@Azureandfabricmastery hi! after I tried to debug the pipeline, it fails saying: the following: { "SsisDBOperationGuid": "68e5d7eb-a336-4046-a588-89abb10e529e", "SsisDBOperationId": 4, "OperationErrorMessages": "5/15/2022 4:08:24 PM +00:00 : Package_ETH_SAP:Error: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.
5/15/2022 4:08:24 PM +00:00 : carga Equipos Descripciones:Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager \"ETH_PRE\" failed with error code 0xC0014009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
5/15/2022 4:08:24 PM +00:00 : carga Equipos Descripciones:Error: ODBC origen Equipos descripcion failed validation and returned error code 0xC020801C.
", "effectiveIntegrationRuntime": "ETL-BI-V6 (West Europe)", "executionDuration": 10, "durationInQueue": { "integrationRuntimeQueue": 0 any idea? thanks!!
"14:20" I couldn't see the SSIS Integraion runtime which is in running state in my ADF IR. The SSIS ADF created the SSISDB in the SQL MI and it is in running status however its' not showing in the dropdown of Azure-SSIS IR
Hi Siva, Thanks for your comments! Please follow the steps mentioned in the video and in Microsoft documentation link I shared in description. When you have the SSISDB created during Azure SSIS IR setup and if IR is running successfully, you should be able to configure those in ADF activity. Please check the IR settings and let me know. Glad to help. Thanks.
Hi , Thank you for the video,
Once we have deployed it to ADF and we need to change somthing , do we just change it in ADF or we have to change SSIS package and redeploy?
Thanks
Hi, thanks for the comment. Good question. I guess it requires redeployment. Thanks.
We are working to migrate SSIS packages from VM SQL to Azure SQL MI . We have multiple excel output files generated in the VM server (by SSIS script tasks) that should be saved in the Storage account. According to our analysis, we must first construct a CSV file, which we will then convert to Excel as the excel files can't be created by SSIS inside the storage accounts. This necessitated significant adjustments (Script tasks) to our SSIS. Is there a method to fix this problem?
Thanks for your comments.
I can't think of any other approach if there is a restriction to create excel files by SSIS in a storage account.
Hi,
Its really a nice video. Can you please explain how to migrate file system system ssis package to ADF and migrate the pipeline to prod environment from test environment?
Hi, great tutorial, however I'm facing execution issues with my package as it has ODBC connections (fails the connection manager). Do you wonder how can I solve this?
thanks!
Hi. Thanks for comment. What's the issue you are facing?
@@Azureandfabricmastery hi! after I tried to debug the pipeline, it fails saying: the following:
{
"SsisDBOperationGuid": "68e5d7eb-a336-4046-a588-89abb10e529e",
"SsisDBOperationId": 4,
"OperationErrorMessages": "5/15/2022 4:08:24 PM +00:00 : Package_ETH_SAP:Error: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.
5/15/2022 4:08:24 PM +00:00 : carga Equipos Descripciones:Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager \"ETH_PRE\" failed with error code 0xC0014009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
5/15/2022 4:08:24 PM +00:00 : carga Equipos Descripciones:Error: ODBC origen Equipos descripcion failed validation and returned error code 0xC020801C.
",
"effectiveIntegrationRuntime": "ETL-BI-V6 (West Europe)",
"executionDuration": 10,
"durationInQueue": {
"integrationRuntimeQueue": 0
any idea? thanks!!
"14:20" I couldn't see the SSIS Integraion runtime which is in running state in my ADF IR. The SSIS ADF created the SSISDB in the SQL MI and it is in running status however its' not showing in the dropdown of Azure-SSIS IR
Hi Siva, Thanks for your comments! Please follow the steps mentioned in the video and in Microsoft documentation link I shared in description. When you have the SSISDB created during Azure SSIS IR setup and if IR is running successfully, you should be able to configure those in ADF activity. Please check the IR settings and let me know. Glad to help. Thanks.
Can we migrate packages built in VS 2012 to adf using SSIS integration runtime?
I guess yes. If there are compatibility issues, you may need to migrate packages.