It sounds like parameter sniffing. If you don't want to specify WITH RECOMPILE, you can also declare local variables and then reassign your input parameters to the local variables....

I'm not quite sure I understand your question, so this might not be the best answer. But, have you tried to use end points or set the port number...

Also, if you have variables they have to be defined with values or it will error and if you have temp tables they have to be real tables...at least in...

Are they really just counting on this huge select or did you add that for debugging or something?

Weird thought Software companies, how about instead of being first to market, try being the best on the market.... I used to work at a telecom company that was...

I don't think there is any issue with running different SQL Server instances on each node of the cluster. For example, at my company we have several clusters and...

The AC system always roaring over my head, but never working. It's either too hot or too cold.

Agree with everyone else, cell phones ringing and speaker phone and the...

If

Does your table have a clustered index? If not, the table won't defragment. You could only defrag the nonclustered indexes in this case.

Can you tell if the query is actually hitting the database? Is the table located in a SQL Server database, Oracle, etc? The reason I ask about the...

You can change your select in the source connection to pull the top 318 and if it completes then you know that record 319 is bad. You might also...

Do you have the database connection set up correctly? If so, are you sure you have access to execute the stored proc?

I think you can use a variable in the for loop that with get each file and then use that variable as an input parameter to the execute sql task...

can you create a proxy account for the job?

I think Phill answered my question.  Thank you.