I upgraded my SQL2000 to SQL2005 and all of the triggers were fine after the upgrade. Then my vendor provided an upgrade to the ERP which blew away a...

Hmmm. I have 'sa' as the owner; isn't that good enough. Also, when I schedule this package via the DTS wizard, it works fine with 'sa' as the...

Thanks. Yes, you're right. I can get it to run that way. Now if I could just get it to run in a new job with DTSRun!

I am having the same problem. I am still in SQL2000 and I cannot get the DTSRun command to work.

DTSRun /N {package_name} and I've tried DTSRun /N "{package_name}"

I've tried...

I'm not sure which part of my brain is missing, but I didn't SEE any third answer (which supposedly the correct on). I'm glad it's the 100% correct answer,...

I've checked the data and there is no discrepancy like that in the column length. And if I exec the script in Query Analyzer, it's just fine. I've...

I'm experiencing the same problem. My ANSI NULLS parameter is checked 'on'. ANy other ideas?

Any in Pittsburgh, PA?