Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

How to import Multiple data files (cvs files) into a single Table Expand / Collapse
Author
Message
Posted Thursday, September 19, 2013 12:36 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:59 AM
Points: 886, Visits: 1,544
kocamisu (9/19/2013)
Hi,

You need just a flat file source and ole db destination in data flow.

Also one multiple flat file connection manager and one connection manager to connect your db.

Now,in multiple flat file connection manager ;

In general tab choose your all csv files.You must define your "header row delimiter" as "vertical bar {|}" and format "demilited",if your files are delimited.
If your files have column name also click "columns names in the first row" in general tab.

Thats all.Run it.


Thanks Kocamisu for the suggestion and taking the time to reply constructively unlike some others.


Kindest Regards,

Just say No to Facebook!
Post #1496552
Posted Thursday, September 19, 2013 1:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 1, 2013 2:58 AM
Points: 4, Visits: 19
YSLGuru (9/19/2013)
kocamisu (9/19/2013)
Hi,

You need just a flat file source and ole db destination in data flow.

Also one multiple flat file connection manager and one connection manager to connect your db.

Now,in multiple flat file connection manager ;

In general tab choose your all csv files.You must define your "header row delimiter" as "vertical bar {|}" and format "demilited",if your files are delimited.
If your files have column name also click "columns names in the first row" in general tab.

Thats all.Run it.


Thanks Kocamisu for the suggestion and taking the time to reply constructively unlike some others.


Its my pleasure YSLGuru
Post #1496564
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse