Post reply

how to assign results from a sql task to a global variable in SQL Server 7?

  • May 31, 2008 at 3:47 am

    #822630

    Have a look at

    http://www.sqlservercentral.com/articles/DTS/dtsandglobalvariables/2266/

    There they assign values to global variables.

  • June 2, 2008 at 7:22 am

    #822908

    Thanks for the input, but the article is not talking about how to execute sql query/stored proc and read the resultsset. My requirement is to execute a sql, get the result set, process it, create a dat file and upload it to an ftp folder. please help...

  • June 4, 2008 at 1:19 pm

    #824470

    I would create a small program outside of sql server that does this. (datasets in .NET?)

    You could also try to store the outputs in temporary tables.

    For text-files you might consider bcp.

  • June 5, 2008 at 8:47 am

    #824855

    Hi Jo,

    What i have to deal with is sql server 7. And, i have adopted the following approach and it seems to be working:

    1. Create a table in db (one time and first time)

    2. Truncate table

    3. load the results to table

    4. in activex script, read the results from table,

    5. create a csv file from results

    6. upload it to ftp

    And this is working...

    I tried to use table data type and found that it is not supported by 7 version. I am still working on to fine tune this design. Do you have any inputs/ideas for this design???

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

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