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, March 10, 2014 1:21 PM
Points: 885, Visits: 1,526
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,

A Democracy works great until the day you find yourself on the sheep side of a vote between 5 wolves and 4 sheep on what’s for dinner when neither have eaten in many days. A free Republic where the rights of the few and the individual are protected is the only one in which Freedom and Prosperity for all have a chance to blossom.
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 01, 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