This is the error I get from xp_cmdshell.

DTSRun OnError:  DTSStep_DTSDynamicPropertiesTask_1, Error = -2147467259 (80004005)

   Error string:  Failure creating file.

   Error source:  Microsoft JET Database Engine

   Help file:  ...

Ok, got it so it works when manually executing the dts package now, but executing it via xp_cmdshell still fails with the same error given above. Any thoughts?

I have attempted the xp_cmdshell method with no positive results as of yet. Using this method I get "DTSRun OnError:  DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)"

Interestingly if I run the package...