Thanks Jeff that is brilliant, I was working with the OPENROWSET but this is just what I want. This is part of a wider dynamic SSIS which I may post...

Thanks for the reply and that is a good article, however it does not create the table automatically from the Excel spreadsheet. I can't create the table first as the...

Hi mate, if you are only doing select statments then my solution would work...

Dude... what are you trying to do here? I'm just trying to help the guy out, there's no mention of an update in his post or I wouldn't have put...

No I get that Phil, you've been a great help, I do a replace in the original query which leaves me with the query reading....

[font="Courier New"]select [OriginalName] from [Bbc.Ww.Wam.Migration2012.Database].dbo.[PreSalesSKU_ForRename]

where...

Err why have you deleted?

Actually it is more complicated than a REPLACE will allow. The REPLACE allows me to choose the column now, but later on in the package, I need the proper name...

Thanks Phil - Yes I can't believe how much time I spent trying to find something 'clever'! What a plumb I am!

Thanks for your suggestion

Paul

Well yes 🙂 but the poster seemed to want that? :-S

Yes I did 🙂 I can't believe how much time I spent trying to find something 'clever'! What a plumb!

Thanks for your suggestion

Paul

Thanks I thought of that, but sadly the value is then wrong on what SQL is looking for:

The FileSystemPath has to match exactly, so if I remove the apostrophes then...

Write the results of your SQL query out to a variable, try single row first, if you have a full result set then it gets a little more tricky.

1...

Hi Chris many thanks for this and you are absolutely right about the productid. I can't sady do anything with this however your query does look good.

As I only gave...

Well it works beautifully so does that mean the productid on the Catalogue table is messed up?

The script looks like a thing of beauty and works nicely....

Intrigued now...

CREATE TABLE [dbo].[CatalogueItem](

[MarketingTitle] [varchar](255) NULL,

[ProductID] [uniqueidentifier] NOT NULL

) ON [PRIMARY]

INSERT INTO CatalogueItem (MarketingTitle,ProductID) VALUES ('BBC TV Shakespeare: Henry VI Part III','69976081-320A-476B-994D-B11F9B3C33C7')

INSERT INTO CatalogueItem (MarketingTitle,ProductID) VALUES ('BBC TV Shakespeare: Henry IV...