This is a great article Steve.  Very simple as has been stated, but people should know how to apply a simple tutorial to a complex environment.

I always knew profiler was...

Bart that is great to know, but that is still asking a lot of people to put a lot of faith in your company.  I have never heard anything bad...

That would have been great, bummer they took it out.  I know they removed it because of a time crunch but do you know if they are planning on adding...

I do alot of development in addition to writting SQL code and have really gotten hooked on intellisence.  I know that in a perfect world, rules would be followed so...

That is great, you definitely had me rolling on the floor.  However, I am glad I wasn't the one dealing with it

Since the writting of this article I have developed the right click and disconnect idea.  If you would like the files for this then PM (click on my username) me...

the SSIS flat file destination doesn't have the ability to ignore errors that I can see.  All source connections (including flat files) have the ability to ignore errors but not...

Several good points have been made already, especially the bit about piracy causing dependence on windows.  The few dollars they will make by catching a teenage pirate would be more...

Thanks for helping Jamie.

In DTS the package consisted of a SQL select statement with a flat file destination.  By default, DTS would export as much of the values as it...

I am migrating this package from DTS and, like you, I assumed that SSIS wouldn't make it more difficult that DTS.

However, that is a good suggestion.  Thanks and I will...

It is my understanding that it primarily depends on the code inside your activeX scripts.  Scripts which access the package object (which no longer exists) won't migrate over.

However, even if...

Sure saeed,

1) If you will look at the code in the article you can use the following exerpt to identify the correct location for changing the code.  The code you quoted is what...

No problem, it is a start.  Let us know if you develop any new cool addons or if you clean it up a bit.

I would have to say that my favorite tech sci fi book is:

The Illuminati by Larry Burkett

We are currently trying to migrate to SQL2005.  I have found that the two biggest differences are system tables and SSIS.  Migrating from DTS to SSIS is anything but simple...