Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS 2008 working with ADO.NET destination Expand / Collapse
Author
Message
Posted Wednesday, February 10, 2010 3:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Monday, May 07, 2012 4:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, May 16, 2012 11:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse