When you opened the package (added the package in the Solution) did you get any errors about it? and one more question do you see other components of the control...

What is the Size of the DB and space available? the reason for the question is, in case you need to add new Data into the database, then you should...

Strongly support Gsquared on his view, anyone with such serious Security breaches has to be immediately shown the door, no mercy if you spare a guy this time, next time...

You should be looking the history of the Job where it is scheduled.

Let me explain, the SSIS Package can be scheduled to run on MachineC which is neither...

Yeah, I have been following some of the blogs about the Summit from others like Brad McGehee.

I am going to meet all of you guys next year, I am planning...

Thanks Steve for posting the happenings at the Summit 2009. It was good to know that the Party that you hosted was successful and entertaining.

I was planning to attend...

Just to make it clear, it's not Transactional Replication with immediate updates, it is Transactional Replication with updatable Subscription.

I came back and somemore script for Update and Delete Triggers is added by Lowell, that should suit you.

But as he said, a View is going to be the best...

So you mean,when some one updates the Customer Table column RepNum from 65 to 20 again it should update the counts in the Rep table and also like wise, if...

Giving Full Credits to Lowell, the script he has mentioned is enough with a small change of REPNUM (3 Times in his Code)

From my understanding the Server / SQL Instance must have restarted and that is the reason for the lower value of Page Life Expectancy

Hi,

I may sound too harsh but please go ahead and reply with your table structure (Create Table script )of both the tables first and also insert script into the 2...

Page Life Expectancy is a Counter in Seconds, in your case it is 6 Seconds.

Having such a lower value as indicated by you is a clear indication of Memory Problem...

The command line indside the job step keep reverting to it's original state even after I change it to include a /DECRYPT phrase. It's the second screenshot. Any ideas as...

That's True John, I agree