Post reply

How to deploy packakes to a sql server

  • July 3, 2009 at 1:13 am

    #132468

    I have a package that export thata from csv to sql server.

    How can i deploy it directly to another server?

    Is this possible?

    Also what do i need to do if i just need to append data?

    Thanks in Adv

  • July 7, 2009 at 3:44 pm

    #1021366

    Patrick.I (7/3/2009)

    I have a package that export thata from csv to sql server.

    How can i deploy it directly to another server?

    Is this possible?

    Also what do i need to do if i just need to append data?

    Thanks in Adv

    These are actually 2 questions. I would suggest that you post the second question in a separate message thtread.

    Can you describe where is the SSIS package currently deployed? Is it:

    - deployed on your file system

    - stored in SQL Server

    - SSIS package store

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • July 7, 2009 at 6:58 pm

    #1021420

    my SSIS package is deployed in a SSIS package store. e.g samplle.dtsx

    Thanks

    --------------------------------------------------------------------------------------

    These are actually 2 questions. I would suggest that you post the second question in a separate message thtread.

    Can you describe where is the SSIS package currently deployed? Is it:

    - deployed on your file system

    - stored in SQL Server

    - SSIS package store

  • July 7, 2009 at 7:02 pm

    #1021421

    Try to extract the package to a file and then import on the other server to the SSIS store.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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