I was just researching this yesterday and found on Microsoft's site that you have to use Outlook 2000 or Exchange Server to use the built-in SQL Mail. Outlook 2003 won't...

What I've done is performed a backup of the live servers and restored them on the development machines. You can use the backup and restore commands in query analyzer. It...

I don't believe there is a way to do this without writing a program with SQL-DMO. You would need to open up each package in code and loop through the...

Perhaps one thing you can do is create a global variable to hold the server name (or IP). The dynamic properties task can use the value in the global variable...

OK, I figured out the problem. First, I enabled replication on the server being restored to. Second, I used the WITH KEEP_REPLICATION switch. That cleared up the error and I...

Can you give us the table structure and the select statement? That may help.

Let me guess: you have many columns or they are wide? This happens to me when I'm trying to export a table with many columns. I thought there was a...

Actually, I ran into a problem very similar that wasn't because of normalization. I had to return customer info along with info from their first order in a single statement...

You're very welcome. My pleasure. You're the first person I was actually able to help on this site so far (or at least confirmed). And hopefully not the last! :>...

OK, I understand now. The column names actually have quotes around them.

OK, there are 2 options:

1. The simplest is to put an extra double quote around the column name...

Try getting rid of the double quotes inside the DTSSource(). So, the code would be:

Function Main()

DTSDestination("Col009") = Replace(DTSSource("CHCK"), """", "")

DTSDestination("Col008") = Replace(DTSSource("ASTT"), """", "")

DTSDestination("Col007") = Replace(DTSSource("OTRT"), """",...

Yes, it was being replicated. It was the publisher of merge, transactional, and snapshot replication. It also was a subscriber to merge and transactional. Yes, it is both the publisher...

OK, I'll try and remember to put the GO in. Sorry about that.

And yes, exactly: there was no 'table.' That's what has me so puzzled. And that's what leads me...

Exactly. However, it may be worth testing to see if the column comparisons in the WHERE clause on the UPDATE is worth doing. That can add a lot of overhead....

It seems to me that you should look into the Data Driven Query task. It lets you perform inserts or updates based on the data in the source. I wish...