In the Flat File Destination, you have a checkbox for "Overwrite data in the file". I assume if you leave this blank data will be appended.

No, it's not possible.

Last time I checked DD04500 is not a number.

Read the note in the following reference:

TRIM (SSIS Expression)

Maybe you have "different" type of spaces.

Checkpoints work at the task level, not at the row level in the dataflow.

This means that the entire dataflow will be restarted.

Which makes sense of course. Data flows through the...

You could use an Execute Process Task to call a package using DTEXEC.

In the DTEXEC command, you can specify a config file.

I would go immediately to SQL Server 2012.

I don't know if you do a lot of BI, but SSIS and SSRS would need a lot of upgrading.

The improvements in SSIS, Power View (new reporting tool), Data Quality Services and SSAS Tabular.

None of those are available in Express 😀

How do you check if the initial catalog has changed or not?

MissyDaisy (7/3/2012)

---

Thanks! yes, I did have an expression with the folder variable. THe issue was the folder dynamic value was not passed to the SSIS package.

I found out...

This is incorrect syntax:

select @Paths = 'C:\xmls\' ,

@FileName = dbo.table.Product_ID,

@FileExtension = '.xml'

There is no FROM clause, so basically you are trying to put the string dbo.table.Product_ID into the FileName variable,...

The first lines need to be added through a script task.

After that, use a dataflow with flat file destination to append the data to the existing flat file.

You need to add error handling to your derived column.

Add a flat file destination, and connect the derived column to this flat file destination with the red arrow. Configure the...

Here you go:

http://www.sqlservercentral.com/Forums/Topic1323601-1292-1.aspx#bm1324127

I thought it...

Congrats and well-deserved!

cbrown-779669 (7/3/2012)

---

Thanks, I am using Visual studio 2010 to develop the ssis. Doing a oracle to oracle elt job. However I have not been able to find a component that...