Running a dtsx package

#1

Good Afternoon,

i tried this thread on a .NET Forum, and it seems that this forum would a
more likely candidate for help. What i am trying to do is run a DTSX package
from the file server, not the sql server. there are many ways to do this,
but i seem to be going nowhere. Thanks for your help!

{
I have tried this many ways, to no success.

I am trying to run a dtsx package, from a simple app. My latest error is
stating need an event.

here is what is have:

Dim oApp As DTSLib.Application
Dim oPkg As DTS.Package = oApp.LoadPackage("myFilePath", False,[here
is the problem])

oPkg.Execute()
oPkg.UnInitialize()
oPkg = Nothing

There are two thing that are confusing:

1. In many examples, i see that the variable oApp is of Type DTS.Application.
If i do that, it does not give an option to "load a package".

2. The error i am getting is: "Argument not specified for parameter pEvents".

it says it needs to be of type DTSLib.IDTSEvents90.

Hopefully this makes sense to someone!! Is there another method to run this
"dtsx" package?
It seems easier if you have a dts package, but dtsx is all that i get.

thanks for any info in advance, this has kept me up nights.
}

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200807/1

#2

After a few changes, I was able to see different options. Here is what i
have now, and it seems to be okay, but it errors out.

Dim mypkg As New DTS.Package
mypkg.LoadFromStorageFile("\\Srcrm2\SR_SQL\SR_SQL\ dpkg_Updates.dtsx",
"{my pwd}", "{pkg ID}", "{my VersionID}", "dpkg_Updates")

mypkg.Execute()
mypkg.UnInitialize()
mypkg = Nothing

seems to be okay, but i get the error "The specified file is not a Package
Storage File."

i seem to be going in circles. there has got to be a way to do this.

Krzysztof wrote:

Quote:

Good Afternoon,

i tried this thread on a .NET Forum, and it seems that this forum would a
more likely candidate for help. What i am trying to do is run a DTSX package
from the file server, not the sql server. there are many ways to do this,
but i seem to be going nowhere. Thanks for your help!

{
I have tried this many ways, to no success.

I am trying to run a dtsx package, from a simple app. My latest error is
stating need an event.

here is what is have:

Dim oApp As DTSLib.Application
Dim oPkg As DTS.Package = oApp.LoadPackage("myFilePath", False,[here
is the problem])

oPkg.Execute()
oPkg.UnInitialize()
oPkg = Nothing

There are two thing that are confusing:

1. In many examples, i see that the variable oApp is of Type DTS.Application.
If i do that, it does not give an option to "load a package".

2. The error i am getting is: "Argument not specified for parameter pEvents".

it says it needs to be of type DTSLib.IDTSEvents90.

Hopefully this makes sense to someone!! Is there another method to run this
"dtsx" package?
It seems easier if you have a dts package, but dtsx is all that i get.

thanks for any info in advance, this has kept me up nights.
}

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200807/1

#3

After a few changes, I was able to see different options. Here is what i
have now, and it seems to be okay, but it errors out.

Dim mypkg As New DTS.Package
mypkg.LoadFromStorageFile("\\Srcrm2\SR_SQL\SR_SQL\ dpkg_Updates.dtsx",
"{my pwd}", "{pkg ID}", "{my VersionID}", "dpkg_Updates")

mypkg.Execute()
mypkg.UnInitialize()
mypkg = Nothing

seems to be okay, but i get the error "The specified file is not a Package
Storage File."

i seem to be going in circles. there has got to be a way to do this.

Krzysztof wrote:

Quote:

Good Afternoon,

i tried this thread on a .NET Forum, and it seems that this forum would a
more likely candidate for help. What i am trying to do is run a DTSX package
from the file server, not the sql server. there are many ways to do this,
but i seem to be going nowhere. Thanks for your help!

