ODBC Destination Issues with SSIS

Hi All,

In Migrating from DTS to SSIS we have scenario where data from OLE DB (SQL Server) is inserted into ODBC source (transoft driver). In case of DTS, ODBC component was provided. For SSIS we used the Destination Script Component and programmatically used the ODBC related calls to design similar functionality. However we are getting the following error –

Error[42000][Transoft] [TSODBC][usqld] Name expected@.

However the same program pointing to Microsoft Access ODBC driver works fine.

Any help in this direction will be greatly helpful.

Thanks,

S Suresh

Well, perhaps Transoft needs more information in their ODBC settings. That is, MS Access isn't really a database engine and hence is more "simple" to use.|||try writting the script code to insert a record into your odbc destination and run this script code from some other context, like a script task or even from VB. the goal is to separate your script/communication with driver away from something that might be SSIS specific like our ado.net connection manager or the script component. in other words, get the script to work outside of SSIS before adding more complexity :)