A couple of questions:

* Is the package running on the same machine as where the database is located?

* Are you moving this data using a data flow task or...

#11 I would disagree with your answer. I don't know at all how Checkpoints can considered expensive. All they are is a simple XML file that the package uses...

For one, take a look here: http://support.microsoft.com/kb/969845/EN-US

Secondly, you may want to look more into handling errors in your package. You can use the error path to...

yes, that is correct

The dummy statement is only for the dataset you are returning. Unless I misunderstand your situation, you want to use a stored proc as a source in your data...

If I understand what you are asking, I think you have tableA, tableB, tableC, etc in your MySql database, and you want to move that data into tableA, tableB, tableC,...

As John said, the key is to trick SSIS. Sometime you want use temp tables in your stored proc and because of the size of the dataset you...

There are dozens of new features available in SQL Server 2005 vs 2000. It is really too broad of a question to answer adequately on here with out a...

If you are using a Data Conversion transformation in SSIS, a new column is created. So if you have a "col1" which is a non-unicode string (DT__STR), and...

If you are seeing an initial 45 second delay when you perform a search, it may be caused by by SQL Server attempting a file signature verification, but is unable...

I agree. I always prefer using backup and restore. You can go back and drop the database from the original location once...

One of the good things about SSIS is that you do not need to use script tasks for everything that you did in DTS. When I first was rewriting...