Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  import data from db2 with parmeters

Author  Topic  inbs Aged Yak Warrior 860 Posts Posted - 2010-02-17 : 05:14:37 i want to import data from db2 to my SQL Server (sql 2008) 1.i Choose ADO.net Source (it is like DataReader Source in SQL 2005) 2.choose thae ado.NET connection (to db2) 3.and paste the query this is my query SELECT * FROM MVXDTA.ODHFD WHERE UADLDT = (SELECT Todayd FROM Venus.DWH.dbo.DateTable) i get the error: TITLE: Microsoft Visual Studio ------------------------------ Error at Data Flow Task [ADO NET Source [1]]: System.Data.Odbc.OdbcException: ERROR [42000] [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token . was not valid. Valid tokens: ) UNION EXCEPT. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.ReinitializeMetaData() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostReinitializeMetaData(IDTSManagedComponentWrapper100 wrapper) ------------------------------ ADDITIONAL INFORMATION: ERROR [42000] [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token . was not valid. Valid tokens: ) UNION EXCEPT. (CWBODBC.DLL) ------------------------------ BUTTONS: OK ------------------------------