Hi,

I have a system in which i currently use a DTS in VB code,
to upload data from a text file into an SQL server
database.

The system was running for a couple of months, however
last tuesday the client's pc was installed with SP4. Since
that day, the upload of the file (using DTS code) is not
running and is hanging up. Occasionally i get an error
2147 220 440 saying that the package has failed to run. I
cannot find any details about such error. I use a ODBC
connection to connect to the SQL (which is on another
Server PC, which did not have the SP4 installed on it)

Please help!!

tnx!
Ali

SP4 of what?

I am not sure about the setup of the package though?

You have DTS installed where? DTS is a client tool
The server is remote to you?
You pick the package up from that server? Remember the package will be
executing on your box.

Are you executing this manually or in a job?
Do you have logging in the package enabled? the job?

Is it you simply call the package through VB Code?
How?



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Ali" <alison (AT) euroweb (DOT) net.mt> wrote

Hi.

to answer your questions:
SP4 for windows 2000 was installed on the users's pc.

THe DTS being used was first created using the DTS package wizards, then
the code taken and inserted into VB (6) code as part of a system. The
user has the facility to select an option from the menu which would
start the DTS code.

Logging is enabled, however the system just "hangs" and the error is not
always given.In fact most of the times it just hangs as if it is waiting
for something..


thanks
rgds
ali

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!