This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've read various posts about sql server bulk loading setups but I'm still a little confused. Hope someone can help me out.
I'm not clear on 2 things;
1) What's the difference between the connection I created in Connection Manager on my server for type = "Microsoft Sql Server" that leverage "ODBC Driver 13 for Sql Server" vs a Sql Server Bulk connection?
2) How do I set up the DSN for a Sql Server Bulk connection? I need to do this so that the user will pass the name of the DSN and their credentials in the workflow to control user authentication (ex odbc: DSN=XXXX; UID=XXXX; PWD=XXXX
Thanks in advance for the help with this. I have a slow load to a sql server that I need to improve considerably.
So now I see.....thanks for pointing that out. I was thinking there was some special driver needed that I didn't have. Once i switched to the native driver for the setup, it worked perfectly- took a 14 min process down to 14 seconds....