Hi,

I have created a VB program to perform DTS tasks for data transfer from
ACCESS database to SQL Server. The DTS are created by saving the actual DTS
packages as VB file and used those bas files in VP app to run the DTS
programmatically.
The process works fine most of the time.
But occassionally the DTS process is getting locked. The two connections
from the DTS package to SQL server database gains DB lock on the database
and so the process does not go further .
Can any body know why this is happenning?
what could be the solution for this problem?
please help.

thanks
Sam

You would be better off creating the packages as Structured Storage files and calling them through the object model.

Are you trying to access the same object in the tasks that use these connections? Is one connection a copy of the other?
What do the tasks do that are getting locked.?

Can you put workflow into the design to make things execute in the right order?

--

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


"Sam" <samirsoni (AT) hotmail (DOT) com> wrote

Hi Guys,

Thank you Allan.

I tried to understand your response and tried to find out if i am trying to
access same object in the tasks but I am not.
But I reviewed your www.SQLDTS.com site and that show me the path for the
solution..
I was using VB to run the DTS package and not SQL SERVER it self.
So the diff between the aprtment threaded process and free threaded process
was causing the problem.
I set my steps to execute in main thread and it resolved the issue.

Thank you for pointing me the right direction.

Sam

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote