How To Create First SSIS Package

Step 1 : First Install SSDT For Visual Studio From msdn site. For creating SSIS package . Select CheckBox of SQL Server Integration Services.

Step 2 : Open Visual Studio . Click File tab , Select New , Click Project .

Step 3 : When SSDT for Visual Studio Successfully installed. Then You can get Business Intelligence Template . Select ” Integration Services ” with Integration Services Project . Give Meaningful Name , Suitable Location and Click OK .

Step 4 : SSIS Package Design Mode Open . Here , You can drag and drop different Sources and various destination transformation or files. in Design You can get Control flow , data flow , parameters , event handlers , package explorer .

Step 5 :For creating new SSIS Package , Right click on SSIS Package , select new ” SSIS Package ” and click OK

Step 6 : Drag and Drop ” Data Flow Task ” into ” Control Flow ” then double click on Data Flow Task .

Step 7 : Drag and drop ” ADO.NET Source ” from Other sources into Data Flow .

Step 8 : right click on ADO NET Source and Edit

Step 9 : Click New button for setting ADO.NET Connection.

Step 10 : Fill the connection manager information . Server name ” localhost ” . use either Windows Authentication or SQL Server Authentication . if you select SQL Server Authentication . give user name and password. select radio button of select or enter a database name . choose any database and click on Test Connection .