Post reply

Script to execute SSIS packages

  • February 21, 2012 at 2:35 pm

    #251204

    Hi Iam trying to run my SSIS package in 32 bit.

    Please help me with the script to execute the packages.

    Thanks for your help

    Sajin

  • February 22, 2012 at 10:23 am

    #1450435

    Why are you trying to use PowerShell to execute SSIS packages? Why not use SQL Server Agent?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 22, 2012 at 1:37 pm

    #1450541

    SQL Agent is not enabled

  • February 22, 2012 at 10:04 pm

    #1450647

    If all you need to do is execute a package then a single-line PowerShell script that calls dtexec.exe is all you need. e.g.

    dtexec.exe /f "C:\UpsertData.dtsx"

    See section "dtexec (SSIS Tool): Examples" for more examples: http://msdn.microsoft.com/en-us/library/ms162810.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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