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 |
|
pazzy11
Posting Yak Master
145 Posts |
 Posted - 2008-02-01 : 09:49:07
|
| HiI have migrated a DTS that had some activeX transformation tasks within data pump flow tasks.Those parts were migrated as "DTS 2000 tasks" .. so activeX transformation tasks aren't possible in SSIS ?I know ActiveX script tasks are but for transformations ?1. IF i leave these Encapsulated DTS 2000 tasks in the migrated SSIS package, will it run independently of the originalDTS or does it need the old DTS running to "call" that part from ? (I hope im making sense here)is it possible to load this functionality internally into the new SSIS ?2.How could I (if i can't do ActiveX transformation tasks) achieve this is SSIS ?can I achive this using the script tasks in SSIS ? |
|
|
|
|
|
SSIS and active X transformation tasks