Is this a bug in DTS ?

#1

Hi,

I am having a problem executing dts package fron vb
immediatly after first execution.I can do this in
enterprise manager though.
In order to reexecute it from vb i need to exit and then
login back.
i have code to close all the connections before executing
the package in the vb program.

Can anyone help ? Any ideas? i am stuck with this.

Thanks
sudha

#2

Test

"sudha" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I am having a problem executing dts package fron vb
immediatly after first execution.I can do this in
enterprise manager though.
In order to reexecute it from vb i need to exit and then
login back.
i have code to close all the connections before executing
the package in the vb program.

Can anyone help ? Any ideas? i am stuck with this.

Thanks
sudha

#3

In BOL (SQL SERVER Books Online)

GO to Building SQL SERVER APPLICATIONS/DTS Programming/
Running a DTS Package Saved as a Visual Basic File

HTH
Rajesh Peddireddy

Quote:

-----Original Message-----
Test

"sudha" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:64a301c3e67d$6f2804e0$a101280a (AT) phx (DOT) gbl...
Hi,

I am having a problem executing dts package fron vb
immediatly after first execution.I can do this in
enterprise manager though.
In order to reexecute it from vb i need to exit and then
login back.
i have code to close all the connections before
executing
the package in the vb program.

Can anyone help ? Any ideas? i am stuck with this.

Thanks
sudha

.

#4

Hi Rajesh,

I am able to run the package once from vb,but if i try
immediatly it fails .

Online books don't gives info about how to execute which i
could do .

If you have any other clues ,let me know.
Thanks
sudha

Quote:

-----Original Message-----

In BOL (SQL SERVER Books Online)

GO to Building SQL SERVER APPLICATIONS/DTS Programming/
Running a DTS Package Saved as a Visual Basic File

HTH
Rajesh Peddireddy

-----Original Message-----
Test

"sudha" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:64a301c3e67d$6f2804e0$a101280a (AT) phx (DOT) gbl...
Hi,

I am having a problem executing dts package fron vb
immediatly after first execution.I can do this in
enterprise manager though.
In order to reexecute it from vb i need to exit and
then
login back.
i have code to close all the connections before
executing
the package in the vb program.

Can anyone help ? Any ideas? i am stuck with this.

Thanks
sudha

.

.

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

Is this a bug in DTS ?

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

Is this a bug in DTS ? - 01-29-2004 , 09:34 AM

Re: Is this a bug in DTS ? - 01-29-2004 , 10:13 AM

Re: Is this a bug in DTS ? - 01-29-2004 , 12:09 PM

Re: Is this a bug in DTS ? - 01-29-2004 , 12:28 PM