The remote table is roughly 70,000 rows.

As someone with lots of DBMS experience, but new to SQL Server, I have found the SSC community to be an invaluable resource. I try to use BOL to...

It boils down to this: does the manager care? If not, no amount of information will change that. (Although maybe pressure from their manager might.) If the...

We frequently have SSRS reports that compare this month vs last month. I use synonyms in the main report query in order to avoid the messiness of constructing a dynamic...

Hi Steve,

I was just thinking of MS-Access 'linked tables' when I wrote that. The Synonym command resemble that ability. I should have said 'allows me to create a...

A great little hidden gem, and thanks for pointing it out. One bonus of using synonyms (I've just learned) is the ability to GRANT or DENY privileges on the...

I'm still learning SSIS, but this has a lot of good information and tips. Looking forward to Part II.

If anybody's still listening, I've run into a small wall in SSIS. I get a quote-delimited CSV file that I want to upload to a SQL Server temp table....

It's a good point about how to manage the volume of files in that folder. These are files that can be discarded after upload, but it's a problem that could...

Thanks, kramaswamy, this is very cool stuff; I would have spent a week putting this altogether the way you've laid it out. Thanks for the advise on running a job,...

All right contestants, here's a 5-point tossup for anyone:

Let's say I want to import a CSV file with this process every day, and this file comes to me with the...

kramaswamy,

Thank you for all that practical advice. I'm taking your advice to do the temp table and do the update with a sql statement. One more question, please. ...

Another issue for technical types is that we sometimes have to deal with managers who don't fully (or even partially) understand what we do or what we're even talking about,...

I couldn't agree more. I've had jobs over the whole spectrum of work environments, from outright aggression and paranoia right up to total trust and love. (Well, it was...

In SQL Server 2005, right click on a database name, select "Tasks..." and then select "Export Data..."

This runs the DTS Wizard from within the Management Studio.