SQL Server Performance

Password Protected xls and DTS

Discussion in 'SQL Server DTS-Related Questions' started by golfballtx, Mar 22, 2007.

  1. golfballtx New Member

    I have a password protected .xls spreadsheet that I would like to import to a sql table via DTS. I thought I could use a global variable in the package properties to set the password, but this does not seem to work. I have also tried to use activeX as follows:

    Function Main()
    End Function

    where logs is the connection name and psr4wsep is the password with no success! Anyone have experience with this?

    thanks in advance!!
    Keith Johnson
  2. MohammedU New Member

  3. dineshasanka Moderator


    Contributing Editor, Writer & Forums Moderator

    Visit my Blog at

Share This Page