You've been here long enough to know the score. Please provide DDL, sample data and desired output in readily consumable form, as per the link in my signature.

Create an empty solution and add the .dtsx file to it. Then you'll be able to open it.

opc.three (1/3/2013)

---

The only way to format an Excel Workbook programmatically using SSIS is to leverage the Excel Object Model from a Script Task.

One technique I have used in the past...

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