SSIS-one source to 3 destination tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » SSIS-one source to 3 destination tables

SSIS-one source to 3 destination tables

Rate Topic

Display Mode

Topic Options

Author

Message

rmahon

Posted Monday, October 22, 2012 12:24 PM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 9:52 AM
Points: 38, Visits: 181

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

Koen Verbeeck

Posted Tuesday, October 23, 2012 12:39 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:54 AM
Points: 9,364, Visits: 6,462

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

P Jones

Posted Wednesday, October 24, 2012 6:12 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 1:58 AM
Points: 513, Visits: 1,014

Otherwise you could populate a master table and then copy that to the other two, enabling identity insert.

Post #1376428

« Prev Topic | Next Topic »

Permissions