Results 1 to 2 of 2

Thread: Dts

  1. #1
    Join Date
    Mar 2004
    Posts
    84

    Dts

    Hi All,

    I need to export data from table in Access to table in SQL Server. I am using DTS import/export wizard to do that. The problem I am having with it is when I select the Access table as my source and look at column mappings and transformations, I am noticing extra columns. What is causing it and how to get around it? Thanks.

  2. #2
    Join Date
    Feb 2003
    Posts
    1,048
    On which side are you seeing the extra columns, Access or SQL Server?

    The only reason you should see extra columns is if you picked the wrong database or table.

Posting Permissions

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