Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: Modifying the DTS package.

    I have a scheduled DTS package which gets the data from a text file and imports into a sql table.The table will be droped and created whenever the DTS package runs.previusly the table has 6 rows and now i wanted to add a column row_id which is having an idenity seed.So how can I modify my package so that I can get done with my requirements.

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    I'm assuming that row_id is not a column in the text file since you're setting this up with an identity seed. If this is the case, there's nothing you need to change in your DTS package to have row_id populate on an INSERT, it's done automatically.
    That which does not kill me postpones the inevitable.

Posting Permissions

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