Read Data With an old ODBC Driver

2009-03-17 18:28:06 UTC

Hi,

I finally find the answer.
We have to use an ADO.Net odbc Driver

The only problem I still have is that de driver do not close a the end of
the task
In my SSIS in the Control Flow Tab I have 2 task
The first on is an Execute Sql Task which delete all row of a Sql server Table
The second task is a Data Flow Task
This Data Flow task have 3 sub task in the Data Flow Task Tab
The first one is a DataReader Task which read the Data from Accpac with a
ODBC driver
The second One is a Data Conversion to Cast all type of data
The third one is a Sql Server Destination which insert all the Data from
accpac into th e Sql Server table
Everything works fine except that at the end when everything is finish
the Driver ODBC stay open and don't close.

This happen in the SSBIDS
I try to save this SSIS as a SSIS and execute it in SQL SErver Managment
studio
It works fine but the ODBC driver don't close and this should not happen

Do you have any idea what can cause this?

Post by GC
Hi,
I have a customer for which I have to use an ODBC Driver for Accpac dataBase
I have to import some data from one file and Import that data into a Sql
Server 2005 Data Table
I first Create with no problem a connection with this ODBC Driver in the
Connection Manager and I named it ACCPAC_ODBC_CONNECTION
Then in my SSIS in the Data Flow Source Section I try to use the DataReader
Source object in which I Select my ACCPAC_ODBC_CONNECTION and it seems that
this ODBC Driver is not support by this object.
Can not acquire a managed connection from the run-time connection manager
Is that true or I might be wrong
Which object should I use to copy Data from an accpac file using my ODBC
Driver for accpac?
I understand that this ODBC driver is old but i am stuck with it and this is
the driver that accpac give us to use for Sql Server 2000 DTS and it works OK.
Now I am trying to do the samething with SSIS in Sql Server 2005 is that
possible ?
Thanks in advance