mssql data migration
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Keerthana_Adamana
6 - Meteoroid
‎05-26-2024
07:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Database Connection
0 REPLIES 0
