DTS Package gives error when run through vb. -
01-27-2004
, 10:37 AM
Hi All,
I have a DTS package to import the data from a text file
to a table in sql server. When i try to run this package
from vb for the first time it runs fine and if i try to
execute again through vb it gives me error "Invalid
Procedure Call". if i exit the application and re run the
package for the first time it runs fine. But next try
fails always.
I am explicitly closing all the connections before
executing the package and if i look in tracealdo i don't
see any activity when it is hit etc.
anyone ?any ideas ?? would be helpful.
thanks
sudha. |