Post reply

remove excel password

  • June 11, 2008 at 3:59 am

    #187863

    hi,

    Can you guys show me an example of how to remove the password frome excel using scrip task in ssis.

    thanks

  • June 11, 2008 at 8:07 am

    #827265

    anyone on this????

    let me clarify a bit more,

    i want to load data to sql server database. the excel sheet comes with password, i have the password i am just lost at writing the script for it as i cant get object/reference of excel in script task.

    please help!!!!!!!!

  • June 12, 2008 at 1:07 am

    #827672

    You will most probably end up taking control of the excel object model within your scripting task

    ~PD

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply