Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikejohnson
Posting Yak Master
153 Posts |
 Posted - 2004-07-09 : 11:46:33
|
| in my dts package i need to split one table into two basically. lets assume this is my table structuretransactionid customername------------- ------------ 1 mike 2 johnwhen i run the dts package, i will have two tables like so:CUSTOMERScustomerid customername------------- ------------ 1 mike 2 johnTRANSACTIONSid transactionid customerid-- ------------- ----------1 1 12 2 2my customerid will be autoincremented, so how do i get the customerid in the transactions table? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
splitting data