Dynamic Xl upload With Validation RRS feed

  • Question

  • Hi,

     This is from Chandrakanth.


       I need some Guidance regarding Dynamic Generic XL Upload With Validation.


       In MY Excel sheet in non -specific fields that means...


       In my excel sheet fields are not fixed it may be 5 columns,it may be 10 columns.


       I have to do this excel uploading with validation ,, while I am doing this excel upload I have to map
       with stored procedure.. and column data types...


       Developer does not involve on every uploading coding part...that means we have to facilitate to end user

       excel uploading any file regardless of fields and data types has to upload with validation...


       We have to make general Excel Uploading ,,,,,, wtih validation using SSIS feature in SQL SERVER 2005

       If u have any Idea(any other logic) to do generic excel uploading,,please share with me ...



    With Regards

    Thursday, October 11, 2007 12:06 PM