Hi,

I have some pb to import DTS form .dts file when i save it from Serveur1 and
import to Serveur2.

My DTS are most use to import/export data from/to text file, and when i
develop DTS on Server1, the path of the text file is different of the path
od the text file on Serveur2. So, when i open .dts file, i have an error !

How can i develop DTS from Serveur 1, save it to .dts file, and restore it
to Serveur2

Thank's by advance !


Gislain ROCHE

The name of the text file is always going to be a problem and there is
no direct route to moving a package and changing connection info in
between.

You can however parameterise the Text file connection and populate at
runtime. You can do this a number of ways (Dynamic Properties Task,
DTSRUN /A and Active Script, Database table that stores parameter
values)

Have a look at

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)

How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)


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