First of all, forget about the data mining task. It has nothing to do with your requirements.

You must first load the data from the flat files into a relational database...

I think it has more to do with DB2 then with SQL Server or SSIS, so you should probably check out your source.

Probably an issue with QUERYTIMEOUTINTERVAL.

When working with SSIS, forget everything you know about DTS. They are two different products.

If you want to write to an Excel file with the Excel Destination in the data...

This should point you in the right direction:

http://msdn.microsoft.com/en-us/library/ms189799.aspx

Especially look at example B.

You can have several subplans with different schedules, if I'm not mistaken.

Dave Ballantyne (1/4/2011)

---

Had to share ... On facebook one of my wifes friends posts

On drilling into C++ from C#, I know now why C# is so called "word safe": Bloody...

Another great SSIS question Andy!

This article describes the steps needed for the solution I already gave. However, the article is written by someone who doesn't really understand Integration Services. Fortunately,...

Nakul Vachhrajani (1/4/2011)

---

I think one title will always be insufficient for this question! The question attempts to test 3 different things:

1. UNION v/s UNION ALL

2. Use of TRUNCATE in a...

Brandie Tarvin (1/4/2011)

---

I still don't understand what the purpose of reprinting the article was. His explanation (preserving it for Denali) made no sense to me. The article's going to remain...

Hmmmm. Maybe you can convert the rest of those columns to DT_STR and use varchar in the destination.

LutzM (1/4/2011)

---

I'm sorry if it comes across brutal. It was definitely not my intention.

I'm confident I...

Congratulations Steve.

This...

I still don't know what you are trying to do.

Are you moving or copying data? Or are you deleting it?

From SQL Server to another SQL Server?

Is all the data in...

I think it is best that you start up a new thread for this, as it has little to do with the original question.