Post reply

Pickup how the package is running?

  • March 5, 2009 at 9:39 am

    #155372

    Hi,

    Does anyone know of a way, preferable through a piece of .net script to tell if a package is being ran server side or in visual studio?

    I would like to have some logic that checks if the ssis package is being ran in bids and if it is bring up a prompt, otherwise i'd like to supress the prompt.

    Any help / pointers greatly appreciated.

    Thanks

    Bob.

  • March 5, 2009 at 10:07 am

    #954167

    In the msdb database these tables have the information that you need,

    dbo.sysdtspackagelog,

    dbo.sysjobhistory

    Check BOL for more information

  • March 5, 2009 at 10:15 am

    #954179

    sorry i should of been more specific....

    i mean that i want to be able to write code in the ssis package that works out if it is currently being executed in vs or on the server, i.e from within a script task in the ssis package.

    thanks

    bob

  • March 5, 2009 at 10:27 am

    #954190

    There is a system variable (click show all variables) called something like IsInteractiveMode that will be true when the package is running in the BIDS IDE.

  • March 6, 2009 at 3:27 am

    #954727

    thats great, exactly what i wanted thanks very much.

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

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