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()
    Connection("logs").psr4wsep
    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

    http://sqljunkies.com/WebLog/madhivanan/archive/2005/07/27/16233.aspx

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page