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 |
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
 Posted - 2010-03-10 : 13:22:42
|
| Okay, so I have been working on my SSIS package locally using SQL 2008 developer, I am able to create the package fine so that it truncates some tables and downloads some data from a remote reporting Server. Now we just installed a 64 bit SQL Server 2008 Standard and I change my destination connection to the new server and I am getting some major issues, I keep getting this error:[OLE DB Destination [16]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "FY1YVL1.CHRIS_ADHOC" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.And further up I get this message:[SSIS.Pipeline] Warning: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.Now I have configured our firewall to let SSIS do it's thing, and even let the 32 bit DTExec.exe to run. It just seems really flaky on the 64 bit machine, some data flow tasks fail, others work no problem. I even tried running it DIRECTLY on the server using RDP, and still the same problems. Any suggestions? Thank you. |
|
|
|
|
|
SSIS woes please help