SSIS Column mapping

• nothinghectic

  SSC Enthusiast

  Points: 151

  More actions

  January 30, 2014 at 12:25 am

  #396193

  Hi everyone,

  Ok so here is my situation.

  I have files in a folder.

  I am loop through a resultset which has the file names as one of the fields.

  When I get the current file,

  I want to be able to alter the column / transformation mapping based on the mapping table.

  The reason for this is that all the files don't have the same column order.

  Firstly, can this be done in SSIS?

  Secondly, how would I go about it

  Finaly, can you show me an example of that if it is possible.

  Thank you.

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  January 30, 2014 at 3:03 am

  #1684570

  Please do not crosspost. It wastes peoples time and fragments replies.

  I responded in your other thread:

  http://www.sqlservercentral.com/Forums/Topic1536210-364-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP