SSIS 2008 working with ADO.NET destination

• kirthireddig

  SSC Enthusiast

  Points: 143

  More actions

  February 10, 2010 at 3:50 am

  #220437

  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

• anil.borru

  SSC Enthusiast

  Points: 173

  More actions

  May 7, 2012 at 4:23 am

  #1484025

  Hi,

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

• anil.borru

  SSC Enthusiast

  Points: 173

  More actions

  May 16, 2012 at 11:35 pm

  #1488785

  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