I have some text files and I want to import those text files one by one to my database and then apply some updates and extract the files again one by one in .csv format. I want to achieve this using for each loop.. How do I do this?
Please help!!
Asked
Active
Viewed 91 times
0
-
what have you tried/where are you stuck at? Using a foreach loop and a couple of variables will get you what you want. here is an answer that I did a while ago which should give you a good start on figuring it out. http://stackoverflow.com/questions/38151342/ssis-how-to-loop-through-files-in-folder-and-get-pathfile-names-and-finally-e – Matt Nov 18 '16 at 17:11
1 Answers
0
This task requires the use of the File System component in SQL. This component has an "Operation" setting in the menu that allows it to fill several rows, including copying/moving/deleting files, creating directories and more.
Let's break this down to several tasks:
1. Loop through the text files (that I assume are located in one folder and have the same structure). Take a look at this Stackoverflow answer
2. Create a new CSV destination file for each source file and output to them. This is the same idea as step one, just setup a template CSV file in a "neutral" location and copy it each time (don't use the original).
Try this out, let us know what you did and where you get stuck and we can help you out some more.
Good luck!
