SSIS gives you the option to do data flows. In the toolbox under control flow items find Daat Flow Task and drag it over into the Package window. After that clck on the data flow tab. The the toolbox should have different options in it and choose your source whether it is excel, flat file, or a DB source and drag it into the data flow tab. After that in the data flow destination under toolbox choose OLE DB Destination and drag that into the window as well. After you have the two in the data flow window double click in the data source box and set up the Data connection. The drag the green arrow from the data source to the Data Destination. Then souble click on the data destination box and setup that data connection. After all this is done click back on the control tab and then click the play button.
answered Apr 07, 2015 at 12:33 PM