I take it that keeping your packages in their corresponding source control branches is not possible?

Expedia and other travel sites are being battered at the moment by people stranded as a result of Thomas Cook going into administration ... that may be a factor.

DECLARE @x VARCHAR(4000)
    = '<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

<soap:Body>

<ns1:openSResp xmlns:pf1="http://autogd.NewWebServiceApi.webnew.com/">

<return xmlns:pf2="http://autogd.NewWebServiceApi.webnew.com/">

<pointid>0</pointid>

<newstatus>failed</newstatus>

<ssId>Seasond12453678</ssId>

</return>

</pf1:openSResp></soap:Body>

</soap:Envelope>';

SELECT SUBSTRING(@x, CHARINDEX('<ssid>', @x) + 6, CHARINDEX('</ssid>', @x) - CHARINDEX('<ssid>', @x) - 6);

That's fine, but...

That's a much better solution, thanks John. <Phil heads for coffee break>

You mean this column?

[datatype] [nvarchar](151) NULL,

Seems an odd choice. Also, this column is nullable and therefore cannot be a PK.

Here's a long-winded way - nothing better comes to mind right now.

Please provide set-up data in future - you'll find that people are more willing to help if you do...

What is the PK of this table?

I agree, and no setting that I can think of right now. Just goes to emphasize how important it is to get your pipeline data types in order.

And surely, if...

Using serializable should do the trick in your example, I agree.

OK, I might know what's happening.

Your screenshots are for the destination, not the source.

So your column comes in as string(100), goes through the SSIS pipeline unhindered and then out to...

If you add a data viewer after the source component in the DF, you should be able to verify whether the data has already been truncated (and therefore whether SSIS...

Is the data which you provided the desired output, or is it the base data?

Whichever it is, can you also provide the other part?

Have you done a search for this? It's a common requirement. Check here, for example.

How is sequence defined?