14 Maret 2012 13:48Hi 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...
14 Maret 2012 17:08Penjawab Pertanyaan
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]
- Ditandai sebagai Jawaban oleh Jerry NeeModerator 22 Maret 2012 10:39
05 April 2012 13:09
You may still be inserting into test db not into production db.
Test insert into production with the SSIS Import/Export Wizard:
- Diedit oleh Kalman TothMicrosoft Community Contributor 02 Oktober 2012 20:13