Post reply

execute ssis in query analyser and pass parameters to the variables

  • January 9, 2012 at 8:51 am

    #248617

    I have developed a ssis package which has several parameters, i.e. file path, databasename, servername, etc...

    1-

    I can run this ssis package in Dev (Pointing to Dev sql server) and Prod (Pointing to Prod sql server) in the visual studio design mode. i.e. by running the start debugging (green arrow) button.

    All ok so far...

    2- In query analyser, in Dev sql server, I can execute this ssis package using xp_cmdshell @param where @param are the parameters being passed to the ssis

    3- In Prod sql server, I do the same as in step 2 above but I get an error which is:

    "The system cannot find the path specified."

    How can I find out what this is referring to please?

    Thanks

  • January 11, 2012 at 7:49 am

    #1431798

    'XP_cmdshell' is unable to find the path of your package, can you let me know the type of deployment you have used.

    sunilreddy
    http://msbimentalist.wordpress.com 🙂

  • January 11, 2012 at 8:08 am

    #1431814

    Issue was solved and it was to do with permissioning.

    Thanks

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

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