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: 246693

  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?

  If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

• 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.