Author Topic: Improving performance SSIS Connector  (Read 3019 times)

Offline RNI

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
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

Offline PivotalTim

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 164
  • Karma: +6/-0
    • View Profile
    • xemware
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.
Tim Shnaider
xemware limited
http://www.xemware.com

Looksie - Prototyping Covered!
http://www.looksie.me