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 Package

DTS Package

Scheduled Pinned Locked Moved Database
databasesql-serverquestion
4 Posts 3 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.
  • C Offline
    C Offline
    current1999
    wrote on last edited by
    #1

    Hi All, Can somebody who has SQL 2000 assist with this? Create a simple DTS package using any table from Northwind DB and then prompt the number of rows in that table through a message box. This package should then be posted to me. Aim: I want to experiment conversion of DTS to SSIS 2008 package but I don't have SQL 2000 I look forward to your response. Regards, Current

    S 1 Reply Last reply
    0
    • C current1999

      Hi All, Can somebody who has SQL 2000 assist with this? Create a simple DTS package using any table from Northwind DB and then prompt the number of rows in that table through a message box. This package should then be posted to me. Aim: I want to experiment conversion of DTS to SSIS 2008 package but I don't have SQL 2000 I look forward to your response. Regards, Current

      S Offline
      S Offline
      Simon_Whale
      wrote on last edited by
      #2

      This is a great site that I use for such a requirment SQL DTS[^] They also run a site for SSIS to the link to that is at the top of the page.

      Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

      C 1 Reply Last reply
      0
      • S Simon_Whale

        This is a great site that I use for such a requirment SQL DTS[^] They also run a site for SSIS to the link to that is at the top of the page.

        Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

        C Offline
        C Offline
        current1999
        wrote on last edited by
        #3

        Thanks your response. I just wonder that I must have SQL 2000 before I can experiment the conversion.Am I correct? Thanks

        S 1 Reply Last reply
        0
        • C current1999

          Thanks your response. I just wonder that I must have SQL 2000 before I can experiment the conversion.Am I correct? Thanks

          S Offline
          S Offline
          S Douglas
          wrote on last edited by
          #4

          current1999 wrote: I just wonder that I must have SQL 2000 before I can experiment the conversion The answer is no, if you are just converting an existing package then all you need is the target version.


          Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

          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