Uploading Excel data to SQL Server using SSIS With c#,asp.net

Question

Hi All, 

I have a requirement to upload excel data (from .aspx) to the SQL server. To do this I am implemented using SSIS. I have created SSIS package(deployed) and executing it using c#. When i am running the application it is working fine inserting data into the database. After publishing it and configured in the production server no records are inserting into the database. Can any one please do the need full thing. Thanks in an advance... 

Regards, 
Jeevan. 

Answer 1

So it works with your test server and doesn't work with production server. Is that right?

I'm not sure how anyone can help you. You probably need to debug your SSIS package and tell us what error you are getting.

---

Tatyana Yakushev [PredixionSoftware.com]

Answer 2

You may still be inserting into test db not into production db.

Test insert into production with the SSIS Import/Export Wizard:

http://www.sqlusa.com/bestpractices/ssis-wizard/

---

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012