Lab2 Error while deploying SSIS Package in Data Factory 2

kromerm / adflab

Azure Data Factory hands-on lab, self-paced. Learn how to lift & shift SSIS packages to the Cloud with ADF. Build new ETL pipelines in ADF, transform data at scale, load Azure Data Warehouse data marts. Also walks through operationalizing ADF pipelines with scheduling and monitoring modules.

http://aka.ms/adflab2

137 stars 129 forks source link

Lab2 Error while deploying SSIS Package in Data Factory 2 #16

Open neu-mjaiswal opened 6 years ago

neu-mjaiswal commented 6 years ago

lab 2 error when deploying ssis package capture

kromerm commented 6 years ago

Make sure that you have the SSIS Azure Feature Pack installed locally: https://www.microsoft.com/en-us/download/details.aspx?id=54798.

shivankitsharma commented 6 years ago

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!

maadityo commented 6 years ago

Got same issue here. i am using ssms 2016 + sql 2016. and installed SSIS azure feature pack for 2016, still no luck. need help

joshuha commented 6 years ago

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.

maadityo commented 6 years ago

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)

joshuha commented 6 years ago

Connection warnings are fine. After you deploy the lab has you reconfigure the connections to whatever your server names are in your resource group.