I think that your problem is that when you open the writer the second time it overwrites the contents of the file.

To avoid this, just open the writer at the...

Code-1029433 (3/9/2011)

---

Hi Guys,

I've been searching the forums trying to find the answer to my question but I'm not having much luck. The majority of our clients require that...

natarshia.peck (3/9/2011)

---

Well a. i'm a new employee and the file we get are text qualified with "" and comma delimited. so a row looks like this

"some text","some text2","some name "BookTitle"...

Impressive commitment! When I am 'between projects' I tend to work on improving my guitar skills:smooooth:

That's a message I always try to get across. The fact that the files are usually called 'Comma Separated' is not helping the cause one bit and I think we...

Koen Verbeeck (3/9/2011)

---

natarshia.peck (3/8/2011)

---

Hello

i am running into a similar problem with the embedded double quotes.

I tried using the redirect row on error to just skip those rows with the double...

Other than the ideas put forward by myself and Todd, I know of no way forward for you.

There is nowhere in the system where you can set a flag: "Skip...

Was that deliberate?? Nice pun!

Not in the package, but within the job set-up.

I'm with Craig on that - can I ask what made you post this question in the SSIS forum? Do you have a certain solution or methodology in mind that...

Try this:

@[System::PackageName] + RIGHT((DT_STR,4,1252)YEAR(GETDATE()),2) + RIGHT("0" + (DT_STR,2,1252)MONTH(GETDATE()),2) + RIGHT("0" + (DT_STR,2,1252)DAY(GETDATE()),2)

Please take a little more care with your question.

What do you mean...

Sure - that's what it's for 🙂

jcrawf02 (3/4/2011)

---

heh...makes me think of that sig (can't remember whose at the moment) "semper in...

jcrawf02 (3/4/2011)

---

How do I decide when to use subpackages vs stored procedures vs straight SQL tasks? I would...