Great overview.  What I find the most confusing with SSIS is the new package security, encryption options, storage options, migration of packages, etc.  Any good resources on that?

Thanks,

ABates

The book covers migration and storage for sure.  I haven't found security and encryption yet. It might be there, but I haven't read the whole book. I actually wrote two of the chapters.  If security and encryption isn't covered, I'll try to write an article on it.

Thanks!

Kathi

ABates,

Encryption options are all to do with the ProtectionLevel property of the package. BOL should help and if it doesn't, reply here.

I've got a bit of info here on storage options: http://blogs.conchango.com/jamiethomson/archive/2006/02/20/2902.aspx or http://blogs.conchango.com/jamiethomson/archive/2005/05/05/1382.aspx and Kirk Haselden has some here: http://sqljunkies.com/WebLog/knight_reign/archive/2005/05/05/13523.aspx

-Jamie