Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

mssql data migration

Keerthana_Adamana
6 - Meteoroid

Hi, 

I tried to connect the alteryx to MsSQL using ODBC driver 17. theres an error saying 

Error: Output Data (31): Error creating table "KEERTHANAA\SQLEXPRESS||[alteryx].[dbo].parsingTable": [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '\'.
CREATE TABLE KEERTHANAA\SQLEXPRESS||[alteryx].[dbo].parsingTable ("Name_Prefix" varchar(max),"First_Name" varchar(max),"Last_Name" varchar(max),"Email" varchar(max),"Phone" varchar(max),"Street_Address" varchar(max),"City" varchar(max),"State" varchar(max),"Zip" varchar(max))

 

Please help me

 

 

0 REPLIES 0
Labels