Wednesday, March 14, 2012 1:48 PMHi 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...
Wednesday, March 14, 2012 5:08 PMAnswerer
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]
- Marked As Answer by Jerry NeeModerator Thursday, March 22, 2012 10:39 AM
Thursday, April 05, 2012 1:09 PM
You may still be inserting into test db not into production db.
Test insert into production with the SSIS Import/Export Wizard:
- Edited by Kalman TothMicrosoft Community Contributor Tuesday, October 02, 2012 8:13 PM