In you data source, set the connection string to "expression" and use the pararmeter you created @servername and use master database. In the data source use SELECT * FROM...

These two links maybe helpful. Maybe setting the password protection level differently, or if the package is in a job, create a proxie which will be able to access...

If you mean temp table's as in # or ##. # can only be accessed in the same session. ## can be accessed from other sessions.

Use information_schema.columns

U you query sys.databases, and append the database name to the information_schema.columns.

SELECT

'SELECT *

FROM '+ NAME + '.INFORMATION_SCHEMA.COLUMNS

ORDER BY table_name, ordinal_position'

FROM sys.sysdatabases

WHERE name not in ('tempdb', 'master',...

In 2005 there is a new operator called EXCEPT which is equavilent to TABLE A column not in TABLE b column.

SELECT a.User_id as user_id

,A.update_date as create_date

FROM accounting.dbo. A JOIN

(SELECT user_key...