You probably did this, but just in case:  you ran the entire statement in 2 in Query Analyzer and it ran?

I'm stumped.  Hopefully someone else can help you.

I'm stumped.  Hopefully someone else can help you.

Can I always split on the semicolon?  What is the maximum number of semicolons in a field?  Is this something that you want to do once and then not again...

John summarized it very well.

I can't recall if I have heard this officially, but this is a bug!

First, just type in your SQL just like you did.

Then save the executesql task (if there are...

Let me get this straight.  You ran the dts package with an executeSQL statement that used a global variable.  When you saw the statement in the profiler, the statement completed...

I created a very simple package with two connections:  one sql server, one text destination.  I then created a transformation from the sql to the text.  I set the source...

Run SQL Profiler while running the DTS package and look for the SQL statement from the ExecuteSQL task.  Does it look like it has the right parameter values?

You have several moving parts here.  I don't think that I can answer this in the few moments that we have to respond to posts.

UPDATE YourTable

SET YourFieldName = REPLACE(convert(varchar(8000), YourFieldName), 'c:\', 'h:\')

Are you actually moving the files?  How do you plan to move the files? I personally would use Access or VB to do this.

You need to read the database table...

I'm really not clear what you are trying to do, so it is very difficult to help you.

DTS can do a lot!  I've seen it do things that could be...

I think that you could use an instead of trigger like what you have.  I will let you be the guinea pig.

After your trigger:

insert into Table_to_Update

select @pk, Last_Name, First_Name from...

One thought:  use a uniqueidentifier column and the NewID.  It is somewhat wide, but it is almost certainly going to be unique.