Author Topic: Can SSIS execute an AppServerRule?  (Read 3557 times)

Offline cooldude

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Can SSIS execute an AppServerRule?
« on: December 23, 2009, 01:38:36 PM »

Can SSIS execute an AppServerRule?

Offline PivotalTim

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 164
  • Karma: +6/-0
    • View Profile
    • xemware
Re: Can SSIS execute an AppServerRule?
« Reply #1 on: December 27, 2009, 05:57:34 PM »
Pivotal have an SSIS Connector which provides a Pivotal Connection component and Data Flow Desitination component.  Very handy stuff.

So as a Data Flow Destination, you would point to an Active Form that has an ASR and you do what you need to do in AddFormData/SaveFormData per record.

Alternatively, add a Script data flow component (Destination) and connect to LCS in the script (.NET C# or VB)
Tim Shnaider
xemware limited
http://www.xemware.com

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

Offline cooldude

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: Can SSIS execute an AppServerRule?
« Reply #2 on: January 18, 2010, 10:16:26 AM »

Thanks for your reply. I'm new to Pivotal.

What's ASR & LCS?

Offline serk

  • Full Member
  • ***
  • Posts: 46
  • Karma: +2/-0
    • View Profile
Re: Can SSIS execute an AppServerRule?
« Reply #3 on: January 20, 2010, 08:50:31 AM »
ASR = AppServerRule,
LCS = Lifecycle Server

Offline cooldude

  • Newbie
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: Can SSIS execute an AppServerRule?
« Reply #4 on: January 20, 2010, 10:51:45 AM »
Pivotal have an SSIS Connector which provides a Pivotal Connection component and Data Flow Desitination component.  Very handy stuff.

So as a Data Flow Destination, you would point to an Active Form that has an ASR and you do what you need to do in AddFormData/SaveFormData per record.

Alternatively, add a Script data flow component (Destination) and connect to LCS in the script (.NET C# or VB)

How can you point Active Form from Data Flow Destination thru Pivotal Destination on Insert Action?

Offline PivotalTim

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 164
  • Karma: +6/-0
    • View Profile
    • xemware
Re: Can SSIS execute an AppServerRule?
« Reply #5 on: January 20, 2010, 02:57:28 PM »
Have you read the documentation?  It details each of the properties on a Pivotal Destination component, including Active Form Name.
An Insert will result in a call to AddFormData.

What is scary is you saying you are new to Pivotal and trying to do SSIS integration.

How can you point Active Form from Data Flow Destination thru Pivotal Destination on Insert Action?
Tim Shnaider
xemware limited
http://www.xemware.com

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