I am trying to pull data into MSSQL through a system DSN using the BBJ ODBC driver 4.00.03.00.
When I was creating the DTS package I noticed that the table name had the name of the system DSN in it.
Example:
System DSN: BBJ_DB
Table name I saw in DTS package: "BBJ_DB"."AGENT"
When I tried to run the package it ran forever (hang up). Even a empty table would run forever.
When I tried to build the query in the DTS package I would get this:
Select * from BBJ_DB..AGENT
Trying to get help from the vendor BASIS is a dead end. They claim there is nothing wrong with their driver. Has anyone run into this problem and found a workaround?
Thanks
When I was creating the DTS package I noticed that the table name had the name of the system DSN in it.
Example:
System DSN: BBJ_DB
Table name I saw in DTS package: "BBJ_DB"."AGENT"
When I tried to run the package it ran forever (hang up). Even a empty table would run forever.
When I tried to build the query in the DTS package I would get this:
Select * from BBJ_DB..AGENT
Trying to get help from the vendor BASIS is a dead end. They claim there is nothing wrong with their driver. Has anyone run into this problem and found a workaround?
Thanks