locked
regarding ssis - changing source, how to adjust destination RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I am getting data with extra column it is a source, I want to move this data to destination

    but destination table have no one column

    how should i create a column in destination table


    • Edited by SSISJoostMVP Tuesday, February 4, 2014 5:22 PM Title too general
    Tuesday, February 4, 2014 10:49 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Open a new query in SSMS and issue

    ALTER TABLE tblname ADD columnname INT ---(or VARCHAR(n))

    Then map this column with the source ...

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Proposed as answer by Mike Yin Wednesday, February 5, 2014 9:31 AM
    • Marked as answer by Mike Yin Monday, February 17, 2014 4:54 PM
    Tuesday, February 4, 2014 10:54 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    you need to create it outside SSIS by connecting to SSMS and using query as below

    ALTER TABLE <TableName> ADD <ColumnName> <datatype> <NULL|NOT NULL>

    Then come back in SSIS and add the column in mapping tab to map to newly created destination table column.

    I hope this is a one time requirement and not something that happens in SSIS always.

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Proposed as answer by Mike Yin Wednesday, February 5, 2014 9:31 AM
    • Marked as answer by Mike Yin Monday, February 17, 2014 4:54 PM
    Tuesday, February 4, 2014 12:35 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Open a new query in SSMS and issue

    ALTER TABLE tblname ADD columnname INT ---(or VARCHAR(n))

    Then map this column with the source ...

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Proposed as answer by Mike Yin Wednesday, February 5, 2014 9:31 AM
    • Marked as answer by Mike Yin Monday, February 17, 2014 4:54 PM
    Tuesday, February 4, 2014 10:54 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    If you are getting that extra column from your source constantly, then you can add column in your destination table.

    Thanks,

    Anilkumar

    Tuesday, February 4, 2014 11:40 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    you need to create it outside SSIS by connecting to SSMS and using query as below

    ALTER TABLE <TableName> ADD <ColumnName> <datatype> <NULL|NOT NULL>

    Then come back in SSIS and add the column in mapping tab to map to newly created destination table column.

    I hope this is a one time requirement and not something that happens in SSIS always.

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Proposed as answer by Mike Yin Wednesday, February 5, 2014 9:31 AM
    • Marked as answer by Mike Yin Monday, February 17, 2014 4:54 PM
    Tuesday, February 4, 2014 12:35 PM