Hi,
I'm trying to perform an INSERT that I can do currently using osql, but
I need to make some changes and thought that putting into a DTS would
be a good idea (instead of a scheduled task like the osql is now).

What I like about the osql is I connect to various servers using
variables, how would I accomplish this with DTS? I'm barely able to
script! I'm posting as I haven't the experience in data pump, lookups,
data file, not sure which I use here.

What I'm looking to do is to repeat something like, feeding the
servername, databasename and criteria into the select:

insert into MyDB.dbo.%2tbl select * from %1SMS_%2.dbo.table where
criteria like '%2_____'

Any advice appreciated.

You could build your select/insert statement from variables into one long
string variable then execute it.
eg.
SET @TSQL_STR = 'SELECT * FROM '
SET @TSQL_STR = @TSQL_STR + @SERVER + '.' + @DB + '.' + @OWNER + '.' + @TABLE
SET @TSQL_STR = @TSQL_STR + ' WHERE [Field] = 1'
exec(@TSQL_STR)

"jtrecords (AT) yahoo (DOT) com" wrote: