CSV File Extract
-
Hello
Does anyone know how I can extract multiple CSV files into a database table. CSV files are dumped every two hrs from an outsourcing team and I want to develop a package that will extract the CSV file once it has been dumped. (the CSV files are numbered as, CSV.01, CSV.02, CSV.03 and so on)
-
you can use a foreach loop to loop through the files in a directory, then use a dataflow task to pass the data across to your database.
tom
Life: it twists and turns like a twisty turny thing
-
Put a little thinking into the process and then proceed to draw it on visio or something that will visualize it. then proceed to findout
what is available in SSIS. I guess what I am saying, there are many ways to accomplish anything if you just sit and work into putting some little thinking.
😀
"We never plan to Fail, We just fail to plan":)
-
How you handle this is also dependent on processing requirements. To you have to process the files as they are created or as a batch over time (ie you may process 1 or more files depending on what is there waiting to be processed).
Also, what do you do with the file(s) once processed, archive or delete?
😎
-
Hi Guys
This is an overview, of what is intended, maybe that will give you a logical view of the process.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply