Post reply

how can i have pop up message while executing DTS

  • July 11, 2007 at 9:40 am

    #173447

    I have created a package that actually extract data from database and export to an excel file.

    All i want when i execute the package it must give a pop up msg like which employee information u want to extract, and that parameter should be passed to the query which is extracting data.

    Any help would be highly appreciated how can i do this.....if through dynamic properties task how can i ?

  • July 11, 2007 at 9:55 am

    #718688

    You can use an ActiveX Script task to display an input msgbox and pass the input data to a global variable.

    Here's an example:

    http://www.sqldts.com/214.aspx

    Greg

    Greg

  • July 12, 2007 at 2:06 am

    #718887

    Thnx greg,

    I got some idea...can u plz guide more....like i get the value in a variable through pop up msg, now this value is given to global variable, hw can i pass this global varaible value to my Tsql query so that i get the information of the desire employee.....

    like

    select a.employeeName,Env_Type,resource_id,Machine_Name

    from IT_APP

    where employeeName="Global variable" ???

    Now how to pass the value of pop  to the query ??

  • July 12, 2007 at 3:38 am

    #718904

    Ok now i got how to pass the value to the global variable.

    Just simply use "?" in the query

    where employeename=? and clik paremeter in the window

    Thnx

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

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