Database upload suddenly taking hours instead of minutes, any ideas why?

[Philip]

I'm attempting to drop and replace a table on our SQL Server database. I've done this before, but today it's taking hours instead of its normal 5-10 minutes. The data set is about 2GB in size. I'm receiving these errors, which I've never seen before. The only difference is I've changed a field data type from V_WString to a 64 character String.

Output Data (2)    File Format does not match translated type.
Output Data (2)    Alias translated to odbc:DRIVER={SQL Server Native Client 11.0};DATABASE=TheDB;SERVER=OurServer;Trusted_Connection=yes|||TableName
Output Data (2)    ODBC Driver version: 03.80

Any ideas why I'm receiving these errors and/or why it's suddenly taking so much longer to upload? Are they related?

[Philip]

I'm using the SQL Server Bulk Loader. Is that what you're referring to? I believe I followed this video on how to do it.

https://www.alteryx.com/resources/writing-data-to-a-sql-server-with-alteryx-analytics

[jorgerocha_10]

Thanks for sharing this Philip! This video helped me decrease my workflow runtime from 4 hours to 4 minutes!!

[hegdes]

Hey Philip,
I am not able to find that video, it's showing page not found.
Can you please help me out with using bulk loader in the workflow.
Thank you in advance!

[AmitMiller]

@hegdes , just found it on Alteryx's Youtube channel:

https://www.youtube.com/watch?v=r_0YzuL_ZAE