Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
california6
Starting Member
38 Posts |
 Posted - 2008-08-07 : 20:08:01
|
| I am trying to export data from my production SQL box to Dev box and this is what i encounter:- Setting Source Connection (Error)MessagesError 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, Cali |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-07 : 20:16:32
|
| This is what i got simple googling your error:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=640023&SiteID=1 |
 |
|
|
california6
Starting Member
38 Posts |
Posted - 2008-08-07 : 21:28:38
|
| Thanks,But what you posted isnt any close to my issue. I am doing a simple export of my table and i dont have a package created. googling sometimes doesnt help.Cali |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-07 : 22:43:30
|
| Did you try it on another server? Did you apply sql2k5 sp2 on client tools? |
|
|
|
california6
Starting Member
38 Posts |
Posted - 2008-08-08 : 03:16:23
|
| I already applied SP2 on the SQL Server 2005 platform. Same error. un-installed SSIS and did a re-install. no luck as well. This is a 64-bit SQL 2005 environment.What client tools i need to apply SP2?Cali |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-08-08 : 15:55:56
|
| Make sure your coneections should be tested.ManojMCP, MCTS |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-09 : 00:27:58
|
| >> What client tools i need to apply SP2?Sql2k5 client tools of course.By the way, which machine did you try on? Ever tried it on the other machine? |
|
|
|
|
|
|
SSIS Error