Click here to Skip to main content
15,917,731 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more: , +
Hi All,
I have a requirement to upload excel sheet from .aspx to the SQL server. I am implementing using SSIS. I have created SSIS package and executing it using c#. When i am running the application it is working fine inserting 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.

Regards,
Jeevan.
Posted
Comments
Herman<T>.Instance 14-Mar-12 9:43am    
huh? not clear!
Herman<T>.Instance 14-Mar-12 10:54am    
Has the user that runs the SSIS package the rights to run it on prodcution?
bbirajdar 26-Apr-12 10:10am    
No error messages mentioned. How can we guess whats happening on your server?
bbirajdar 26-Apr-12 10:10am    
Reason for my vote of 1
No error messages mentioned.
bbirajdar 26-Apr-12 10:11am    
Duplicate question http://www.codeproject.com/Questions/364008/Import-Excel-data-to-SQL-Server-Using-SSIS-package

1 solution

 
Share this answer
 
v2

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900