Post reply

Need to import data from the a password protected Excel file to Sql Table using SSIS.

  • May 11, 2011 at 5:13 pm

    #145593

    Can anyone please help me in this . I need to import data from an excel file on a file server , but the excel file is password protected , I have the password with me , is there a way i can do this import to sql table using SSIS.

  • May 12, 2011 at 1:45 am

    #1323506

    Have you tried to first open the Excel file and then do the extraction?

  • May 12, 2011 at 10:16 am

    #1323803

    Thanks Andre for the response , I have tried to first open the Excel file and then do the extraction , it did work fine , but I would have to automate this as a daily process , as such I need to try some other way.

  • May 12, 2011 at 10:49 am

    #1323822

    Bummer but it looks like it can't be done directly using SSIS...it needs some pre-processing:

    http://www.sqlservercentral.com/Forums/FindPost888553.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • May 12, 2011 at 11:21 am

    #1323845

    yep, not supported out of the box. Apparently Cozyroc (spelling?) has an excel connector that supports this, but, thats 3rd party and costs (not sure how much) so it may not work for you.

    Steve.

Viewing 5 posts - 1 through 4 (of 4 total)

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