Very Computer

If anyone has an example that actually works I would be very grateful.

Other details of my project.  The data source is an Excel sheet.  The
destination is an Access db.  The table being used for the lookup is also in
the same access db.  Direct column mapping (or even doing direct mapping
using script) works fine.

For direct mapping the script is:  DTSDestination("Project Name") =
DTSSource("Project Name")

Trying to use lookup my line is:  DTSDestination("Project Name")
=DTSLookups( "ProjNameTOProjNum").Execute(DTSSource("Project Name").Value)

My lookup is: ProjNameTOProjNum
with SQL:  SELECT ProjectNum
FROM Project
WHERE (ProjectName = ?)

Is there any other information I can provide?

If responding directly by email, please remove anti-spam measure.

Thank you in advance for your help.

Charley Rathkopf

DTSDestination("Project Num")
=DTSLookups( "ProjNameTOProjNum").Execute(DTSSource("Project Name").Value)

This is fixed in SP1

Euan

Quote:> Has anyone had any luck using a lookup in a DTS transform.  I swear that
I'm
> doing a direct translation of the example ('Performing Single-key Lookups
> from an ActiveX Script' on the MSDN web site
> http://msdn.microsoft.com/library/sdkdoc/sql/dtssamp_4.htm ) but I always
> get the error:  "An exception of type 'Microsoft VBScript runtime error:
> Type mismatch:  'DTSLoopkus'' was not handled."

> If anyone has an example that actually works I would be very grateful.

> Other details of my project.  The data source is an Excel sheet.  The
> destination is an Access db.  The table being used for the lookup is also
in
> the same access db.  Direct column mapping (or even doing direct mapping
> using script) works fine.

> For direct mapping the script is:  DTSDestination("Project Name") =
> DTSSource("Project Name")

> Trying to use lookup my line is:  DTSDestination("Project Name")
> =DTSLookups( "ProjNameTOProjNum").Execute(DTSSource("Project Name").Value)

> My lookup is: ProjNameTOProjNum
> with SQL:  SELECT ProjectNum
> FROM Project
> WHERE (ProjectName = ?)

> Is there any other information I can provide?

> If responding directly by email, please remove anti-spam measure.

> Thank you in advance for your help.

> Charley Rathkopf

I do focus the same problem like Charley Rathkopf

Using the construct:
DTSDestination("Abt_Ix") =
TSLookups("A").Execute( DTSSource("Col001").Value)
Will fail with error: Type mismatch 'DTSLookups'

The lookup query, his name is 'A':
SELECT Abt_Ix
FROM T_Abteilungen
WHERE (Abt = ?)

I have SP1 installed.

And Keller, UNISYS Switzerland

Quote:> Has anyone had any luck using a lookup in a DTS transform.  I swear that
I'm
> doing a direct translation of the example ('Performing Single-key Lookups
> from an ActiveX Script' on the MSDN web site
> http://msdn.microsoft.com/library/sdkdoc/sql/dtssamp_4.htm ) but I always
> get the error:  "An exception of type 'Microsoft VBScript runtime error:
> Type mismatch:  'DTSLoopkus'' was not handled."

> If anyone has an example that actually works I would be very grateful.

> Other details of my project.  The data source is an Excel sheet.  The
> destination is an Access db.  The table being used for the lookup is also
in
> the same access db.  Direct column mapping (or even doing direct mapping
> using script) works fine.

> For direct mapping the script is:  DTSDestination("Project Name") =
> DTSSource("Project Name")

> Trying to use lookup my line is:  DTSDestination("Project Name")
> =DTSLookups( "ProjNameTOProjNum").Execute(DTSSource("Project Name").Value)

> My lookup is: ProjNameTOProjNum
> with SQL:  SELECT ProjectNum
> FROM Project
> WHERE (ProjectName = ?)

> Is there any other information I can provide?

> If responding directly by email, please remove anti-spam measure.

> Thank you in advance for your help.

> Charley Rathkopf

Thanks.  Late Friday I tried executing the package and, much to my shock and
surprise, it worked correctly.  I thought for sure that I had tried to
execute it before, but I think at that time it was still* up on other
bugs.

This little bug really limits the use of that test button, doesn't it.

I am using a 120 day eval that came with a book.  Do you know if I can apply
SP1 to this.  I'm currently waiting for my free development copy that I'm
supposed to receive because I bought Visual Studio 6.0 and sent in the
coupon.  Does anyone know if there is a way to check on the status of this
with Microsoft, or did I just give them more marketing info and otherwise
send my request into a black hole.  Did anyone else ever receive their
development edition of SQL 7?

Charley