Thanks also for the hint about the IFCode Shortcuts on the left side of the editing pane. Had not noticed those but wondered how to people displayed the code...

ps (6/19/2009)

---

heh... there is no need to create linked server... OP wants data to access from other database and not other server.

This should do fine if db is present in...

Regarding post above with these options:

1. select * into dummytable from orgtable (or)

2. script out the table so that you can have the table creation script and bcp out the...

Interesting but I'm not sure why you would do this instead of:

select count(*) from TimeZones

What I find more helpful is to be able to return a list rowcounts for all...

Thanks for the excellent treatment of a very common task that is not intuitive in SSIS. It seems relatively straightforward once you point out the ability to retrieve the...

In Enterprise Manager I have not been able to copy column headers in Query Analyzer. Instead I create and run...

I have found that column headers behave differently when writing a query from scratch (new query) versus opening a table. When I "open" a table with a right click,...

/* Run this as text, capturing the output as text instead of grid and run it */

/* You can modify the SELECT statement at the bottom to filter & order...