Lab2 Error while deploying SSIS Package in Data Factory 2
neu-mjaiswal opened this issue · 6 comments
Make sure that you have the SSIS Azure Feature Pack installed locally: https://www.microsoft.com/en-us/download/details.aspx?id=54798.
The instruction are unclear about what to do here. It says for each SQL Server connection configure the connection string, server name, and password. I only see the password field empty so i added the password there. The connection string and server name are already present so do they have to be replaced by the setting of the azure version of the DW, ODS and OLTP from the Azure console?
Further, does adflabstaging need to be replaced by adflabstorage with the corresponding connection string and key?
Please help!
Got same issue here. i am using ssms 2016 + sql 2016. and installed SSIS azure feature pack for 2016, still no luck. need help
Can you install the latest version of SSMS? Lab 2 pre-req mentions Azure Feature Pack for 2017 is needed (I don't think 2016 will work with the SSIS Integration Runtime) which also means probably need an updated version of SSMS.
did install azure FP for 2017 on SQL 2016, SSMSv17 and it was success but with different result. (only three rows from 4 rows previously)
Connection warnings are fine. After you deploy the lab has you reconfigure the connections to whatever your server names are in your resource group.