Azure Migration - Unable to find SSIS DB

  • 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.

  • shyamhr - Friday, December 14, 2018 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.

    Can you tell us a little but more about your setup (VMs, etc.)?
    😎

  • 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