SSIS adding new columns to existing table

  • sunshine

    SSC Enthusiast

    Points: 114

    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

  • Site Owners

    SSC Guru

    Points: 80385

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

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

  • Lowell

    SSC Guru

    Points: 323376

    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 3 (of 3 total)

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