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.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Why not use the standard Send Mail Task?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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 ....

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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?...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/