Column name gets change in source table SSIS issu

  • vipin_jha123

    Hall of Fame

    Points: 3085

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

    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 the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • Lynn Pettis

    SSC Guru

    Points: 442205

    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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply