• Replies 3 replies
  • Subscribers 336 subscribers
  • Views 48 views
  • Users 0 members are here
Related

SSIS from Tessitura

Former Member
Former Member $organization

We run a weekly data upload using an SSIS package.  Has anyone been able to get an SSIS package to execute from within Tessitura?

I've tried it using a Tessitura report, but never quite got it to work.

  • $organization

    Hi Jenny,

    We load TicketMaster sales data everyday into local tables with SSIS package.

    Then report server send out PDFs for daily sales report (Hold Code report is planned).

    I wrote a small C#.net window application to pick up emails and detach files into a folder, then run SSIS transfering the txt files into local tables and combining Tess sales with TicketMaster sales.

    for your question,

    1,

    I think the impersario user has very limited privilege in SQL server.

    most likely, you need to setup a proxy account to run SSIS package.

    I have no idea about how to give impersario user a different permission in Tessitura.

    2,

    to run SSIS package, at least you need to have SSIS components installed on the client machine.(sql 2005 client UI)

    If you try to run VB.NET scipt task, you will need SSIS server installed.

    3, put loading task into a SQL job will be a good choice.

    here is an article talking about run SSIS in scheduled jobs.

    http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx

     

    have fun

    Ben

  • $organization in reply to Ben Gu
    Jenny -
     
    I have this crazy workaround that I presented at last year's conference. It ain't perfect, but it might give you an idea of a direction to go in.. I've uploaded the presentation and scripts to my profile on the Tessi site if you want to take a look...
     
    Heather Laidlaw Kraft
    SEATTLE REPERTORY THEATRE

    Please consider the environment before printing this e-mail

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ben Gu
    Sent: Monday, April 27, 2009 6:20 PM
    To: Heather Laidlaw Kraft
    Subject: Re: [Tessitura Technical Forum] SSIS from Tessitura

    Hi Jenny,

    We load TicketMaster sales data everyday into local tables with SSIS package.

    Then report server send out PDFs for daily sales report (Hold Code report is planned).

    I wrote a small C#.net window application to pick up emails and detach files into a folder, then run SSIS transfering the txt files into local tables and combining Tess sales with TicketMaster sales.

    for your question,

    1,

    I think the impersario user has very limited privilege in SQL server.

    most likely, you need to setup a proxy account to run SSIS package.

    I have no idea about how to give impersario user a different permission in Tessitura.

    2,

    to run SSIS package, at least you need to have SSIS components installed on the client machine.(sql 2005 client UI)

    If you try to run VB.NET scipt task, you will need SSIS server installed.

    3, put loading task into a SQL job will be a good choice.

    here is an article talking about run SSIS in scheduled jobs.

    http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx

     

    have fun

    Ben

    From: Jenny Crook <bounce-jennycrook1497@tessituranetwork.com>
    Sent: 4/27/2009 1:30:21 PM

    We run a weekly data upload using an SSIS package.  Has anyone been able to get an SSIS package to execute from within Tessitura?

    I've tried it using a Tessitura report, but never quite got it to work.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • Former Member
    Former Member $organization in reply to Heather Laidlaw Kraft (she/her)

    Thanks!  I’ll take a look and see if I can make something like it work over here.

     

    Jenny

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Heather Kraft
    Sent: Wednesday, April 29, 2009 3:23 PM
    To: Jenny Crook
    Subject: RE: [Tessitura Technical Forum] SSIS from Tessitura

     

    Jenny -

     

    I have this crazy workaround that I presented at last year's conference. It ain't perfect, but it might give you an idea of a direction to go in.. I've uploaded the presentation and scripts to my profile on the Tessi site if you want to take a look...

     

    Heather Laidlaw Kraft
    SEATTLE REPERTORY THEATRE

    Please consider the environment before printing this e-mail

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ben Gu
    Sent: Monday, April 27, 2009 6:20 PM
    To: Heather Laidlaw Kraft
    Subject: Re: [Tessitura Technical Forum] SSIS from Tessitura

    Hi Jenny,

    We load TicketMaster sales data everyday into local tables with SSIS package.

    Then report server send out PDFs for daily sales report (Hold Code report is planned).

    I wrote a small C#.net window application to pick up emails and detach files into a folder, then run SSIS transfering the txt files into local tables and combining Tess sales with TicketMaster sales.

    for your question,

    1,

    I think the impersario user has very limited privilege in SQL server.

    most likely, you need to setup a proxy account to run SSIS package.

    I have no idea about how to give impersario user a different permission in Tessitura.

    2,

    to run SSIS package, at least you need to have SSIS components installed on the client machine.(sql 2005 client UI)

    If you try to run VB.NET scipt task, you will need SSIS server installed.

    3, put loading task into a SQL job will be a good choice.

    here is an article talking about run SSIS in scheduled jobs.

    http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx

     

    have fun

    Ben

    From: Jenny Crook <bounce-jennycrook1497@tessituranetwork.com>
    Sent: 4/27/2009 1:30:21 PM

    We run a weekly data upload using an SSIS package.  Has anyone been able to get an SSIS package to execute from within Tessitura?

    I've tried it using a Tessitura report, but never quite got it to work.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!