Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SSMA upsizing error

3 views
Skip to first unread message

Rik

unread,
Dec 26, 2009, 11:37:02 AM12/26/09
to
Hello,
I am trying to upsize a table from Access 2003 (.mdb) to SQL Server Express
2008 with SQL Server Migration Assistant 2008.

It works fine except for the migration of the data.
So the table i need is created correctly by SSMA in SQL Server but
i cannot get the data in it.

The SSMA log file says for every record:
Datamigrator: Error] [2392/8] [2009-12-26 15:00:51]: Inner Exception #1:
Incorrect syntax near '.'.
site: Void OnError(System.Data.SqlClient.SqlException, Boolean)
source: .Net SqlClient Data Provider
error code: -2146232060
data: [HelpLink.ProdName] = [Microsoft SQL Server]
data: [HelpLink.ProdVer] = [10.00.1600]
data: [HelpLink.EvtSrc] = [MSSQLServer]
data: [HelpLink.EvtID] = [102]
data: [HelpLink.BaseHelpUrl] = [http://go.microsoft.com/fwlink]
data: [HelpLink.LinkId] = [20476]
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlBulkCopy.CreateAndExecuteInitialQuery()
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()


Any help is greatly appreceated!!

Rik de Jong


Sylvain Lafontaine

unread,
Jan 1, 2010, 6:39:56 PM1/1/10
to
I would say that this could happens if you have something strange in the
table's or the column's names like a dot or a slash; kind of: [fist.name] or
[date 2009/01/01].

Otherwise, you have to insert or import/export the data yourself instead of
using this tool.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"Rik" <R...@discussions.microsoft.com> wrote in message
news:2A627724-FC57-440F...@microsoft.com...

Rik

unread,
Jan 3, 2010, 1:17:01 PM1/3/10
to

I also have installed SQL Server Express 2005 on a second harddisk now on the
same PC.
It works OK now. I think it is an installation failure of the 2008 version.

Thank you.

"Sylvain Lafontaine" wrote:

> .
>

0 new messages