trueboar: Thanks very much! That helps.

Anybody?

In keeping with SSIS' apparent campaign to stamp out encapsulation, the sheet name variable is hidden in the Excel Source\Advanced Editor\Component Properties\ OpenRowsetVariable, which in my case I set to...

Very nice.

The video was truncated to the right; is there a way to avoid this?

I'm told one other disadvantage (that I didn't see mentioned above) is that you cannot define RI constraints across linked servers. (I'd love to hear that is a misconception.)

Good for you Jeremy, your response was right on!

I too was delighted to learn about and use CTE's -- subqueries give me a headache!

But I have found that there are restrictions that come with CTE's (and I'm not...

This may be drifting off topic; if I get no replies here I might just post the question as a new topic.

I am still stuck trying to find a...

Thanks for your insights, GSquared. Perhaps things got distorted because I was testing only the initial part of a more complex query. All columns of the first two CTEs...

Gail -- If it's any consolation, I am delighted to see I am not the only one. Think it's called "security theater"!

tony.sawyer (7/17/2008)

---

...I can't think of a simple, elegant solution to create a variable number of columns based on data returned without resorting to some meaty dynamic sql to create a...

For a time job sharing was popular (or at least talked about a lot.) Find another with your same skills who also would like a reduced work week and...

Be careful what you wish for. The "the traffic on the site" (or perhaps some other cause) made me wait for 5:14.4 (mins:secs) to follow the link from the last...

This site is sometimes useful to locate the IP Address source:

http://www.melissadata.com/lookups/iplocation.asp

Or if you only want a fast row count, you can use:

SELECT left(o.name,50)as [TableName]

,i.rowsas [RowCount]

FROM SYS.sysobjectso

INNER JOIN SYS.sysindexesi

ON (o.id = i.id)

WHERE o.xtype = 'u'

AND i.indid <...