How to Migrating DTS To SSIS Packages

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

How to Migrating DTS To SSIS Packages

Author

Topic

satishvsh
Starting Member

41 Posts

Posted - 2008-07-09 : 16:11:22

Friends :

How to migrate DTS to ssis packages which is having Activex Scripts.

today i migrated lot of packages but some packages are having activex scripts which is getting error when i execute it on SSIS.

Please adivse and provide me steps

Cheers
satish

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-09 : 16:20:30

You will have to rewrite in Script task.

satishvsh
Starting Member

41 Posts

Posted - 2008-07-09 : 16:22:47

quote:
Originally posted by sodeep

You will have to rewrite in Script task.

You mean we need to rewrite the activex script in sql server 2005.

Is there any tool that will convert.

thanks
satish

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-09 : 16:25:14

Especially for Activexscript which points to Object model(Com object).

You can use Dts xchange
http://pragmaticworks.com/community/blogs/dtsxchange/default.aspx

maninder
Posting Yak Master

100 Posts

Posted - 2008-07-09 : 16:32:48

Eventually you will have to rewrite all the DTS into SSIS.
Did you check all the connections after migration.
ActiveX Scripts will be created as a new object in SSIS version of DTS.
When making the upgrade, you will need to determine how you will manage these legacy DTS packages in the future.
The ActiveX Script might be making references to DTS Properties, which are not valid in SSIS.

Maninder
SQL server Architect / Admin (DEV&PROD)

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-09 : 16:37:01

quote:
Originally posted by maninder

Eventually you will have to rewrite all the DTS into SSIS.
Did you check all the connections after migration.
ActiveX Scripts will be created as a new object in SSIS version of DTS.
When making the upgrade, you will need to determine how you will manage these legacy DTS packages in the future.
The ActiveX Script might be making references to DTS Properties, which are not valid in SSIS.

Maninder
SQL server Architect / Admin (DEV&PROD)

Not necessarily. You can use environment variable to define connection in Package configuration.

satishvsh
Starting Member

41 Posts

Posted - 2008-07-09 : 16:51:27

quote:
Originally posted by sodeep

quote:
Originally posted by maninder

Eventually you will have to rewrite all the DTS into SSIS.
Did you check all the connections after migration.
ActiveX Scripts will be created as a new object in SSIS version of DTS.
When making the upgrade, you will need to determine how you will manage these legacy DTS packages in the future.
The ActiveX Script might be making references to DTS Properties, which are not valid in SSIS.

Maninder
SQL server Architect / Admin (DEV&PROD)

Not necessarily. You can use environment variable to define connection in Package configuration.

So could you please suggests me what steps do i need to do.

!, Rewrite Activex scripts.

or

2, Implementing tool. ( where i can download this DTSXchange tool)
using this tool do i need to remigrate those packages which are having activex scripts.

please advise

cheers
satish

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-09 : 21:54:04

Yes you have rewrite it with script task or For/Each loop container.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources