SQL2005 (SSIS) Statement fails

heynem

Hi everybody,

I need to import several date from a Navision 403 native Database to a SQL 2005 Server. For this I am using the "normal" ODBC driver.

But in the select statement I receive everytime an error when I use the fiels with space i.e. Name 2, Adresse 2.

I have tried to place these in [brackets] - but no success :?

Everytime I have this error:
TITEL: SQL Server-Import/Export-Assistent

---

Die Anweisung konnte nicht analysiert werden.

---

ZUSÄTZLICHE INFORMATIONEN:

ERROR [42000] [Simba][SimbaEngine ODBC Driver]select Nr_, Name 2<< ??? >> from kreditor
ERROR [42000] [Simba][SimbaEngine ODBC Driver]Syntax Error. (nodbc.dll)

---

SCHALTFLÄCHEN:

OK

---

Can somebody pls. help me on this..... ](*,)

Marije_Brummel

Are the fieldnames not in english? Name 2, Address 2?