I don't think it should be that messy - depending on your coding skills, of course 🙂

For each table in [array]

create destination table

copy data across

Next

Simple:-D

The data flow component does not work well in dynamic situations: you need to find another way.

One is the use of dynamic SQL to do all of the DDL and...

Brings to mind a whole batch of accountants doing multi-tab analyses very very slowly...

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