Check SharePoint List Source and Destination adapters. They are for SQL 2008, but you can easily port them back to SQL 2005. You have the source code included.

Send Mail Task user interface doesn't support HTML message specification. However you can create a script, which uses the same functionality that the Send Mail Task is based on. Check...

Amith,

Can you create a script task in the second package, being executed with a script which shows MsgBox of the variable containing the ToLine value? Let's say if the variable...

Have you seen Script Task Plus? It does provide ability to implement reusable scripts and include your own setup and configuration. It is a light-weight approach, which doesn't require you...

You can pass variables to the send mail task. Right-click on the task select Properties menu. Scroll-down and find Expressions property. Press '...' and familiarize with the UI. You...

Can you elaborate more what are you trying to accomplish? Where is this user control going to exist? In SSIS or somewhere else?

Why not use the standard Send Mail Task?

Did you do this in BIDS? If yes, this will not be enough when running your SSIS package under SQL Job Agent Step. You have to use "Execute Process" job...

What you should do in this case is to devise a way to store your package decryption password in your activation key. Just keep in mind this might not be...

I would recommend when you have multiple issues to create multiple posts for each.

My recommendation for the 2nd issue is to run a script task after it finishes executing the...

What you have to do is select the 32bit version of DTEXEC. SQL 2008 includes new option in the SQL Job Agent step setup, which gives you easy setup ....

I'm not sure what the Excel destination component is based on, but I'm guessing it uses the same old Microsoft Jet provider. Do you have MDAC installed on this machine?...

Execute devenv with RunAs command. devenv is the executable used for BIDS.

What is the protection level of the second package? I'm guessing it is EncryptSensitiveWithUserKey. This option will not work, unless you use the same account you have used to create...

I would recommend that you take a look at the SSIS script component. You need custom logic and out of the box components cannot provide that kind of processing.