Post reply

union

  • May 19, 2008 at 2:13 pm

    #154367

    How can i get union of 2 tables into 1 table with selected columns through ssis .

  • May 20, 2008 at 3:37 am

    #817663

    Use the Merge transformation:

    make sure both inputs are sored and the metadata (datatypes of the columns) should be the same.

  • May 21, 2008 at 1:20 pm

    #818825

    You can also enter a query as the data source to do the same. Use SSMS to get the query working the way you like then simply copy/paste the query into the OLE DB source connection.

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

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