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.

more ▼

asked Apr 02, 2015 at 05:36 AM in Default

avatar image

10 1 2 4

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Apr 07, 2015 at 12:33 PM

avatar image

40 4 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 02, 2015 at 05:36 AM

Seen: 429 times

Last Updated: Apr 07, 2015 at 12:33 PM

Copyright 2018 Redgate Software. Privacy Policy