Very Computer

by **Shilpa Khambhat** » Thu, 04 Oct 2001 04:35:57

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 runs
off of SQL 7. But the production server runs off of SQL 2000. When I try to
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

by **Euan Garde** » Thu, 04 Oct 2001 14:51:12

I suspect you are trying to load a DTS 2000 package via the COM objects from
7.0, this will not work unless you specify a password or are running SP3 on
the 7.0 box

--
-Euan

Hello, I'm the humble disclaimer. Nobody really likes me. I'm used to being
ignored and maligned - I still get the job done. If you cared enough to read
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.

Quote:> 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 runs
> off of SQL 7. But the production server runs off of SQL 2000. When I try
to
> 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

by **Shilpa Khambhat** » Thu, 04 Oct 2001 20:54:33

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
problem?

-Shilpa

> I suspect you are trying to load a DTS 2000 package via the COM objects
from
> 7.0, this will not work unless you specify a password or are running SP3
on
> the 7.0 box

> --
> -Euan

> Hello, I'm the humble disclaimer. Nobody really likes me. I'm used to
being
> ignored and maligned - I still get the job done. If you cared enough to
read
> 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
runs
> > off of SQL 7. But the production server runs off of SQL 2000. When I
try
> to
> > 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

Very Computer

DTS Error:

DTS Error:

DTS Error:

DTS Error: