Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Auto Renaming colum and DTS problem

Author  Topic 

donthedon
Starting Member

1 Post

Posted - 2006-06-20 : 12:40:20
Hi,

I have two colums with names ADDRESS and TYPE in my table. When I try to export data using DTS I get a Parse query in sql error! Because SQL server automatically renames the above mentioned colums using the [] brackets. If i rename the columns to ADDRESS1 and TYPE1 then DTS works fine!

Why this happens ? Can anyone suggest me a workaround; I actually cannot afford to rename the colums as another application is already using the table.
   

- Advertisement -