Column name gets change in source table SSIS issu

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  March 21, 2018 at 11:11 am

  #403192

  Hi All,

  I am facing some serious issue with SSIS package.

  In My project, I am having one DFT where the source is table and target is a table.

  there is another process which dumps the data from excel to stage table every month, and finally, I have to load data from that monthly table to target table

  but the problem is, they frequently change the some of the column name in the source file and same thing happening with staging table. In that case, my SSIS package gets failed.

  Now the requirement is to manage these things without the dynamic stored procedure.

  below is the screenshot of target and source table structure.

  I am desperately looking for this solutiion, thanks in advance.

  

• Phil Parkin

  SSC Guru

  Points: 246978

  More actions

  March 21, 2018 at 11:15 am

  #1984181

  vipin_jha123 - Wednesday, March 21, 2018 11:11 AM

  Hi All,

  I am facing some serious issue with SSIS package.

  In My project, I am having one DFT where the source is table and target is a table.

  there is another process which dumps the data from excel to stage table every month, and finally, I have to load data from that monthly table to target table

  but the problem is, they frequently change the some of the column name in the source file and same thing happening with staging table. In that case, my SSIS package gets failed.

  Now the requirement is to manage these things without the dynamic stored procedure.

  below is the screenshot of target and source table structure.

  I am desperately looking for this solutiion, thanks in advance.

  

  OK. But what is your question?

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 22, 2018 at 7:35 am

  #1984272

  vipin_jha123 - Wednesday, March 21, 2018 11:11 AM

  Hi All,

  I am facing some serious issue with SSIS package.

  In My project, I am having one DFT where the source is table and target is a table.

  there is another process which dumps the data from excel to stage table every month, and finally, I have to load data from that monthly table to target table

  but the problem is, they frequently change the some of the column name in the source file and same thing happening with staging table. In that case, my SSIS package gets failed.

  Now the requirement is to manage these things without the dynamic stored procedure.

  below is the screenshot of target and source table structure.

  I am desperately looking for this solutiion, thanks in advance.

  

  Best solution, establish a standard and require that it be used.  I did that at a previous employer as I could not see modifying SSIS (or DTS at the time) packages every time files needed to be imported.  It was unnecessary work on my part and having a standard for the files also made it easier those creating the files. Headers are headers, they shouldn't change.