MS SQL Server DTS - DTS Job Failed

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

DTS Job Failed

Bill

2006-01-31, 9:23 am

Hi All,
I have a VB .NET console application to call DTS COM to import some
flat files into SQL 2000 SP4 on Windows 2003 SP1. I will import about
20 files in a loop.
When I schedule this application to run as a job it can import the
first file successfully and then failed. After I added some debug
information I found the application failed after first loop at :
goPackageold = New DTS.Package
The error is: Object reference not set to an instance of an object.

The funny thing is: if I run this application in command windows all
files can be imported correctly. My account is a domain admin and the
account to start SQL Agent is a domain admin too. We have four servers
with same configuration for windows and SQL 2000. Two old ones are
working well with this application. Two new ones met the same error.
The account to start SQL Server and SQL Agent is the same on four
servers.

Any idea? Thanks for any help!

Bill

Sponsored Links