twin.devil (1/22/2015)

---

ok try this

1) create a copy of the package which is giving error on your dev environment.

2) Remove the OLE DB Destination.

2) Replace the Derived Column Customer with Rowcount....

The MS Access driver seems to be properly installed. I did a repair just in case but it didn't seem to make a difference. Another application on the same machine...

I'm using an Access DB. ADO NET was used in the previous version of this package, and seems to be the only data source type that allows custom data source...

Here's the data flow of the package. The other packages are the same type of structure. (Except the delete package which is working)

Let me know if you want more information,...

The delete package executed successfully through dtexec as administrator.

The others gave me the same error as before, unfortunately:

OnError Data Flow Task Customers,{25CD0553-6250-4448-AAD3-E011CE618292},{0710E248-236C-47B8-A19F-2466DF32282C},22/01/2015 10:12:41,22/01/2015 10:12:41,-1073450900,0x,Component "Derived Column Customers, clsid {49928E82-9C4E-49F0-AABE-3812B82707EC}" could...

twin.devil (1/21/2015)

---

try to place the packages on another driver like D,E etc and execute the dtexec Utility again. as per error it is a security issue. as dtexec unable to...

twin.devil (1/20/2015)

---

Where is you package is located ? if its exists on the application server, then try to run this package manually on that server.

if the package run successfully, and...