Dynamic Data Export
-
Hi guys,
Posting after a long time. How is everyone doing?
I was working on an SSIS project in which I need to:
1. Loop through a folder containing multiple text files and get their name into a variable.
2. Append the current system date to that variable so that the variable now contains txtfilename + Date.
3. Create a table in the database with the name as value of the variable.
4. Transfer data of the txt file into the newly created table.
The first two steps I accomplished using a For Each Loop Container and i am able to get the file name into the variable.
The second step I accomplished by just appending GetDate() to the value of the variable.
The third step I accomplished using an Execute SQL task for creating table.
What i am not able to do is get the data into the table with a Data Flow Task.
The problem is that it requires me to give table name as input, which i cannot as the table is being created by the same package dynamically. I need to automate this task so I would always have to create the table dynamically.
Please be patient enough to go through my problem and provide a solution. Thanks a tonne in advance.
PS: I am not very good with C# or other scripting languages so I won't be able to work with a
Scripting task in SSIS. So, please give me a solution other than scripting.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply