Rick Lang (1/3/2013)

---

Phil,

Think I may have it. I used a flat file connection Manager, selected advanced and put 5 additional columns into the connection. Drug a Flat File...

Have a look here and see whether it gives you enough to get started with this.

Not - not as a source, but as a transformation.

Essentially, the component takes each row as a single string and then, using parsing code within the script component, you break...

Rick Lang (1/3/2013)

---

I've got a print log that is saved daily into a CSV file and I'd like to use SSIS to import it into Sql Server 2012. The...

You could try varchar(max) instead.

;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...