Hi All,

I am trying to load a text file into sql server table
using DTS package saved as vb module.This executes fine
for the first time when it is created , but any attempt to
run again hangs the system.

any clues why it is happening so?

I am using sql server 8.0 and vb 6.0.
Same package runs fine when manually executed at sql
server enterprise manager.

Thanks in advance.
sudha

Are there any locks on resources?
Database | text file.

Maybe the connection is being kept open. (in Workflow Properties for the
connection set "Close Connection on Completion")

What is contained in the package ?


--

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

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


"sudha" <s_sudha (AT) yahoo (DOT) com> wrote

Hi Allan,

There are no locks on the resources,I created the package
and saved it as VB file and then trying to execute it from
vb.Connections are closed and set to nothing after first
run.DO i need to close any other connections opened for
other transactions from application before executing this??

Thanks for response.

If the package always works the first time and then you execute immediately
afterwards and it hangs it suggests to me that something is being Queued.


--

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

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


"sudha" <s_sudha (AT) yahoo (DOT) com> wrote