Post reply

Pass a query to a Variable

  • October 1, 2008 at 10:51 pm

    #191717

    Hi To All,

    Im a new developer for SSIS, im having hard time doing this one. Can anyonw help me?

    I wanted to pass a result of below query in a variable

    "select convert(varchar(10),getdate()-7,111)"

    How can i do this?

    Thanks in advance,

    Lieza

  • October 2, 2008 at 4:32 am

    #879866

    Take a look at the Execute T-SQL Statement Task. In the editor you can see the 'Result set' link, and there you can set 0 as Result Set Name and the variable you want use to store the data.

    However I suggest you to search Google for this simply tasks.

    Good work!

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

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