Jon Jaroska (12/26/2012)
I have successfully deployed my first package to sql 2012. The package runs fine in visual studio but when deployed it gets an error message saying there was an error trying to establish an odbc connection to the database. Anybody encounter this and does anybody have a solution?
I've not done much yet with SSIS 2012, but here are questions that immediately come to mind: Are you running Visual Studio on your development machine? Do you have a DSN setup to the DB on your development machine? Is this same DSN setup on the server where you deployed the SSIS package? Does the account that the SSIS package run on the server have permissions to the database?
I hope this helps,
Rob