sql2k8 (5/13/2010)
this is how it is supposed to workwhen the data gets loaded . the excel will be kept in a file share. then the users will upload the excel to share point.
right now i am loading the data to an excel and i am sending the excel to a user to check the excel if it is getting uploaded. he tells to me that if he opens the excel and saves it it gets uploaded .
if he tries to directly import the excel to the application.he gets an error that it is an invalid spreadsheet.
i want my excel to get directly loaded into the application with out saving it again at the user end.
Please help me.
How does SSIS fit into this equation?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.