{
I have tried this many ways, to no success.

I am trying to run a dtsx package, from a simple app. My latest error is
stating need an event.

here is what is have:

Dim oApp As DTSLib.Application
Dim oPkg As DTS.Package = oApp.LoadPackage("myFilePath", False,[here
is the problem])

oPkg.Execute()
oPkg.UnInitialize()
oPkg = Nothing

There are two thing that are confusing:

1. In many examples, i see that the variable oApp is of Type DTS.Application.
If i do that, it does not give an option to "load a package".

2. The error i am getting is: "Argument not specified for parameter pEvents".

it says it needs to be of type DTSLib.IDTSEvents90.

Hopefully this makes sense to someone!! Is there another method to run this
"dtsx" package?
It seems easier if you have a dts package, but dtsx is all that i get.

thanks for any info in advance, this has kept me up nights.
}

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200807/1

#4

After a few changes, I was able to see different options. Here is what i
have now, and it seems to be okay, but it errors out.

Dim mypkg As New DTS.Package
mypkg.LoadFromStorageFile("\\Srcrm2\SR_SQL\SR_SQL\ dpkg_Updates.dtsx",
"{my pwd}", "{pkg ID}", "{my VersionID}", "dpkg_Updates")

mypkg.Execute()
mypkg.UnInitialize()
mypkg = Nothing

seems to be okay, but i get the error "The specified file is not a Package
Storage File."

i seem to be going in circles. there has got to be a way to do this.

Krzysztof wrote:

Quote:

Good Afternoon,

i tried this thread on a .NET Forum, and it seems that this forum would a
more likely candidate for help. What i am trying to do is run a DTSX package
from the file server, not the sql server. there are many ways to do this,
but i seem to be going nowhere. Thanks for your help!

{
I have tried this many ways, to no success.

I am trying to run a dtsx package, from a simple app. My latest error is
stating need an event.

here is what is have:

Dim oApp As DTSLib.Application
Dim oPkg As DTS.Package = oApp.LoadPackage("myFilePath", False,[here
is the problem])

oPkg.Execute()
oPkg.UnInitialize()
oPkg = Nothing

There are two thing that are confusing:

1. In many examples, i see that the variable oApp is of Type DTS.Application.
If i do that, it does not give an option to "load a package".

2. The error i am getting is: "Argument not specified for parameter pEvents".

it says it needs to be of type DTSLib.IDTSEvents90.

Hopefully this makes sense to someone!! Is there another method to run this
"dtsx" package?
It seems easier if you have a dts package, but dtsx is all that i get.

thanks for any info in advance, this has kept me up nights.
}

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200807/1

#5

After a few changes, I was able to see different options. Here is what i
have now, and it seems to be okay, but it errors out.

Dim mypkg As New DTS.Package
mypkg.LoadFromStorageFile("\\Srcrm2\SR_SQL\SR_SQL\ dpkg_Updates.dtsx",
"{my pwd}", "{pkg ID}", "{my VersionID}", "dpkg_Updates")

mypkg.Execute()
mypkg.UnInitialize()
mypkg = Nothing

seems to be okay, but i get the error "The specified file is not a Package
Storage File."

i seem to be going in circles. there has got to be a way to do this.

Krzysztof wrote:

Quote:

Good Afternoon,

i tried this thread on a .NET Forum, and it seems that this forum would a
more likely candidate for help. What i am trying to do is run a DTSX package
from the file server, not the sql server. there are many ways to do this,
but i seem to be going nowhere. Thanks for your help!

{
I have tried this many ways, to no success.

I am trying to run a dtsx package, from a simple app. My latest error is
stating need an event.

here is what is have:

Dim oApp As DTSLib.Application
Dim oPkg As DTS.Package = oApp.LoadPackage("myFilePath", False,[here
is the problem])

oPkg.Execute()
oPkg.UnInitialize()
oPkg = Nothing

There are two thing that are confusing:

1. In many examples, i see that the variable oApp is of Type DTS.Application.
If i do that, it does not give an option to "load a package".

2. The error i am getting is: "Argument not specified for parameter pEvents".

it says it needs to be of type DTSLib.IDTSEvents90.

Hopefully this makes sense to someone!! Is there another method to run this
"dtsx" package?
It seems easier if you have a dts package, but dtsx is all that i get.

thanks for any info in advance, this has kept me up nights.
}

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200807/1

