Hi Vivian,

Did you manage to sort our the problem? I have to agree with Muthukumaran on the /3Gig switch, it's not something to play around with on a production server...

Thanks, I'll use that post for assistance.

Thanks I'll try out the included columns. Appreciate the advice.

Hi,

Your reporting requirements will determine how you configure your reporting database. Your question can't really be answered here as we don't have enough information on your requirements.

From a personal...

Thank you all for your input.

I'm getting a much better picture on how indexing works 😉 For the table I used in my original post it sounds like...

Thanks I got there. It seems someone bounced the server while the package was executing.... now just to find out who so I can kill them 😉

Is there some sort of log I can check to see if the SQL Server Agent was actually up and running at that time?

Thanks Gail, worked like a charm 😀

Ian, you are going to be so upset with me man!

I did do the rowcount inserts. I rolled out the change to the production environment. After the package had...

Unfortunately not. I checked both servers and the connection settings are exactly the same. All "Default Connection Options" unticked. I've also compared the remaining settings between the 2 servers and...

Okay, now I am officially stumped :blink: .

I copied the package to a different server. Created a new job and executed it. On this new server the results returned are...

Ok, I checked and the package and t-sql code is pointing to the correct environment. I think I'm going to declare a variable in the stored procedure and assign rowcounts...

Thanks for your view Ian. How would I be able to use the @@rowcount in SSIS?

I changed the SSIS package to execute the t-sql as a stored procedure. This...

Thanks Jeff, I've learned something new today! 🙂

Hi BT

Did you get this one sorted? The only thing I can think of is that the DTEXEC command line syntax might be incorrect, could you post it here?