Background: 32 bit ODBC driver to progress database SQL Server 2008 R2 62 bit Trying to import data from progress DB to SQL DB
I use SQL Server Import wizard to write a query to grab data from a progress DB table into a SQL server DB table and this WORKS.
I save this import (with save all data with password option) which creates a package in SSIS under the MSDB folder. When I right click "Run Package" and "Execute" the package, it fails with message "Could not create a managed connection manager"
I have been searching for answers online and wondered whether it was a 32/64 bit issue but when I use command line to run via the 32 bit DTS, it still fails with the same message.
I have also tried amending the import to use various combinations of server or windows authentication to no avail. And also creating the package using the DTS wizard under the 32 bit folder. Same message.
Any guidance here on what else I can try would be much appreciated. Thanks in advance!
BIDS is the full designer for SSIS packages. The Wizard you've been using generates packages by prompting you. Dunno about your license errors. However the error message seems to be a problem with the connection.
Try this: Can you create a valid ODBC DSN in Windows to your database (Control Panel, Administrative Tools, Data Sources)?