yes, we have tables, but i'd really need to do it via variable. there's no way to pass a variable along that's not global???

global variable might work.....

but i'd still like to know if there is a standard for passing a variable between the tasks similar to how you pass in SSIS.

ahhh... i think i got it... can't concatenate inside the variable of a SP, or function.... i guess i'll just wait for any confirmations....

have to set a new variable...

got another question... same type actually.

what if it's a linked server that i want the current_timestamp for?

select current_timestamp from linkedserver.????.dbo.????

normally we do just "select current_timestamp" which is a function on...

thanks. that worked