Thats what I was thinking was weird...

It couldn't possibly be a permissions problem, because it only happens with zero byte files, and we do the same processing with non-zero(data containing) files. The only difference is...

The DTSPackage Object has a property called LogFileName that you can set to the path of the file you wish to use. 🙂

You could also try running the package from the desktop of the server, sometimes things are set up differently than your machine, and the packages have to be configured a...

Darren Green has an article on swynk that shows you how to use the OLE Stored Procedures to call a DTS Package from a stored procedure. I have tested...

You would just need an ODBC Client installed on the machine you're going to be creating and running the DTS from. Then when you create your DTS Package, choose...

I still get the same error, that There is already an object named '#tmpReportClient' in the database.

Morning Andy,

Yes, those are the actual table and field names. The reasons I use Hungarian notation is because I am mandated to by my team lead. I do...

Yes it is. I will try using that.

Thanks!

No I don't want to delete the duplicate records. I want to only insert one record into the second table. Here's my tables:

tblCustomer

iCustomerID

sPhoneNum

sCustomerAcctNum

tblTMPFileLoad

sPhoneNum

sCustomerAcctNum

sSecondaryPhoneNum

sSecondaryAddress

tblAddlInfo

iAddlInfoID

iCustomerID

sSecondaryPhone

sSecondaryAddress

After I load tblTMPFileLoad, I need...