Thank You Euan,
I created package in SQL 7 sp2 and has a password. I don't know the
version of DTS Package. Can you please give more details. Also how to get
around this. If I generate package in SQL 2000 with sp3 would solve the
> I suspect you are trying to load a DTS 2000 package via the COM objects
> 7.0, this will not work unless you specify a password or are running SP3
> the 7.0 box
> Hello, I'm the humble disclaimer. Nobody really likes me. I'm used to
> ignored and maligned - I still get the job done. If you cared enough to
> me, you'd learn that this posting is provided "AS IS" with no warranties,
> and confers no rights. You assume all risk for your use. ? 2001 Microsoft
> Corporation. All rights reserved.
> > I have created DTS package in SQL 7 to import excel file.
> > I am able to execute the package from VB on Development server which
> > off of SQL 7. But the production server runs off of SQL 2000. When I
> > run my vb script to execute the package in Production, it gives me
> > following Error :
> > 1. When I use the Default Connection to SQL 2000
> > The error I get is '%1 not found'
> > 2. When I Use Trusted Connection
> > The error I get is 'Login not found for user xxxx