Either copy the file to a location on the server, or create a share on the computer where the package is stored, and put that in your job step.  The...

Yes, but is it a physical drive on the same computer that the job runs on, or is it a drive on the computer on which you're developing or storing...

Sindhu

Is H a physical drive on the computer on which the job runs, or is it a mapped network drive, or is it a drive on another computer? ...

I too am not sure what you're trying to do.  How are you attempting to do the insert and what error message do you get?  You could try creating two...

Edward

That depends on your indexing.  A log table is the perfect candidate to have its clustered index on the Date column.  If that's what you have then

Edward

Yes, you can delete in batches.  Just delete TOP 10000 (or the number of your choice) over and over until there are no more rows that you want...

Edward

With 18 million rows, and not narrow ones at that, you'd have to expect it to take a long time.  You could try creating a new table and...

Does the outorder table have a primary key or unique constraint on the outorder column?  If not, there could be duplicates in that table and that would be why you're...

SELECT TOP 25 PERCENT x.ColList
FROM (
   SELECT TOP 2 PERCENT t.ColList
    FROM MyTable t
    ) x
    

John

You could select TOP 50 PERCENT FROM TOP 1 PERCENT (or any other two numbers that multiply to 0.005).

John

I don't know, but I know where you can find a lot of ids!

John

SQL Server Reporting Services (SSRS) will do this for you.  Other similar products are available. Even Excel could do it, although I don't necessarily recommend using that. 

John

SELECT TOP 1 PERCENT h.SKU
...

John

Did you try running that?  It won't work, because you don't have a GROUP BY.  You shouldn't need the self-join, either.

SELECT name, sponsor, MIN(Date_of_call)
FROM MyTable