#6

After a few changes, I was able to see different options. Here is what i
have now, and it seems to be okay, but it errors out.

Dim mypkg As New DTS.Package
mypkg.LoadFromStorageFile("\\Srcrm2\SR_SQL\SR_SQL\ dpkg_Updates.dtsx",
"{my pwd}", "{pkg ID}", "{my VersionID}", "dpkg_Updates")

mypkg.Execute()
mypkg.UnInitialize()
mypkg = Nothing

seems to be okay, but i get the error "The specified file is not a Package
Storage File."

i seem to be going in circles. there has got to be a way to do this.

Krzysztof wrote:

Quote:

Good Afternoon,

i tried this thread on a .NET Forum, and it seems that this forum would a
more likely candidate for help. What i am trying to do is run a DTSX package
from the file server, not the sql server. there are many ways to do this,
but i seem to be going nowhere. Thanks for your help!

{
I have tried this many ways, to no success.

I am trying to run a dtsx package, from a simple app. My latest error is
stating need an event.

here is what is have:

Dim oApp As DTSLib.Application
Dim oPkg As DTS.Package = oApp.LoadPackage("myFilePath", False,[here
is the problem])

oPkg.Execute()
oPkg.UnInitialize()
oPkg = Nothing

There are two thing that are confusing:

1. In many examples, i see that the variable oApp is of Type DTS.Application.
If i do that, it does not give an option to "load a package".

2. The error i am getting is: "Argument not specified for parameter pEvents".

it says it needs to be of type DTSLib.IDTSEvents90.

Hopefully this makes sense to someone!! Is there another method to run this
"dtsx" package?
It seems easier if you have a dts package, but dtsx is all that i get.

thanks for any info in advance, this has kept me up nights.
}

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200807/1

#7

After a few changes, I was able to see different options. Here is what i
have now, and it seems to be okay, but it errors out.

Dim mypkg As New DTS.Package
mypkg.LoadFromStorageFile("\\Srcrm2\SR_SQL\SR_SQL\ dpkg_Updates.dtsx",
"{my pwd}", "{pkg ID}", "{my VersionID}", "dpkg_Updates")

mypkg.Execute()
mypkg.UnInitialize()
mypkg = Nothing

seems to be okay, but i get the error "The specified file is not a Package
Storage File."

i seem to be going in circles. there has got to be a way to do this.

Krzysztof wrote:

Quote:

Good Afternoon,

i tried this thread on a .NET Forum, and it seems that this forum would a
more likely candidate for help. What i am trying to do is run a DTSX package
from the file server, not the sql server. there are many ways to do this,
but i seem to be going nowhere. Thanks for your help!

{
I have tried this many ways, to no success.

I am trying to run a dtsx package, from a simple app. My latest error is
stating need an event.

here is what is have:

Dim oApp As DTSLib.Application
Dim oPkg As DTS.Package = oApp.LoadPackage("myFilePath", False,[here
is the problem])

oPkg.Execute()
oPkg.UnInitialize()
oPkg = Nothing

There are two thing that are confusing:

1. In many examples, i see that the variable oApp is of Type DTS.Application.
If i do that, it does not give an option to "load a package".

2. The error i am getting is: "Argument not specified for parameter pEvents".

it says it needs to be of type DTSLib.IDTSEvents90.

Hopefully this makes sense to someone!! Is there another method to run this
"dtsx" package?
It seems easier if you have a dts package, but dtsx is all that i get.

thanks for any info in advance, this has kept me up nights.
}

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200807/1

#8

After a few changes, I was able to see different options. Here is what i
have now, and it seems to be okay, but it errors out.

