One Off SQL Sync

Welcome to the Community, @Zacs. Thanks for joining us! 🙂

It sounds like you’re wanting to do a bulk transfer of data from SQL Server to Zendesk, am I right?

If so, you could try using our Transfer feature to do a bulk import of the data from the SQL table into Zendesk. The SQL Server app is on the list of supported source apps for transfer so it should work: Which apps does Transfer support?

You can find out more about how to use Transfer here: 

• Bulk import data into apps with Transfer
• Transfer by Zapier: An easier way to move data in bulk

Hope that helps. Keen to make sure you’re all set here so please keep us updated on how you get on!

I am trying to set a transfer up. When it asks for my SQL query it input the below:

SELECT TOP (5000) [Customer No]
      ,[Customer Name]
      ,[Full Address]
      ,[Phone No_]
      ,[Shipping Agent Code]
      ,[Shipping Agent Service Code 2]
      ,[Service Code]
      ,[Channel 1 Code]
      ,[Channel 2 Code]
      ,[Salesperson Code]
      ,[Name]
      ,[Customer Alert]
      ,[E-Mail]
      ,[Domain]
FROM [dbo].[zendesk_customer_data]

I get this error:

Error during execution: (pyodbc.ProgrammingError) ('42S22', "[42S22] [FreeTDS][SQL Server]Invalid column name 'id'. (207) (SQLExecDirectW)") [SQL: SELECT TOP (100) "Customer No", "Customer Name", "Full Address", "Phone No_", "Shipping Agent Code", "Shipping Agent Service Code 2", "Service Code", "Channel 1 Code", "Channel 2 Code", "Salesperson Code", Name, "Customer Alert", "E-Mail", Domain FROM dbo.zendesk_customer_data ORDER BY dbo.zendesk_customer_data.id ASC] (Background on this error at: https://sqlalche.me/e/14/f405)

Any help would be appreciated

Hi there @Zacs,

I noticed that you've already got a ticket open with one of our Support Specialists. That's great! I suggest you continue the conversation there, so they can take a closer look at the backend of the logs and get to the root of the error.

Thanks for your cooperation and understanding. 😊