Click here to Skip to main content
15,867,835 members
Articles / Productivity Apps and Services / Microsoft Office
Article

Import Data from Excel into SQL Server Using SSIS

Rate me:
Please Sign up or sign in to vote.
4.86/5 (7 votes)
16 Dec 2011CPOL 51.7K   12   2
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)


Written By
Database Developer
India India
I am a Microsoft certified Technology Specialist in MS SQL Server 2008 and 2005.I have fair amount of experience and expertise in MS database development, administration and modeling and MS BI. Started my career in 2007 and primarily into MS databases, and later diversified into MS BI especially SSIS. I also have a little exposure in Oracle 10g while working on one of the migration projects. But MS SQL Server is my passion!

Firm believer in knowledge grows from sharing, I really like reading books, trying new features and sharing the little that I know. Unless we're willing to have a go, fail miserably, have another go, success won't happen. The best thing I have discovered about myself is the "never say die" attitude. The best comment I have ever received is when my manager at my first job said "when this guy works he throws away his watch".

Comments and Discussions

 
QuestionAn excellent article which helped me tremendously Pin
Raimundo2a10-Dec-13 2:07
Raimundo2a10-Dec-13 2:07 
Thanks Keshav for this fantastic video. It really helped me alot. I watched it again and again and paused and backed up and reviewed alot, so having it in video format was also a big help.

Now I only have one question. I am trying to use the package (not project) deployment option for SSIS. This way I can use the variables like you did in the video for the EXCEL path and table name. This is better because then I reduce the number of SSIS packages. I see that.

I get all the way up to setting the variables as exportable in creating the package and the system accepts everything. Afterwards I save and I look at the xml in a browser to see what the config dtsx file contains but it doesn't show any variables at all. Do you have any ideas why it might be doing this. I am using visual studio 2010 and am connecting to an SQL 2012 database.
GeneralMy vote of 5 Pin
jameseverest 31-Jan-12 8:53
jameseverest 31-Jan-12 8:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.