patternsqlMinor
What happens to an SSIS package when I alter a table that is used as a destination?
Viewed 0 times
destinationpackagewhatusedssisthatwhenhappensaltertable
Problem
My apologizes if this question doesn't correspond to this site.
I have this question because in a SQL Server is deployed a SSIS Package (is a very old package) and I don't have the dtsx file.
Now I need to add some columns to a table, but this table is used as a destination on this package. So my question is, if I alter the table, will the package continue to work?
I have this question because in a SQL Server is deployed a SSIS Package (is a very old package) and I don't have the dtsx file.
Now I need to add some columns to a table, but this table is used as a destination on this package. So my question is, if I alter the table, will the package continue to work?
Solution
If you aren't changing the destination table name or the name or properties of any existing columns, then the package may continue to run without any changes.
If you need to actually include these new columns in your import, though, then you will probably need to update the package.
If you don't have the dtsx file, then I assume the package is published in an SSISDB?
Here are some articles that discuss editing/exporting a published package for different SQL/SSIS versions:
If you need to actually include these new columns in your import, though, then you will probably need to update the package.
If you don't have the dtsx file, then I assume the package is published in an SSISDB?
Here are some articles that discuss editing/exporting a published package for different SQL/SSIS versions:
- How to export a package from SSISDB?
- Editing Published SSIS Package in SQL Server 2012.
Context
StackExchange Database Administrators Q#190915, answer score: 4
Revisions (0)
No revisions yet.