Dim mypkg As New DTS.Package
mypkg.LoadFromStorageFile("\\Srcrm2\SR_SQL\SR_SQL\ dpkg_Updates.dtsx",
"{my pwd}", "{pkg ID}", "{my VersionID}", "dpkg_Updates")

mypkg.Execute()
mypkg.UnInitialize()
mypkg = Nothing

seems to be okay, but i get the error "The specified file is not a Package
Storage File."

i seem to be going in circles. there has got to be a way to do this.

Krzysztof wrote:

Quote:

Good Afternoon,

i tried this thread on a .NET Forum, and it seems that this forum would a
more likely candidate for help. What i am trying to do is run a DTSX package
from the file server, not the sql server. there are many ways to do this,
but i seem to be going nowhere. Thanks for your help!

{
I have tried this many ways, to no success.

I am trying to run a dtsx package, from a simple app. My latest error is
stating need an event.

here is what is have:

Dim oApp As DTSLib.Application
Dim oPkg As DTS.Package = oApp.LoadPackage("myFilePath", False,[here
is the problem])

oPkg.Execute()
oPkg.UnInitialize()
oPkg = Nothing

There are two thing that are confusing:

1. In many examples, i see that the variable oApp is of Type DTS.Application.
If i do that, it does not give an option to "load a package".

2. The error i am getting is: "Argument not specified for parameter pEvents".

it says it needs to be of type DTSLib.IDTSEvents90.

Hopefully this makes sense to someone!! Is there another method to run this
"dtsx" package?
It seems easier if you have a dts package, but dtsx is all that i get.

thanks for any info in advance, this has kept me up nights.
}

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200807/1

#9

After a few changes, I was able to see different options. Here is what i
have now, and it seems to be okay, but it errors out.

Dim mypkg As New DTS.Package
mypkg.LoadFromStorageFile("\\Srcrm2\SR_SQL\SR_SQL\ dpkg_Updates.dtsx",
"{my pwd}", "{pkg ID}", "{my VersionID}", "dpkg_Updates")

mypkg.Execute()
mypkg.UnInitialize()
mypkg = Nothing

seems to be okay, but i get the error "The specified file is not a Package
Storage File."

i seem to be going in circles. there has got to be a way to do this.

Krzysztof wrote:

Quote:

Good Afternoon,

i tried this thread on a .NET Forum, and it seems that this forum would a
more likely candidate for help. What i am trying to do is run a DTSX package
from the file server, not the sql server. there are many ways to do this,
but i seem to be going nowhere. Thanks for your help!

{
I have tried this many ways, to no success.

I am trying to run a dtsx package, from a simple app. My latest error is
stating need an event.

here is what is have:

Dim oApp As DTSLib.Application
Dim oPkg As DTS.Package = oApp.LoadPackage("myFilePath", False,[here
is the problem])

oPkg.Execute()
oPkg.UnInitialize()
oPkg = Nothing

There are two thing that are confusing:

1. In many examples, i see that the variable oApp is of Type DTS.Application.
If i do that, it does not give an option to "load a package".

2. The error i am getting is: "Argument not specified for parameter pEvents".

it says it needs to be of type DTSLib.IDTSEvents90.

Hopefully this makes sense to someone!! Is there another method to run this
"dtsx" package?
It seems easier if you have a dts package, but dtsx is all that i get.

thanks for any info in advance, this has kept me up nights.
}

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200807/1

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

Running a dtsx package

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

Running a dtsx package - 07-23-2008 , 07:51 AM

Re: Running a dtsx package - 07-23-2008 , 09:36 AM

Re: Running a dtsx package - 07-23-2008 , 09:36 AM

Re: Running a dtsx package - 07-23-2008 , 09:36 AM

Re: Running a dtsx package - 07-23-2008 , 09:36 AM

Re: Running a dtsx package - 07-23-2008 , 09:36 AM

Re: Running a dtsx package - 07-23-2008 , 09:36 AM

Re: Running a dtsx package - 07-23-2008 , 09:36 AM

Re: Running a dtsx package - 07-23-2008 , 09:36 AM