Hi, I am new to SSIS. I need to pull data from EDW.

can you please tell me which connection manger (OLEDB or ADO.NET ...)do we need to use to connect...

Hi, you have posted below string:

sqlcmd -Sservername -d myDB -E -Q "select col1, col2, col3 from SomeTable" -o "MyData.csv" -h-1 -s"," -w 700

In the above string you are deviding data...