Loading one sql table with multiple text files

• Ritesh_Dev

  Ten Centuries

  Points: 1299

  More actions

  July 21, 2011 at 3:30 pm

  #241120

  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

• radb4u

  SSC Eights!

  Points: 917

  More actions

  July 22, 2011 at 8:12 am

  #1357067

  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.

• Chrissy321

  SSCoach

  Points: 15787

  More actions

  July 22, 2011 at 11:18 am

  #1357203

  http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/67871/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 22, 2011 at 11:50 am

  #1357212

  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/