April 23, 2008 at 3:47 am
Hi
I've got a SSIS package where a SQL-query copies data from a Sybase database to a SQL server. It uses an OLEdb Source and a SQL Server Destination. The result of the source-sql should give 48 rows, but it only returns the first of the 48 rows.
The problem started when I changed the destination from an OLEdb Destination to a SQL Server Destination.
The problem only occurs when I run the complete package (quite large), but when I execute the data flow task separately it returns 48 rows.
Can anyone please help! :w00t:
Best regards
Magne Mellerud
May 27, 2008 at 4:26 am
I have finally found the cause of my problem. The problem lies in to old Sybase OLEDB drivers (I'm using 12.5.3). The problem occurs when trying to run several jobs against the server at the same time. The Sybase driver tries to validate all the dataflow tasks and mixes validation (1 row) with actual data transfer. Thats why some of the transfers only return 1 row. The solution to the problem is to update the driver. (Now 15.0 ) But there is also a workaround by changing ValidateMetaData = false in the Sybase dataflow source.
This problem only occurs when trying to run 2 or more dataflowtasks simultainiusly against a sybase database with driver ver. 12.5.3 or lower.
/M
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply