January 23, 2008 at 1:38 pm
My package inserts a .txt file into a database table. It first deletes the table rows, reseeds identity to 0 then inserts data from a .txt file.
Runs fine in development. When the package is run on the live server, it appears to have trouble connecting. I've checked the connection strings and they should be fine.
Error: An OLE DB error has occurred. Error code: 0x8000FFFF
Error: The AcquireConnection method call to the connection manager "MyServer.MyDB" (700) failed with error code 0x8000FFFF
Any suggestions?
January 24, 2008 at 2:26 am
Which way your package was deployed on the production server?
January 24, 2008 at 4:45 pm
Thanks for your reply. The issue is resolved: it didn't occur to me until now that I needed to change the configuration Data Source to "localhost" once it was on the server!!! Works like a charm now! My first SSIS pkg installed and working, now to create a job to run it each morning...the adventure continues. 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply