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 |
|
SQLfriends
Starting Member
12 Posts |
 Posted - 2002-09-26 : 12:05:09
|
| While using Transform Data Task on the DTS Design sheet, is it possible that we refer to a dynamically generated table as the destination instead of tables that already existed?Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-26 : 12:17:08
|
| Not in design view. You would have to write some code to change the destination using the DTS object model. |
 |
|
|
SQLfriends
Starting Member
12 Posts |
Posted - 2002-09-26 : 12:27:13
|
| Thanks for your reply, robvolk. Can you show me some hyper-links where I can read and learn how to write code to refer to a dynamically generated table as destination (Data Transformation Task)? Anybody else who know some good links are welcomed as well. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Transform Data Task