You can also start a Profiler trace to get more information with events on that view object. There are a couple of event categories that may be worthwhile to look...

Quick correction to my prior post. Use the '?' as the place holder when using direct input. But you can still give the parameter a friendly name in the Parameter...

In addition, you can use the long data type in case you experience any issues there. Also you can give your variable inside the task a more friendly name

INSERT INTO...

An advantage of a for each loop is being able to count how many files you imported from with a script task in the same loop. I didn't see that...

Hi - Maybe I misunderstood but I read you need all five variables set to 1 before the next task in question should execute. In your code I see all...

In regard to operators, just quickly concerning negating operations, ie... someColumn <> 'string' ,

don't forget that rows with a null in that column will not be returned. I just use...

If you want to transfer data from server 1 to server 2, you can create a linked server connection object on server 2 that point back to 1. From there...

The above post makes a good suggestion. The alternative would be to do something like

If @parameter = 'column1'

select column2, .., column N

from ...

else if @parameter ='column2'

select column1, column3, ....,...

Exexute Process task,

you state the likes of the working directory and type a command as you would in a CMD window. The command is specific to the app you...

Also if you haven't done so, try having the reports call a stored procedure and pass paramaters as opposed to building the query in the report. THis reduces network traffic...

So to put it plainly you are merely joining the table to itself where the from date of a given row is between the from and start date of another...

It appear you have your string inlcude the EXEC portion already. When you run EXEC (@osql) it seems to come down to

Exec Exec XP_CMDshell .....

ELiminating this may not not...

Just to cover the basics, is the table on a remote machine? Can you query other tables? I am just wondering if the issue is not an errant windows process...

I've seen this myself. There seems to be no pattern to the occurences. I wonder if it gets fixed with the application of the latest service pack.

Try tuning you indexes, NOLOCK is guaranteed to read uncommitted transactions but not necessarily guaranteed to improve performance.