Viewing 15 posts - 3,301 through 3,315 (of 13,855 total)
I take it that keeping your packages in their corresponding source control branches is not possible?
September 24, 2019 at 7:09 pm
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.
September 24, 2019 at 3:12 pm
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);
September 24, 2019 at 2:03 pm
As i cannot post the actual data and table structure. .I have created that table , so that i can post it in sql center portal .
That's fine, but...
September 23, 2019 at 2:12 pm
That's a much better solution, thanks John. <Phil heads for coffee break>
September 23, 2019 at 12:54 pm
There is [TABLE_SCHEMA], [TABLE_NAME], [COLUMN_NAME], [datatype] is the pk
You mean this column?
[datatype] [nvarchar](151) NULL,
Seems an odd choice. Also, this column is nullable and therefore cannot be a PK.
September 23, 2019 at 12:45 pm
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...
September 23, 2019 at 12:42 pm
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...
September 14, 2019 at 12:31 am
Using serializable should do the trick in your example, I agree.
September 13, 2019 at 6:54 pm
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...
September 13, 2019 at 6:50 pm
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...
September 13, 2019 at 5:09 pm
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?
September 13, 2019 at 2:17 pm
Have you done a search for this? It's a common requirement. Check here, for example.
September 13, 2019 at 2:14 pm
How is sequence defined?
September 13, 2019 at 1:47 pm
Viewing 15 posts - 3,301 through 3,315 (of 13,855 total)