Post reply

Execute SQL Task

  • October 18, 2011 at 4:51 am

    #250099

    Hi,

    SELECT MAX(CmtID) AS CmtID

    FROM dbo.CADCmt...

    i declared this query in Execute SQL Task...

    i want to use that CmtID....how can i get that from Execute SQL Task..

    Thanks,
    Charmer

  • October 18, 2011 at 4:55 am

    #1395804

    set a resultset type in the properties and then define the varaible in the resulset tab of editor.

  • October 18, 2011 at 5:07 am

    #1395810

    thank you , and

    i want to use that variable in a script component to assign to a local variable...how can i do that?

    Thanks,
    Charmer

  • October 18, 2011 at 5:19 am

    #1395814

    http://www.sqlservercentral.com/Forums/Topic1191894-147-1.aspx"> http://www.sqlservercentral.com/Forums/Topic1191894-147-1.aspx

  • October 18, 2011 at 5:26 am

    #1395821

    i'm not able to get the DTS.Varaibles...i don't know why..

    Thanks,
    Charmer

  • October 18, 2011 at 5:46 am

    #1395830

    Whoaa! This is far more complicated than it needs to be. All you need to do is user parameters in your Execute SQL task - something like this:

    SELECT ? = MAX(CmtID) AS CmtID

    FROM dbo.CADCmt...

    Then map the parameter to a variable, remembering to set it as an output parameter, and you're there. No getting data out of Object type variables, and no scripting.

    There's loads of stuff out there on how to use parameters in the Execute SQL task. Have a read of some of it, and post back if there's anything you don't understand.

    John

  • October 18, 2011 at 5:51 am

    #1395836

    sorry, i thought you were asking how to use the varaible that you had populated in a .net script... I must have mis-read.

Viewing 7 posts - 1 through 6 (of 6 total)

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