I have a simple data flow task that reads data from a table and adds the source to a recordset destination. Unfortunately, the task fails with the error;
Error: 0xC020207C at Data Flow Task, Recordset Destination : Unable to create or configure the ADODB.Recordset object. Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "Recordset Destination" (52) failed the pre-execute phase and returned error code 0x80040154.
I know the package works because I have used it on another PC and it works perfectly...So it must be a configuration on my PC somewhere.
If anyone has any ideas, I thank you in advance.
asked Feb 10, 2010 at 03:15 AM in Default
Just a load of questions I'm afraid:
This looks close to your scenario http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a4fc47b9-d029-4e7c-952d-9e9f666cf2e8/
answered Feb 10, 2010 at 05:54 AM
I actually am trying to execute my package remotely. When I execute it directly on the local machine(server 1), it works just fine. But when I try to execute it from some other server(server 2), by sending dtexec command from that server 2 to server 1, this error happens. The scenario that I described here,as I understand,executes the package on Server 1 itself .So the two servers need not be of same configuration. PS:To execute my package remotely,I am using psexec.
Thanks for the prompt replies @Usman , I really appreciate your help. And yes, from now on I will provide the whole details. I have sorted out the problem. Your answer had the clue. I was using an In memory Recordset object, which was not accessible from the remote location. All I had to do was to tell the psexec to Load the User's Account profile and not use the System Account and the package executed like a charm!!
answered Apr 09, 2012 at 10:42 AM