Hi there !! Actually i have a strange issue, i was trying get the data from DB2 and extract data to a flat file So i have connected with OLEDB connection manager and in the Data Access Mode , if i select Table or View option from the drop down i can see the table which i want to connect but if i select SQL COMMAND in the Data Access Mode drop down and write a simple query like "Select * from MY_TABLE_NAME" i am getting the error Any Help !! Thanks. Error is : Error at Data Flow Task [OLE DB Source]: SSIS Error Code DTS_E_OLEDBERROR. An OLEDB error has occured.Error Code :0x80040E37. An OLEDB record is available.Source : "IBM OLE DB Provider for DB2" Hresult:0x80040e37 Description:"[DB2]SQL0204N "USERNAME.MY_TABLE_NAME" is an undefined name. SQLSTATE=42704". Addtitional Information:Exception from HRESULT:0xc0202009(Microsoft.SqlServer.DTSPipelineWrap)

Taken from blog post http://blogs.msdn.com/b/chrissk/archive/2006/06/12/628250.aspx RESOLUTION: SSIS by default will use " doublequotes as the quoted identifier if the OLE DB Provider does not override these settings. Change SSIS OLE DB for SQLCommand and type "select * from dbo.table" instead of picking the table from the list. When using Sybase OLE DB provider, run the Sybase Configuration Manager and change the data source to "Enable Quoted Identifiers" to True (1) to suppot " doublequotes around the schema and table name.Arthur My Blog

Yes, thats it.Thanks Arthur !!