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.
I am running an older 2020.3 version, and have noticed that when writing with 'Data Stream In' via ODBC that header fields need to be quoted out in order to avoid an error of "Incorrect syntax near 'varchar/char/whatever data type'..." showing up regardless if 'Quoted' or 'None' being setup in the tool.
Utilizing ssvb in the initial setup (we are utilizing Integrated Windows Authentication), only the connection type and created BULK_PKD I setup in User in the ODBC Admin interface are created for the connection string.
When going onto the 'Write' tab, I just indicated 'Same as Read Driver' as indicated below, and upped the transaction size.
Using "Quoted" or "None" here did not impact being able to create, drop, append, etc.