asked
How do we transfer excel files and flat files data in a folder to a sql server destination using ssis?
I have excel files and flat files of similar schema. I have to transfer those files data to a destination table in sql server. How can I do it in ssis? Any one pls hep me on it.
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.
15 People are following this question.
