Hi Sgmunson

Thanks for the responseThe replication is set to Initialize from backup so that is what I have been doing but the ID in the tables...

Thanks for all the reply's I've been fire fighting for the last two days and now playing catch up so I will take a look at the options next week...

Thanks all that did the trick 🙂

Hi Phil

I got it to run from the command line just can't get it to run from the SSIS execute task it opens the ssh terminal session then...

Just a quick update we check for packet drops between the server and our office but all seems fine so the issue is not related to that???

Hi Chris

Many thanks this works like a treat

I never stop learning in this game 🙂

Also thanks to everyone else

KR The Monkey

ChrisM@Work (8/3/2016)

Northern Monkey (8/3/2016)

Arrrrrrrrr I got an error trying to post the info you wanted

CREATE TABLE [dbo].[Staging_Feed_AffW](

[product_name] [nvarchar](max) NULL,

[commission_group] [nvarchar](max) NULL,

[model_number] [nvarchar](max) NULL,

[colour] [nvarchar](max) NULL,

[keywords] [nvarchar](max) NULL,

[custom_1] [nvarchar](max) NULL,

[custom_2] [nvarchar](max) NULL,

[custom_3] [nvarchar](max)...

Also I would like to add a parameter to be passed from the case statement to the function to limit the type of product I have a column named TypeID...

Hi Phil

Sorry for the vague question and not making things clear

The main question is can I use a different method / code for the function as this one seems...

I've been trying to find an answer to this but no joy so far :ermm:

Any more help please!

PS I would add the list of colours in to a table at some point just short on time at the moment 🙁