Hello

My package is supposed transfer data from table to text file.
I read that I can use Dynamic Properties Task to make the package portable.
I added the Dynamic Properties Task and created global variable to SERVER_B
(My original package is on SERVER_A) then I saved the package as
my_pack.dts (on SERVER_A) and I would like to set global variable to run it
from SERVER_B (this SERVER has the same database with the same table
(structure, name....) but data is differernt)
By exec master..xp_cmdshell 'dtsrun /Fmy_pack /Nmy_pack /A”
Server:8=SERVER_B”'

I have got the error

DTSRun: Loading...
Error: -2147287038 (80030002); Provider Error: 0 (0)
Error string: The system cannot find the file specified.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 704
NULL
(10 row(s) affected)

Do you have a structured storage file of my_pack ? That is what the /F is
asking for and if you do not have one then it isn't going to work.

I do not have a Structured storage file of that name.

C:\>dtsrun /Fc:\MyPack.dts /NMyPack /AServer:8=(local)

C:\>dtsrun /Fc:\MyPack.dts /NMyPack /AServer:8=(local)
DTSRun: Loading...

Error: -2147287038 (80030002); Provider Error: 0 (0)
Error string: The system cannot find the file specified.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 704


I have created a package called MyPack.dts and save it to the root of C:\.
The package itself does nothing. Package runs and nothing happens.

C:\Documents and Settings\AMMitchell>dtsrun /Fc:\MyPack.dts /NMyPack
/AServer:8=(local)
DTSRun: Loading...
DTSRun: Executing...
DTSRun: Package execution complete.


Have a look at the switches to DTSRUN in BOL.



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote

Thanks

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