Results 1 to 3 of 3

Thread: DTS selected columns from text file [resolved]

Threaded View

  1. Mar 1st, 2005, 04:51 AM #1
    thebloke
    thebloke is offline

    Thread Starter
    Hyperactive Member thebloke's Avatar
    Join Date
    May 2003
    Posts
    358

    Resolved DTS selected columns from text file [resolved]

    Guys

    I need to create a dts package to import a text file into sqlserver. This is fine but the problem I'm having is that the text file contains 4 columns and I only want to import the 3rd column. Again, this is no problem. The problem comes when I want to add an id column to the table. I've checked enable identity insert but it doesn't seem to work.

    Any ideas?!


    Thanks
    Last edited by thebloke; Mar 1st, 2005 at 09:58 AM. Reason: Resolved
    The Bloke
    www.blokeinthekitchen.com
    making cooking cool for blokes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width