does anyone know how to refer to another connection from within an execute sql task

eg
Execute sql task
on connection 1

select * from authors where id not in (select * from connection2.dbo.authors)

Ive found you can use the standard databasename.tablename, but I am developing in debug and want to easily port this to production by just changing the connections


TIA

You cannot ref another connection from an ExecuteSQL task. You can though ref Linked Servers which is what you actually want to do.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"rob thomson" <rob.thomson (AT) virginmusic (DOT) com> wrote

does anyone know how to refer to another connection from within an execute sql task

eg
Execute sql task
on connection 1

select * from authors where id not in (select * from connection2.dbo.authors)

Ive found you can use the standard databasename.tablename, but I am developing in debug and want to easily port this to production by just changing the connections


TIA