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
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels