SSIS 2008 working with ADO.NET destination

  • Hi,

    I am trying to load data from falt file source to Sybase IQ 15.1 destination using SSIS 2008. I am using ADO.NET destination component with Sybase IQ ODBC data provider to connect to the Sybase IQ db. Though the package is able to load the data, performance of the package is extremely slow. Its just loading 150 rows per minute. I am executing the package through SQL Server Agent. There are no data transformations in the package.

    Can any one please tell me how can i improve the performance?

    Thanks in advance

    --keerthi

  • Hi,

    am having same problem,Source: flat file, Target: Sybase IQ using SSIS 2008. if you got solution please reply me.

  • I got solution, i used Sybase SQL Anywhere OLDB Provider 11 and destination also OLDB Provider. http://www.sybase.com/detail?id=1085077&id=1085077

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply