Multiple Flat File Move to Sqlserver Table with file source and destinition path

Question

Actually what i have to do

i have some flat file with same file structure in one folder ,

than i have to move it in to one table in sql server along with i have to create one table which have file_name,source_file_path, Desti_Path, NoOfRecords and date_time of file.

Along with i have create one destinition folder which have those file along with file name like file1_01/24/2013.txt

Answer 1

Actually what i have to do

i have some flat file with same file structure in one folder ,

than i have to move it in to one table in sql server along with i have to create one table which have file_name,source_file_path, Desti_Path, NoOfRecords and date_time of file.

Along with i have create one destinition folder which have those file along with file name like file1_01/24/2013.txt

Answer 2

please answer somebody it's needed

Answer 3

Actually what i have to do

i have some flat file with same file structure in one folder ,

than i have to move it in to one table in sql server along with i have to create one table which have file_name,source_file_path, Desti_Path, NoOfRecords and date_time of file.

Along with i have create one destinition folder which have those file along with file name like file1_01/24/2013.txt

pleaseeeee helpppppppppp

Answer 4

Use a for each loop container to loop through files

Inside you can place a data flow task to transfer data

An execute SQL task to enter the file details if you want the files creation date then add a script task to load the file details using a directoryinfo and fileinfo objects.

A filesystem task will be needed to move the file with destination path aa an expression or a variable

The file name cannot contain / so use some other delimiter

---

--------------------------------------------------------

Surender Singh Bhadauria

My Blog

 

Answer 5

Hi Devesh,

1) Use foreach loop for the multiple files use for each file enumerator.

2) Use one DFT and one Execute SQL task in your for each container.

3) In For each loop use one variable which will get the filename along with path.

4) In first DFT use Row count tranform and use one SSIS variable to count the number of records and load the data in the destination.

5) in execute SQL task use insert statement

Insert into tablename values(?,?,?,?,getdate())

map all the corresponding variables which we made for file name and sourcepath and target path you know how you are getting and rowcount variable for number of records.

Please mark it as helpful if it helps.

Thanks

Sumit

Answer 6

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/331aa497-e0c1-49df-8510-b26db538814d

Answer 7

thank so Much SUMIT

Answer 8

SumitKumarDua  is correct, but you will also need to use a dynamic connection for the file.  The below link provides the steps necessary to create the data flow task to dynamically iterate throught the files in the folder:

http://sqlsafety.blogspot.com/2010/09/ssis-dynamic-connections.html

Hope this helps.

---

David Dye http://sqlsafety.blogspot.com/