No one got any ideas?

Sample SQL script below

Before checks -

Columns from Source

Address1 = 67 office

Address2 = NULL

Address3 = Reading road

Address4 = NULL

Address5 = NULL

Columns from destination

Address_1 =...

turning out there was a problem with our webservice.

Thanks for replying back, the xml data from the webservice is not being passed into the xml source file. The package execute without producing any errors but does not bring...

since the order does not matter your code is enough to get me started.

Thank you.

I'm guessing there no way around this problem?

Well the problem is our data supplier wants to be able to send us record-update information in XML, and wants to able to distinguish an empty XML element from a...

Would that also help with integer values?

Below is the sample XML code which produces empty strings but to ssis they are null values -

<from></from>

And I try adding default values but they still showed up...

thank you!

The sql script did not work for me, I don't have dbo.DelimitedSplit8K on my server.

SELECT id,

Result = STUFF(( SELECT '/' + CASE WHEN CHARINDEX('*', Item) = 0 THEN Item

WHEN...

Thanks for the pointers guys, I guess i missed out the most important part which is that the value in Segment column will be changing but the formatting will be...

Thanks the attempt but it still showing the zero instead of -1 then 1.

idname

-1d

0e

1f

2g

It should be –

idname

-1d

1e

2f

3g

It possible i over complicated the sample sql code, here a simper version-

Create procedure [dbo].[HealthCreateTestEntities]

(@CustomersTocreate int)

as

begin

declare @CustomerCounter int, @ChildElements int, @Bookings int, @Ancillary int

declare @XMLFileCustomers table

(

?RecordNumber int identity...

Thank you, it just what I need.