SSIS Execution through BAT file

  • Hi All,

    I would like to execute an SSIS package having indirect XML configuration.

    Can you please help me with the command which I should use.

    As of now I used following command which is not working 🙁

    dtexec /f "C:\SSIS\ImportRageBIData\ImportRageBIData\ImportRageBIData.dtsx"

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • Probably because you haven't specified the config file. Check out the documentation for dtexec - it'll show you what switch to use to point it to your configuration.

    John

  • John Mitchell-245523 (7/3/2015)


    Probably because you haven't specified the config file. Check out the documentation for dtexec - it'll show you what switch to use to point it to your configuration.

    John

    But for Indirect XML Configuration, do we really need to specify the config path as the config file resides over the path mentioned in environment variable which is used in package for indirect XML configuration.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • I see. I didn't realise that was referred to as "indirect configuration". But anyway, "not working" is not a good way to describe any problem. What happens when you run the command? Do you get any error messages?

    John

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

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