Post reply

Pre-requisite for running DTEXEC command

  • September 8, 2010 at 10:33 pm

    #229084

    Hi,

    I have a requirement where i need to run SSIS package in a brand new server. The Prod Support team has placed the SSIS package in the server. Now I would like to know what are the things i need to install (&what services should be running) to run SSIS packages using DTEXEC command.

    Please note that this new server is a Production server.So please let me know the basic things that needs to be present , for the package to run.

    Thanks,

    Arunvijay

  • September 8, 2010 at 10:39 pm

    #1218353

    Is MsDtsServer100 running on the server or any of clustered machine in the network

    Raunak J

  • September 8, 2010 at 10:47 pm

    #1218356

    Thanks for ur reply.

    I am not sure how to check if MsDtsServer100 is running in this server or not. can u let me know how to check this?

    Thanks,

    Arunvijay

  • September 8, 2010 at 10:51 pm

    #1218357

    aveerabadran (9/8/2010)

    Thanks for ur reply.

    I am not sure how to check if MsDtsServer100 is running in this server or not. can u let me know how to check this?

    Thanks,

    Arunvijay

    Please follow http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/867581f3-0dec-4c87-a197-3e60d5518b58

    Raunak J

  • September 9, 2010 at 3:05 am

    #1218451

    Forgot to mention..... We actually use SQL Server 2005

    Thanks,

    Arunvijay

  • September 9, 2010 at 1:23 pm

    #1218866

    Hi Arunvijay,

    You have to install "Integration Services" on the target machine. This is an option in the SQL Server installation wizard.

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

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

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