dan-572483 (3/25/2014)

---

The Excel file contains data going back several years and I'm only looking for data entered in the past few weeks. (Honestly it is a personal...

Why are they being taken off-line?

dan-572483 (3/21/2014)

---

Good point. As I read more I see that CDC can also be configured to track and capture multiple changed to the same rows between SSIS job runs....

So does it always fail...

Use a Script Task, not a Script Component.

Here's a C# snippet...

We don't use this tool, but it promises to do at least some of what you are looking for:

http://www.embarcadero.com/products/er-studio-data-lineage

Not free though ...

A CSV file is just a structured text file. Nothing...

No. How are you viewing the CSV? Use a decent text editor, not Excel.

Koen Verbeeck (3/24/2014)

---

aaron.reese (3/24/2014)

---

Thanks Koen, If its good enough for you, then I will take that option 🙂

Next question. Which files need to be in SCC and which...

Or maybe let SSIS do all the work by defining @@@ as a column delimiter.

You could potentially create a SQL Agent job to run the package and then allow the user to start that job.

Sounds like you have some corruption in your package. (Nasty! Call a doctor!...

You could try opening the package in an XML editor and looking for the offending GUID - might give you some clues.

aaron.reese (3/21/2014)

---

Depending on how strict your regression testing is, you might be better off with four separate packages and a master package that calls the four child packages. If...

elee1969 (3/20/2014)

---

Hello Gurus - I am building a package that has to output 4 flat files. Each flat file uses different tables. What is the best route to take to...