How to deploy a DTS package?

#1

I developed an ActiveX script inside of a DTS package. Now I need to
install that DTS on another SqlServer which isn't on the same network
where the server where is was developed (so a simple Save as... ojn
the other server cannot work here).

This ActiveX uses two activeX dll's which are simple to deploy, but I
can't figure out how to do the same with the DTS.

How can I do that? Installers like InstallShield can deploy DTS
packages? If it isn't, which tool should I use?

Thanks in advance.

#2

you can save as to a .dts file and then open it on the new server.

"valmir cinquini" <vcinquini (AT) ig (DOT) com.br> a écrit dans le message de
news:ca07badb.0307101724.40748736 (AT) posting (DOT) google.com...

Quote:

I developed an ActiveX script inside of a DTS package. Now I need to
install that DTS on another SqlServer which isn't on the same network
where the server where is was developed (so a simple Save as... ojn
the other server cannot work here).

This ActiveX uses two activeX dll's which are simple to deploy, but I
can't figure out how to do the same with the DTS.

How can I do that? Installers like InstallShield can deploy DTS
packages? If it isn't, which tool should I use?

Thanks in advance.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.497 / Virus Database: 296 - Release Date: 2003-07-04

#3

You can have a look at this

Transferring DTS Packages
http://www.sqldts.com/default.aspx?6,105,204,0,1

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"valmir cinquini" <vcinquini (AT) ig (DOT) com.br> wrote

Quote:

I developed an ActiveX script inside of a DTS package. Now I need to
install that DTS on another SqlServer which isn't on the same network
where the server where is was developed (so a simple Save as... ojn
the other server cannot work here).

This ActiveX uses two activeX dll's which are simple to deploy, but I
can't figure out how to do the same with the DTS.

How can I do that? Installers like InstallShield can deploy DTS
packages? If it isn't, which tool should I use?

Thanks in advance.

#4

Thank you all. BTW, excuse me my bad English. It was late at night and
I was very tired.

Thans again

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

You can have a look at this

Transferring DTS Packages
http://www.sqldts.com/default.aspx?6,105,204,0,1

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"valmir cinquini" <vcinquini (AT) ig (DOT) com.br> wrote in message
news:ca07badb.0307101724.40748736 (AT) posting (DOT) google.com...
I developed an ActiveX script inside of a DTS package. Now I need to
install that DTS on another SqlServer which isn't on the same network
where the server where is was developed (so a simple Save as... ojn
the other server cannot work here).

This ActiveX uses two activeX dll's which are simple to deploy, but I
can't figure out how to do the same with the DTS.

How can I do that? Installers like InstallShield can deploy DTS
packages? If it isn't, which tool should I use?

Thanks in advance.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to deploy a DTS package?

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

How to deploy a DTS package? - 07-10-2003 , 08:24 PM

Re: How to deploy a DTS package? - 07-10-2003 , 10:16 PM

Re: How to deploy a DTS package? - 07-11-2003 , 01:29 AM

Re: How to deploy a DTS package? - 07-11-2003 , 08:15 AM