Post reply

SSIS adding new columns to existing table

  • August 23, 2019 at 10:19 pm

    #3674110

    Hello All,

    I am working in SSIS (Sql server version 2012) , I have a requirement to add two new columns to a destination table which already has five years of data. How can i add these two new columns and bring data to the destination table which already has 5 years of data.

    Thanks

  • August 24, 2019 at 11:10 pm

    #3674210

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • August 25, 2019 at 11:44 pm

    #3674285

    qadding the columns them selves is just a DDL operation. you would not need to do that inside SSIS.

    ALTER TABLE ADD Column1 varchar(etc...

    i suspect you mean what about the data that is going to go INTO the new columns.

    That's where you need to explain quite a bit more.

    you didn't say what the new column values would contain. can they be calculated form existing data? are they just a calculation?

    can the data be re-imported with the new columns*(ie they were ignored before?)

    I am just guessing here, but can you import old data to a staging table, and update the exiting data so the new columns are populated??

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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