July 21, 2011 at 3:30 pm
I have used for each loop and then data flow task.
I am able load my table also.
But i also need one additional column in my sql table so that i can recognize the data i have in my table came from whoch text file.
can some 1 help me.(in each text file data format is same and in numbers like 1112222333333300000000 and each file has various records.)
If some1 knows about it plz let me know.
dev01
July 22, 2011 at 8:12 am
If I understand your question clearly then I think you can use a derived column before the actual load task. There shoul be some value which differs the imput file. Depending on that derived column value you can fill the additional column in the table.
July 22, 2011 at 11:18 am
July 22, 2011 at 11:50 am
Good article.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply