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.