January 31, 2018 at 8:51 am
Hello SSC,
I have a simple SSIS package with a Source and Destination. The Source is a SQL Server view, the destination is a SQL Server Table.
I need to add a new column from the view into the destination table. The problem is that the DBA's have not added the column to the physical destination table yet, but they will. I am able to add the new column to the source and mapping, but when I try to add the new column to the destination, I am able to make the change and add it to the mapping. My issue is that when I check the destination, my changes are gone.
Can I add a column to a destination table that doesn't exist yet? The column not the table 🙂
The are no problems, only solutions. --John Lennon
January 31, 2018 at 8:58 am
Lord Slaagh - Wednesday, January 31, 2018 8:51 AMHello SSC,I have a simple SSIS package with a Source and Destination. The Source is a SQL Server view, the destination is a SQL Server Table.
I need to add a new column from the view into the destination table. The problem is that the DBA's have not added the column to the physical destination table yet, but they will. I am able to add the new column to the source and mapping, but when I try to add the new column to the destination, I am able to make the change and add it to the mapping. My issue is that when I check the destination, my changes are gone.
Can I add a column to a destination table that doesn't exist yet? The column not the table 🙂
AFAIK, you need to have the schema changes in place before modifying the package. Otherwise, you won't be able to compile it.
January 31, 2018 at 9:02 am
That makes sense 🙂
Thank you
The are no problems, only solutions. --John Lennon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply