Post reply

Multi Tenant SaaS model in SSIS

  • December 19, 2008 at 9:30 am

    #127620

    Hi,

    I've to upload files for multi tenants in SSIS. each tenant file would be stored in a separate path. and this path information are stored in a table. While starting the package how do i know which tenant file is going to be uploaded and how do i select the path from table for a particular tenant?

    planned to activate SSIS packages on daily basis through sql server agent.

    thanks

    regards

    viji

  • December 19, 2008 at 11:37 am

    #915523

    You can use Foreach loop with ADO enumerator to loop through your table and get the path for each file. If you have not used ADO enumerator befor this will give you some insight

    http://www.codeproject.com/KB/database/foreachadossis.aspx

    HTH

  • December 19, 2008 at 11:35 pm

    #915711

    Hi Mukti,

    I'm creating in the same way. but when i issue

    select clientid, servername from clienttable

    i'm getting multiple rows and each client is having separate dates and timings for upload. only on those days it should get uploaded.

    thanks,

    regards

    viji

  • December 22, 2008 at 10:42 am

    #916262

    If i understand it correctly. You have files for multiple clients that needs to be loaded on defined date and timings. If these timings are fixed then you can store it in a config table and use it in your package to load it for that specific client.

    If you schedule this as a job then each day you can check it agaist the config table and upload the appropriate file.

  • December 22, 2008 at 9:52 pm

    #916550

    correct mukthi,

    but how to go about it is my doubt.

    the steps involved and i'm from database side and i don't know VB.net to write scripts.

    but if the ways are clear then i can take some of my colleagues help in VB.net

    thanks,

    regards,

    Viji

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply