Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / productivity / Office

Import Data from Excel into SQL Server Using SSIS

4.86/5 (7 votes)
16 Dec 2011CPOL 52.6K  
In this video article

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.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)