I’m having a problem executing a script…actually I think I’m having two.
I have an automation script where I select ID’s from an Access DB in order to create a series of insert statements and save them to a file. I then take that script and merge it to another script and execute the merged script in SQL Server. I am getting an error on the script even though I can manually open the script and execute it with no problems against my Sql Server DB. I think there’s an issue with TDA using ODBC as the connection type for the SQL Server connection, and ODBC does not support some of the T-SQL syntax like 'IF OBJECT_ID(‘tempdb…#BASE_POP’) IS NOT NULL BEGIN
DROP TABLE #BASE_POP
If I create a job by itself with only a SQL server connection in it…It doesn’t seem to like it when I create a temp table by using select * into #temp from t1.
Are these known issues?