Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. DTS Query

DTS Query

Scheduled Pinned Locked Moved Database
databasesql-serversysadminquestion
3 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A Offline
    A Offline
    A Muthunagai
    wrote on last edited by
    #1

    Hi All, I want to pass the table from Server to My PC. Particular table values only I want. How can I fetch the values from Server using DTS. I'm using Sql server 2005.Give me any sample. Thanks in Advance

    R A 2 Replies Last reply
    0
    • A A Muthunagai

      Hi All, I want to pass the table from Server to My PC. Particular table values only I want. How can I fetch the values from Server using DTS. I'm using Sql server 2005.Give me any sample. Thanks in Advance

      R Offline
      R Offline
      Rob Graham
      wrote on last edited by
      #2

      I think you need to rephrase your question. As it currently stands, it makes very little sense. What do you mean "pass the table" It sounds like you want to query a table for some specific rows using some application running on your PC to get data from some server (on your local network?). Why you would think DTS was appropriate is beyond me...unless you want to store the data locally in a different database, after extracting it from SQL 2k5.

      1 Reply Last reply
      0
      • A A Muthunagai

        Hi All, I want to pass the table from Server to My PC. Particular table values only I want. How can I fetch the values from Server using DTS. I'm using Sql server 2005.Give me any sample. Thanks in Advance

        A Offline
        A Offline
        A Muthunagai
        wrote on last edited by
        #3

        Hi, I want to know more abt DTS. If u have any samples,msg me. I Created the sample dtsx in BI successfully. Is there any way to see the coding for dtsx? Thanks in advance

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups