Post reply

Deployment of SSIS Package

  • March 9, 2009 at 9:13 pm

    #197899

    Hi all,

    How to deploy an SSIS package in sql server.

    Please provide me links or some detailed steps on how to deploy a package.

    Thanks.

  • March 9, 2009 at 10:19 pm

    #956562

    Check this link -

    http://decipherinfosys.wordpress.com/2008/09/16/deploying-ssis-packages-in-sql-server-2005/

  • March 9, 2009 at 10:41 pm

    #956568

    Hi,

    I tried the deploying of packages in sql server 2005 , the way it is in that link. But, I'm getting some error as it is not able to deploy in the sql server.

    I have created instance. For database engine, the server name is computername\server and with sa and password. Where as for integration services, it takes only computername with windows authentication.

    What I should give in the server name while deploying the package?

    Is it this causing the error? Please help me in this.

    Thanks.

  • March 10, 2009 at 4:39 am

    #956667

    Is integration services running on your machine? If yes, try to connect the integration services from management studio by giving the server name(in your case computer name) don't put instance name(in your case server name), If you are able to connect to the integration services, give the same server name(again in your case computer name) in the deployment process also.

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

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