August 7, 2008 at 6:06 pm
I am trying to export data from my production SQL box to Dev box and this is what i encounter:
- Setting Source Connection (Error)
Messages
Error 0xc020801c: Source - AbAttribute [1]: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0014019.
(SQL Server Import and Export Wizard)
Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)
SQL 2005 Box with SP2 environment on prod and dev as well. Any input as to why this error is encounter?
Many thanks,
August 7, 2008 at 8:36 pm
64-bit or 32-bit? I'm guessing 64 and I think this thread may have your answer: http://www.cooldevelopers.com/program/656/76656-cant-aquire-connections-because.html
Make sure that if you get the answer here you post it on the thread you started on SqlTeam and vice-versa.
Thanks,
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 8, 2008 at 1:41 am
Jack thanks for the post.
I looked at the provided URL and unfortunately it was not very helpful. Yes my environment is 64-bit and all i what i am doing is "Exporting" couple of tables to another SQL Server. That's pretty much. I did re-install my SSIS - Applied SP2 and none of these helped me.
Is there any other thing i am missing?
August 8, 2008 at 6:35 am
I think it might be that you are running the 32-bit DTSexec. I don't know for sure, but that certainly sounds right. Are you running ht epakcage on one of the servers or from your desktop using SSMS (import/export wizard) or BIDS?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 8, 2008 at 10:32 am
I am running the Export process physically from the Production server. It's strange as to why i cant have this simple process run sucesfully?
August 8, 2008 at 12:10 pm
As the link I posted said. Make sure you are running the 64-bit DTSEXEC.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply