As an after thought - depending on what you wish to do of course, you may have to execute the sql statement as a variable. Out of curiosity I...

tran008,

I think you need to provide a bit more basic information about what you are trying to do. Where are you getting the @FileName parameter from anyway? My...

I second that. The for each loops are a great tool. I use one with variables and script for looping through database backups on my main server to...

I agree with happycat59. I use synonyms in SQL Server 2005 across multiple databases on the same server. Very easy and can use logical names too. Works...

Quote:

"Not putting your foot down now is a major downpayment into a pain mortgage, and those have a really high interest rates. In case it hasn't become clear...

Michael I sympathise with you completely.  Do you ever get the feeling lately that Microsoft is losing the plot with some of the default settings and 'features' they build into...

No, but I believe it is something to do with our user desktop lockdowns by our outsourcing outfit.  Unfortunately we are outsourced to a computer company who are a devil...

Don't know if this is of use but I picked something like this off the web a while back and modified it to suit my needs.  It does...

Really need some more information here.  What are the specific fields for tables a, b, and c.  I assume there are relationships set up between them.

Regards

Terry

Thanks MG, with a couple of modifications to select only the views from INFORMATION_SCHEMA and sys it worked a treat.  There was one gotcha of course - you cannot revoke...

You are right Jon.  I thought I had SP1 installed - but no.  I had downloaded it some time back and then forgot the very important step of actually installing...

Pardon me for piggy-backing on this one, but I am experiencing the same issue.  I get the user to enter a date according to the format dd/mm/yy and then convert...

Michael,

You need to create a variable yourself - you can make it global or specific scope - and then add a row count task to your data flow between the...

Well Jamie,

It's hard to be clear and precise about this because we all learn differently.

As I am approaching my twilight years (!) I am not the fastest kid off the blocks...

Mitch,

No I didn't, but the variable method works fine.  I suppose at first I was loathe to have heaps of variables hanging around if there was a slicker way to...