|
|
Thursday, January 11th, 2007
|
4:28p - ActiveX/vbscrpt and Transform Data Tasks
I've asked this question before in a vaguely similar form. Still beating my head against the problem when I get a few minutes free.
Is it possible to:
1. Set the destination table in a transform data task, and
2. Set up the transformations in a transform data task
...in an ActiveX Script task in the same DTS package (SQL Server 2000)? I've read a few extremely vague forum posts on a few disparate boards that make me believe this is possible. When I try the first, though, I always seem to modify the database name the package is pointing to, rather than the table within the database.
( code for step one, currently-- WARNING, long lines aheadCollapse )
not even close to figuring out where to start with step 2...
thanks.
(comment on this)
|
|
|
|
