Post reply

Fixing Data with DTS

  • September 8, 2004 at 12:15 pm

    #86350

    I have a DTs Mapping:

    Connection 1 - MS Access

    Connection 2 - SQL Server

    I want to add a Lookup for a transformation but when I add it and try to create the query it gives me every other conneciton option but 2.  It seems to understand the SQL I put in but in the fields never appear in the VB area where I would use the lookup.  Any idea why and what I've done wrong.  I have some dirty data I need to refresh/rewrite.

     

    Thanks for looking at this ... the DTS area is unresponsive

     

    Any help you can provide is appreciated, A DBA on DTS

  • September 8, 2004 at 10:27 pm

    #522231

    You would benefit from a performance perspective if you created a separate connection for your lookup.   Have you tried creating another connection and using that for your lookup?

  • September 9, 2004 at 12:42 pm

    #522368

    No.  I'll give it a try.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply