I have determined that SSIS package is not an option at this time, and my shared-hosting provider prevents BULK INSERT as an option. Now I am looking at connecting to my SQL database through ODBC and using SQL Pass-thru commands such as SQLEXEC() with INSERT commands to add the records to my staging tables on the remote server from my local tables on my workstation. Hi, Elgin,
If you don't mind the question, why isn't SSIS an option?
If it can't be used, OK, but this is one of the many scenarios where SSIS excels.