I'm getting "Invalid Authorization Specification" when i try to run a DTS
package from excel.

I get an error on this line.......I have been leaving "sa" and "Password"
blank since we use windows authentication.........I don't have a username and
password for sQL server.

oPackage.LoadFromSQLServer "Server", "sa", "password", , , , , "package"
--
"Just because you don''t know how to do something doesn''t mean it can''t be
done"

Billy Rogers

Currently Using SQL Server 2000, Office 2000 and Office 2003

http://thedataguru.blogspot.com/