While this video does not appear under "Videos" in the profile tab, it is part of videos on The Code Project. If you are interested in hosting a video on a coding solution on Code Project, email us at submit [at] codeproject.com.

Through this video I have tried for showcase following:

1. Importing Data from Excel (.xls)
2. Creating a dynamic and portable SSIS package for the same.
3. Creating a deployment utility through the manifest.
4. Deploy the package using the manifest
5. Also using the dtsconfig for creating a dynamic package.