Hi,
I need to pull data from an application server. I am using Transform data
task.
I want the Source server to be passed as a parameter. I know it can be done
using Dynamic SQL and use of procedure.
My source of Transform data task is a sql querry, which uses OLTP database
as source. I can't replace the querry with procedure as I am not supposed to
cerate any procedure in application server (OLTP).

Using just the querry how can I pass Server name as parameter??
thanks in advance.
Don't want to use SQl task also.

kshitij.

The ONLY way you are going to be able to do this then by passing in a
parameter is like this


Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)




"k_s" <ks (AT) discussions (DOT) microsoft.com> wrote