Hi, I'm getting that nasty error msg, although you could test the oledb connection in the sybase data source configuration, so I think the error is relevant to SSIS not the sybase. [IM002] [Native Code: 30136] [ASEOLEDB]Data source not found and no default driver specified I'm using windows 7, 64BIT, ASE Version 15.5 , I've the same setup and configuration working on a vista 64 bit, but found other posts online about windows 7 and the driver is working on it. any thoughts? I really can't find anything helpful online!! Long error: TITLE: Microsoft Visual Studio ------------------------------ Error at LookupMedFrequency [Connection manager "CareCast"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E19. An OLE DB record is available. Source: "ASEOLEDB" Hresult: 0x80040E19 Description: "[IM002] [Native Code: 30136] [ASEOLEDB]Data source not found and no default driver specified". Error at Data Flow Task [SSISERVisits [5801]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "CareCast" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap) MCITP - BI 2008 http://asqlb.blogspot.com/

See if this post helps: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/ff5e2933-c29b-49b8-868c-cb4dca19b87dArthur My Blog

Hi Artur, thanks for stepping in... No not applicable to me, not even this one too http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/48695cc9-67e7-4ccb-8b5b-f64b7834ddc6 I'm trying to check the permissions now, which account is running SSIS and if it has permission on the folder that has the SOD files for sybase.MCITP - BI 2008 http://asqlb.blogspot.com/

I got it !!!!!! I even blogged about it here : http://asqlb.blogspot.com/2011/06/ssis-to-sybase-oledb-connection-error.html Thanks Arthur for trying to help....god bless for sharing the knowledge.