SSIS 2008 working with ADO.NET destination

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by David Bird » SSIS 2008 working with ADO.NET destination

SSIS 2008 working with ADO.NET destination

Rate Topic

Display Mode

Topic Options

Author

Message

kirthireddig

Posted Wednesday, February 10, 2010 3:50 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 13, 2011 12:51 AM
Points: 53, Visits: 86

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

Post #863064

anil.borru

Posted Monday, May 07, 2012 4:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 04, 2012 11:27 PM
Points: 3, Visits: 20

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

Post #1295863

anil.borru

Posted Wednesday, May 16, 2012 11:35 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 04, 2012 11:27 PM
Points: 3, Visits: 20

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

Post #1301493

« Prev Topic | Next Topic »

Permissions