Ado.net source connection error in ssis package
Hi ALL, I am trying to use the Ado.net source to pull the tables to detination.But in this process I am getting error at source level,Could any one help me on this.The error is as below: Arun
November 6th, 2012 11:48pm

Hello Arun, As the error message says in the last line: There is a syntax error in your SQL statement, so check the statement. Can you run the query directly against your Informix database and does that work?Olaf Helper Blog Xing
Free Windows Admin Tool Kit Click here and download it now
November 7th, 2012 12:31am

Hi, I am not using SQL statement,just I am taking the table from that databaseand at that time it is giving me error. Can you suggest me where I am going wrong? Arun
November 7th, 2012 2:05am

Maybe try a SQL statement. Informix might not support the syntax for selecting a table from the dropdown menu.MCSA SQL Server 2012 - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
November 7th, 2012 2:33am

Hi, I have tried using query also but no luck. Could you please guide me on this. Regards: Arun
November 7th, 2012 3:53am

Hi Arunagiri, Are you trying to load data to an Informix database using SSIS 2008 and the ADO.NET ODBC Data Provider with the Connect for Informix driver plugged in? If in this case, please enable Use Delimited Identifier connection option in the Advanced tab of the Connect for Informix data source. Please see: http://knowledgebase.datadirect.com/articles/Article/000029680 You can also use OLE DB source connect to Informix databases, please see: http://dineshpathirana.blogspot.co.uk/2011/08/connecting-informix-databases-through.html Please feel free to ask if you have any question. Thanks, EileenEileen Zhao TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
November 14th, 2012 3:57am

Hi Arunagiri, Are you trying to load data to an Informix database using SSIS 2008 and the ADO.NET ODBC Data Provider with the Connect for Informix driver plugged in? If in this case, please enable Use Delimited Identifier connection option in the Advanced tab of the Connect for Informix data source. Please see: http://knowledgebase.datadirect.com/articles/Article/000029680 You can also use OLE DB source connect to Informix databases, please see: http://dineshpathirana.blogspot.co.uk/2011/08/connecting-informix-databases-through.html Please feel free to ask if you have any question. Thanks, EileenEileen Zhao TechNet Community Support
November 14th, 2012 4:00am

Hi, Could you let me know where I can find the "use delimited identifier property" in connection option.I have tried to find but I couldn't. Regards,Arun
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2012 5:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics