Export all tables data to csv using SSIS
Step 1: Create 4 variables as shown in bellow Step 2: Create new ado.net connection Click on new to create connection Provide server name and DB name Click on OK Step 3: Rename connection name to DBConn as shown in bellow Step 4: Drag and drop script task Edit Select variables as shown in bellow Click on edit script Add new name spaces using System.IO; using System.Data.SqlClient; Under public void Main() { I have added below code. string datetime = DateTime.Now.ToString( "yyyyMMddHHmmss" ); try { //Declare Variables string DestinationFolder = Dts.Variables[ "User::DestinationFolder" ].Value.ToString(); string FileDelimiter = Dts.Variables[ "User::FileDelimiter" ].Value.ToString(); string FileExtension = Dts.Variables[ "User::FileExtension" ].Value.ToString(); //USE ADO.NET Connection from SSIS Package to get data from table ...