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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy