SSIS Dynamic Property

  • I have a SSIS package where I use filename and staging names as variables and pass the variables as parameters in script... this works fine... I am able to change the table name and load the file; however, when I try to add column in the file and add in the staging table and then try to load the file, the new column added in the file doesnt get loaded in the added field...flat file source editor doesnt show the new column as well... is there a way to fix this?

  • I don't think you can get the package to auto-adapt to this, you likely could manipulate the package with the object model.

    CEWII

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

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