PIVOTAL CRM FORUM PIVOTAL CRM FORUM
Free Pivotal CRM advice from experts
Welcome, Guest. Please login or register.
Did you miss your activation email?
September 08, 2010, 07:43:38 AM

Login with username, password and session length
Search:     Advanced search
A reputed Pivotal CRM consultant starts a Pivotal CRM blog www.pivotalcrm.info
2147 Posts in 649 Topics by 1195 Members
Latest Member: Nelfweels
Home Help Login Register
+  Pivotal CRM Forum
|-+  General Category
| |-+  Integration
| | |-+  Improving performance SSIS Connector		 « previous next »
Pages: [1] Go Down Print
Author Topic: Improving performance SSIS Connector  (Read 306 times)
RNI
Newbie
*

Karma: +0/-0
Offline Offline

Posts: 1
Improving performance SSIS Connector
« on: January 25, 2010, 01:32:51 PM »
Hi,

I use an SSIS connector with an http connection (can't use COM connection, because SQL Server and Pivotal are 2 separate Server).

It works good, but the performance to insert data in Pivotal tables is very bad.  (Maximum 5 rows per second)  :-/

Does anyone have an idea to improve the performance ?

Thank you in advance


Technical info : Pivotal 6 / SQL Server 2005
Logged
PivotalTim
Global Moderator
Hero Member
*****

Karma: +5/-0
Offline Offline

Posts: 158



WWW
Re: Improving performance SSIS Connector
« Reply #1 on: May 22, 2010, 11:30:27 PM »
Yes

1# Install Business Server on the SQL Server, OR
2# Install SSIS on Pivotal Server

It's as simple as that, there is NO way to get good performance via XMLServices call.
Logged
Tim Shnaider
enetworks limited
http://www.enetworks.co.nz
Pages: [1] Go Up Print 
« previous next »
Jump to:  

Powered by MySQL Powered by PHP Pivotal CRM Forum | Powered by SMF 1.0 Beta 5 Public.
© 2001-2004, Lewis Media. All Rights Reserved. 		Valid XHTML 1.0! Valid CSS!