Phil Parkin (8/11/2010) Rich-403221 (8/11/2010)
Phil, my apologies.
Should have tried it a little more before I ASSUMED that SSIS would be logical. Guess it's not as straight forward as I thought.
No problem - and you learned something along the way, which is good :-)
SSIS is logical ... but perhaps it becomes so only after spending a lot of time with it. At some point, the philosophy 'clicks' and after that it becomes your friend.
Sorry for hijacking the thread. had this posted for almost a week without any luck so thought someone from this thread might be able to help.
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.
For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden