SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Aug 2005
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    DTS Transform: query multiple data sources?

    Hi, I'm using DTS, and I have set-up a data transformation link between two sources. However, when I create my SQL query I have so far only been able to pull data from my Source DB -- is there any way to also reference data from my Destination DB in my query?

    Thanks

  2. #2
    SitePoint Zealot CdeMky's Avatar
    Join Date
    Sep 2004
    Location
    United States
    Posts
    123
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by brodgman
    Hi, I'm using DTS, and I have set-up a data transformation link between two sources. However, when I create my SQL query I have so far only been able to pull data from my Source DB -- is there any way to also reference data from my Destination DB in my query?

    Thanks

    Yes, use the db name. i.e. select * from db1.tablename t1, db2.tablename t2 etc..

  3. #3
    SitePoint Member
    Join Date
    Aug 2005
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    CdeMky, I tried your suggestion and am still experiencing problems. I used the query:

    select * from db1.dbo.tablename1

    and receive a Mircrosoft JET db engine error "Cannot update. Database or object is read-only."

    When I run the same query above in a DTS Transformation where the Source is my db1, the query works fine. But I want to use that query where the Source isn't db1. Any suggestions?

    Thanks


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •