Hmm, risky recommendation. Not sure I could solve this one using my iPod 🙂

Looks like everything worked OK apart from Send Mail - and that failed only because of a missing addressee?

At what point does it fail? Which component fails, I mean?

Please post the text of the error message.

I think you mean SSIS package, rather than DTS, but please confirm.

Are you...

That doesn't look like it will be very easy.

I'm interested to see what happens with white visitors 😀

Are you using a flat file source?

You need to go into the Expressions section for the flat file source and set the file name/path to your file-path variable using an...

Sounds like you might be looking for the SSIS equivalent of T-SQL MERGE, is that right?

What version of SQL Server are you using?

Please read Lowell's post.

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: