I didn't try to retrofit this into your query, but this example should show you one way to get the results you are looking for. Basically, this allows you...

So the data source is a text file? Is it using a flat file connection manager? If so, open up the connection manager and go to the Advanced...

This is yet another example of, 'it depends'. I wouldn't say to stay away completely as partitioning definately has it's place and advantages.

Here's[/url] a great article on...

From what you've described, your code should still return a 'Y'. See this example:

DECLARE @Table TABLE (Col1 varchar(10))

INSERT INTO @Table

SELECT 'CC' UNION ALL

SELECT 'CC' UNION ALL

SELECT NULL

SELECT MAX(CASE WHEN...

I would recommend any option that does not involve triggers. Triggers fire within the scope of the transaction so using a trigger to populate a table in another database...

Well, first you'll need to figure out which performance counter that you'd like to monitor. I'll leave that to you. There are a few perfmon counters that are...

I believe that there's a performance counter for replication latency, correct?

If so, create an alert for that Performance Counter Object and set it to file for > 2 min.

To create an OnError Event Handler:

1. On the Control Flow, set the focus on the task that you would like to create the event handler on.

2. With the task selected,...

Sounds good. I'm glad you've got it working.

What exactly are you trying to do? Are you getting an error, if so, what is it?

You say that the job

What task did it fail on? Since you have this inside a loop container, you...

So you want 1 day's worth of data beginning with yesterday >= 1:00 AM and up until today <= 12:59 PM?

This should do it:

DECLARE @Table TABLE (RowID int IDENTITY(1,1) NOT...

We went there about 5 years ago, back when we only had 2 kids, for a family vacation. We stayed in Rapid City and hit Rushmore, Reptile Gardens, Crazy...

It's in Keystone, SD. The nearest 'big' town is Rapid City, SD, which is about 1/2 hour away. I was born just outside of Rapid City, at Elsworth...

I figured so, but this thread is now so long I didn't want to go back and re-read them all.

I get to SF at least monthly (I'm in...