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

Pah, you beat me to it!

CozyRoc (3/4/2011)

---

Koen Verbeeck (3/4/2011)

---

You can use a for each loop to loop over the table and store the tablename in a variable.

Then you can construct a dynamic SQL statement in...

You're looking in the wrong place.

Try the 'Project' menu - the item at the bottom of that menu will say [project name] properties - select that.

Koen Verbeeck (3/3/2011)

---

Dammit, if that is the solution, I've wasted 5 minutes of my life typing an answer while continuously checking the...