Implementing Transactions in SSIS

Let’s say you’ve many control tasks and you’ve to implement transaction.
Points to Note:
1. You cannot Implement Transaction in a task which has truncation
2. Transaction has no effects in file processing and archiving it works only for DB

If you want to have transaction for only one task then select the Isolation Level as “Serializable” and TransactionOption as “Required”

If you want to have transactions for many or all of the control tasks then set the TransactionOption as “Required” in the package and “Supported” in the Control Tasks.
For the Control Task s where you doesn’t require transaction choose “Not Supported”

Vista Slow Copy to CD

I had some pictures in my ‘Picture’ folder and I copied and pasted it to the CD Drive and Vista was copying the files very slowly. At one point of time it showed “1222005 Days and 6 hours remaining”!!!!!!
I dono whether I can stay alive to see the files copied to the CD 
Every time it copies a file it showed a Try Again Dialog box.
I searched the net and found that this seemed to be an internal mapping issue.
The only way to get over this is to create a new folder in C Drive and copy the pictures there and from this folder copy to the CD Drive.

Its not = null It is "is null"

I'm doing this mistake time and again in T-SQL
You should not use = with null, you should always use is null
eg:
WRONG:
EndDate = null
RIGHT:
EndDate is null