Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS-one source to 3 destination tables Expand / Collapse
Author
Message
Posted Monday, October 22, 2012 12:24 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:21 PM
Points: 38, Visits: 267
I have one csv that needs to be distributed to 3 tables using SSIS. I am using the Multicast Transformation task to send data to the respected tables.

My issue is that the 3 tables that have 2 identity fields in all three...UNIQUE_KEY(newid()) and UNIQUE_ID(is identity=yes) and need to keep the UNIQUE_ID the same in all tables during the insert. This is pretty pressing issue and I have exhausted my efforts...need the experts. I have been away from SSIS for while and now getting back into it! Any help is appreciated.



Post #1375667
Posted Tuesday, October 23, 2012 12:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 13,359, Visits: 10,223
Is your SSIS package the only source for the tables?
If yes, you can generate the IDs yourself in the package and insert them into the tables.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1375853
Posted Wednesday, October 24, 2012 6:12 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:19 AM
Points: 559, Visits: 1,161
Otherwise you could populate a master table and then copy that to the other two, enabling identity insert.
Post #1376428
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse