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

Eric Mamet (3/20/2014)

---

Yes... but I am trying to avoid putting my (Fact) table in a staging table so I would like to drop the rows straight into the destination,...

I presume this is because you may have multiple occurrences of the 'new' lookup item in your source data and you don't want to risk creating something which is already...

declare @XML as xml

set @XML = '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_GB" default-locale="en_GB"><Title language-id="en_GB">Cookies</Title></root>'

select @XML.value('(root/Title)[1]', 'varchar(50)')