troubleshooting Question

Split Table to 2 tables in DTS

Avatar of JMarais
JMarais asked on
Microsoft SQL Server
6 Comments1 Solution444 ViewsLast Modified:
I have one source table with field1, field2, field3 and field4.  I need to put field1 and field2 in DestinationTable1,  return (with @@Identity?) the DestinationTable1ID (which is a numeric identity column),  and then put that value in DestinationTable2 (foreign key pointing to DestinationTable1), along with field3 and field4.

I am a beginner, I have tried everything I could think of.  I could not execute stored procedures from within a Data Driven Query Task, maybe I'm on the wrong track completely.  Im using an SQL server 2000 database.  It has to be a DTS package.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros