Bah! SQL doesn't enable ownership chaining by default.

https://msdn.microsoft.com/en-us/library/bb669059(v=vs.110).aspx

A trigger that did an insert into a logging table was the cause of the problem. Anyone know why the job would have a problem with a trigger when...

Andy,

Must be fixed width fields, otherwise you could spedify the delimeter in the BCP command. In the case of fixed width files, you could bcp into a generic table:

create...

Interesting solution. Thanks for bringing those undocumented xp's to light. 🙂

Personally, I'd do a couple things different. It's probably the programmer in me, but I'd replace...

replace(filename, '"', '')

Right. I used IsDate() in the where clause.

Hmmmmm Log to a desktop? Sounds feasable to me. These days the lines between workstation and server blur so easily.

Now that figures. Find an elegant solution to outragous...

Wait for approval - now that's a good one! Ok, if not full blown SQL Server, how about the MSDE engine? Install Visio 2000 and you get it thrown...

How is the user executing the DTS package?

Sounds like a nightmare. I don't suppose you could install SQL on the NT box that's downloading the files?

Another question. Which will run more efficiently? Reading a...

The DBA and the Network guys are always going to be at odds. From a networking perspective, it makes more sense to copy the downloaded file onto a share...

I have a really dumb question. Why not use the logging functionality built into DTS? What does your logging add that DTS logging doesn't have?

Thanks,

John

Brendon,

Are you saying you don't know what the remote users' machine name? If you do, and your working with admin permissions on the remote users workstation; \\workstation\c$\...

Found a much easier solution! Still uses a VB application, but makes a single API call to download the file. Matter of fact, it's called URLDownloadToFile. Here's...

Yup. Datetime field wouldn't have lost any data...