Post reply

Deploying a DTSX to SQL server (Integration services) using TSQL

  • November 14, 2008 at 2:12 am

    #154917

    Hi,

    Is there any possibilityt o deploy a DTSX file to the SQL Server Integration Services using TSQL command?

  • November 14, 2008 at 6:47 am

    #898534

    There is a command-line utility for deploying DTSX files to an integration services server (and to do lots of other things).

    The command will look something like this:

    [font="Courier New"]DTUTIL /DestS "%SSISServer%" /Q /FILE "%DTSXFileLocation%" /COPY SQL;"%SSISFolder%"[/font]

    I suppose you could call xp_cmdshell and call the command line utility, but this seems like a really strange thing to do. Perhaps you can describe what you are trying to accomplish.

Viewing 2 posts - 1 through 1 (of 1 total)

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