jwcolby
jwcolby at colbyconsulting.com
Fri Nov 30 13:21:32 CST 2007
The problem is that they are fine (as are spaces) in file names... I am doing a "copy file to temp table, copy temp to permanent". Thus the temp table name is just the file name. I discussed awhile back that I got an "in" or something similar as a file name, which collided with a reserve word. kind of the same issue only different. What a PITA. Keeps me searching for answers long after this thing should just work. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Friday, November 30, 2007 2:11 PM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] Weird table name restriction Yep, dashes are as bad as spaces. ;-} Charlotte Foust -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, November 30, 2007 11:04 AM To: dba-sqlserver at databaseadvisors.com; dba-vb at databaseadvisors.com Subject: [dba-VB] Weird table name restriction I just discovered that SQL Server (or VB.Net) does not like dashes in table names. If I use a table name "ZIP4-AA_X", the BulkCopy.WriteToServer throws an error "can't access destination table" but if I remove the dash "ZIP4AA_X" it works just fine. The problem is that I take the name of the datafile, strip off the extension and use that as my table name. Thus I now have to start doing edits of the file name before I can use it as a field name. The hoops we have to jump through... John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com