I am trying to migrate data from Sql Server to Sybase, using SSIS (Sybase ASE OLEDB Provider). When I set AccessMode to "OpenRowset Using FastLoad", get eh following error: ******************** [OLE DB Destination [16]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "ASE OLE DB Provider" Hresult: 0x80040E21 Description: "Errors occurred". [OLE DB Destination [16]] Error: Failed to open a fastload rowset for "dbo.blahblah". Check that the object exists in the database. ******************** Any ideas? Does anyone know a way of fast loading data into Sybase from SQL Server?

Do you have correct credintials in connection string? do you create table in sybase prior to load the data. Error shows table is not exists before handhttp://uk.linkedin.com/in/ramjaddu

RamJaddu, thanks for the reply. I forgot to mention that the package runs fine with just "openRowset" selected, but its terribly slow, thats why i want to use Fastload options.Regards MP

Any luck with this? I'm experiencing the same issue , without fastload its generating each INSERT statement.

Any luck with this? I'm experiencing the same issue , without fastload its generating each INSERT statement. You are out of luck. The Sybase drivers are extremely buggy. Essentially there is no option to bulk-load from inside SSIS. You may try a different approach extracting the data to a CSV format and then using one of the Sybase included tools to bulk-load this file.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/