;WITH XMLNAMESPACES('www.your_url.com' as s3,'www.google.com' as s2,'www.google.com.mt' as s1)

select cast(replace(cast((SELECT

"Cell"='StringLiteral',

"Cell/Data"='String',

"Cell/Data" = 'Acme, Inc', ''

FOR XML PATH('Row')) as varchar(8000)),'xmlns:s3','s1:s3') as xml)

OK - and what about replication or CDC?

Duplicate post. Responses here please.

sram24_mca (1/3/2013)

---

We have 2 databases Source Database and Destination Database, We want to transfer data from source table records to destination tables immediately .

Can anyone provide tips to implement this...

iglinka (1/2/2013)

---

Thanks, Phil and Daniel!

I've already spent a few days researching and setting up the package configuration table (actually using a View which filters the rows on HOST_NAME() per this...

You should be able to make this fairly easy to manage using package configurations to control the connection strings for the different connections.

But it will take a bit of setting-up...

P Jones (1/2/2013)

---

Try bringing in the decimal field as varchar(50) and then using a derived column transformation to convert it rather than doing everything in the flat file connection manager....

sam 55243 (1/2/2013)

---

Hi Phil,

I had to make few changes in my script component code, so as to generate only one consolidated output file. 🙂

If you had seen my code earlier...

Is there any additional complexity to the SSIS package which you have not mentioned?

Is the data flow in a Foreach container, perhaps?

No idea why replacing a proc with another version...

I'm puzzled by this. The Script Component only seems to write to a single file.

Can you tell me the file names of the two files which are generated please? Are...

Can you share the code inside the Script Component?

I thought I'd give this...

Oh come on. Please see the link in my signature regarding how...

If you really need to do this, you might have to resort to dynamic SQL. At the moment, SQL is treating 'USA','CAN' as a single-valued list (so if the country...

Roland, I tweaked your query a little to include a WHERE clause & was consequently able to simplify the CASE construct. Also, your update needed to reference the alias (t1)...