dbTalk Databases Forums  

Migrate Active Script

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Migrate Active Script in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stanley
 
Posts: n/a

Default Migrate Active Script - 10-06-2006 , 02:50 AM






Could you tell me how to migrate the DTS which has the Active Script included
or do you have any other suggestion for me?

Many thanks,

Reply With Quote
  #2  
Old   
Charles Kangai
 
Posts: n/a

Default RE: Migrate Active Script - 10-06-2006 , 05:28 AM






You can try and use the migration wizard. It only does a best effort job and
unless your ActiveX scripts are very simple, they will probably not work as
intended. You need to re-write them using SSIS Script Task. As a starter, you
can go through the tutorial.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email: charles at kangai.demon.co.uk

"Stanley" wrote:

Quote:
Could you tell me how to migrate the DTS which has the Active Script included
or do you have any other suggestion for me?

Many thanks,

Reply With Quote
  #3  
Old   
Klaus Oberdalhoff
 
Posts: n/a

Default Re: Migrate Active Script - 10-06-2006 , 11:22 AM



Hi,

Quote:
Could you tell me how to migrate the DTS which has the Active Script
included or do you have any other suggestion for me?
this pages is a good starter for more info about SSIS (not DTS), i think

http://msdn2.microsoft.com/en-us/sql/aa336312.aspx

specially the webcasts maybe interesting

http://www.google.de/search?hl=en&q=blog+Microsoft+ssis

here you'll find some blogs

--
mfg

Klaus Oberdalhoff KObd (AT) gmx (DOT) de
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.