I am trying to load QV data into SQL as a test without using VB and dont seem to have any luck. I am using the below script, and it is erroring out, can someone help?
OLEDBCONNECTTO[Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Clinicom_Temp;Data Source=LPTLoad01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=QVLPT01;Use Encryption for Data=False;Tag with column collation when possible=False];
Make sure to enable the option Open Database in Read and Write Mode on the Settings tab of the script editor. Otherwise the connection will be read-only. And of course the user you connect as needs insert priviliges in the target database.