import a dts package

Hi i was wodering how can i transfer a developed dts package from sqlserver
to an installed MSDE2000.
Hi Yaniv,
Easiest is probably to save it to a file, and run the file using dtsrun
(which does come with the MSDE).
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"yaniv" <yaniv@.discussions.microsoft.com> wrote in message
news:43B7014E-41A4-4534-8249-D2B32E6225C1@.microsoft.com...
> Hi i was wodering how can i transfer a developed dts package from
> sqlserver
> to an installed MSDE2000.
>
|||nevermind found a way.
a simple VBScript that imports the file.dts :
Const DTSSQLStgFlag_UseTrustedConnection = 256
dim ServerName,dtsFilePath,userPassword
Dim dtsp, dtsPkg
ServerName = "server"
dtsFilePath = "d:\path\File.dts"
userPassword = ""
Set dtsPkg = CreateObject("DTS.Package")
dtsp = dtsPkg.LoadFromStorageFile(dtsFilePath,userPasswor d)
dtsPkg.SaveToSQLServer ServerName, "","" ,DTSSQLStgFlag_UseTrustedConnection
|||Hi Greg,
I have installed latest MSDE 2000 Rel A.
I do not see and file named dtsrun.
What am I missing?
Thanks
"Greg Low [MVP]" wrote:

> Hi Yaniv,
> Easiest is probably to save it to a file, and run the file using dtsrun
> (which does come with the MSDE).
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "yaniv" <yaniv@.discussions.microsoft.com> wrote in message
> news:43B7014E-41A4-4534-8249-D2B32E6225C1@.microsoft.com...
>
>
|||Nevermind. My mistake. Thanks
"Subhojit Banerjee" wrote:
[vbcol=seagreen]
> Hi Greg,
> I have installed latest MSDE 2000 Rel A.
> I do not see and file named dtsrun.
> What am I missing?
> Thanks
>
> "Greg Low [MVP]" wrote: