December 14, 2018 at 3:47 pm
Recently my client migrated from SQL Server 2012 to Azure, we had a equivalent ETL server for 2012 database. The problem is though database objects have been migrated successfully, since there is no equivalent for SSISDB database (for the ETL Server that we had with 2012 database) in the new Azure box.
We are not able to run the SSIS packages and jobs, gave a try using Azure task factory, but no use. Please let me know if there are any possibilities to have the ETL server related jobs replicated in the Azure.
Is there any workaround for this? Any ideas will be highly appreciated !!
Thanks.
December 15, 2018 at 1:28 am
shyamhr - Friday, December 14, 2018 3:47 PMRecently my client migrated from SQL Server 2012 to Azure, we had a equivalent ETL server for 2012 database. The problem is though database objects have been migrated successfully, since there is no equivalent for SSISDB database (for the ETL Server that we had with 2012 database) in the new Azure box.
We are not able to run the SSIS packages and jobs, gave a try using Azure task factory, but no use. Please let me know if there are any possibilities to have the ETL server related jobs replicated in the Azure.Is there any workaround for this? Any ideas will be highly appreciated !!
Thanks.
Can you tell us a little but more about your setup (VMs, etc.)?
😎
December 17, 2018 at 5:07 am
Are you in an Azure Virtual Machine (in which case, it's just Windows & SQL Server and should behave the same as a local instance of SQL Server) or are you in Azure SQL Database? From the description, it's unclear to me which situation we're talking about here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply