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 |
|
redzex
Starting Member
3 Posts |
 Posted - 2006-08-23 : 03:05:28
|
| i have a question to the experts because i know it is possible using an activeX but don't know how to do it.i have a table dbo.Tbl_Tables_Lkup that has columns [Source], [Destination], [TransferFlag]i want my DTS dts_Xfer_Tables to transfer data from tables based from the lookup table source and destination, and consider the TransferFlag value. If '1' means transfer it, and if '0' not to transfer it.thanks,Redzex |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-08-23 : 18:21:18
|
| It might be easier to do it without ActiveX.Just import the data into a staging table, then execute a stored proc to move the data into your production tables. The INSERT query can reference your lookup table to determine what gets imported. |
 |
|
|
|
|
|
DTS and a Lookup Table