SQL 2000, VB 6
I have a DTS package that imports a text file and inserts rows into a DB table; two separate tasks on the same database.
I can run it fine from Enterprise manager. However when I convert it to VB (and add the DTS reference) I find that the Insert task is successful but the import fails. I set the FailPackageOnError property to true in the hope of getting a useful error message, alas, all it gives me is:
"Package failed because step[...] failed."
Can anybody shed some light???
Thanks in advance,
Yael
I have a DTS package that imports a text file and inserts rows into a DB table; two separate tasks on the same database.
I can run it fine from Enterprise manager. However when I convert it to VB (and add the DTS reference) I find that the Insert task is successful but the import fails. I set the FailPackageOnError property to true in the hope of getting a useful error message, alas, all it gives me is:
"Package failed because step[...] failed."
Can anybody shed some light???
Thanks in advance,
Yael