There's a setting for it, but if I set it, it wasn't on purpose 🙂

I just figured it out. I have a lot of older data that doesn't have...

Hey Ron,

I have his lifecycle book, so I ordered the one you suggested. (I had been meaning to get it anyway)

You had mentioned having a dimension for people that...

I actually have it and was going to begin reading it. Sounds like I definitely should 🙂

In this particular fact table, you're measuring the aging of data, and it's...

Our dashboard doesn't usually go into that level of detail, it'll usually summarize down to the entity level, and that's sufficient, but the detailed reports that go out on a...

That's what I'm thinking of. I'm wondering if all of this crap wouldn't be much easier if I just dropped it into a staging table and did some magic...

Okay, the other snag turns out to be because the expression is evaluating and passing nothing to the next step. I'm looking in the viewer and for that column...

hit another snag, but it's unrelated. that works, thanks so much.

Actually yea, that's what I'm testing for. All of the residents have (1234) format. Some of the summary records CAN, but don't have to. Do I need...

Thanks, found an article that pointed me at that. So now it's looking like this:

SUBSTRING(["client_name"],FINDSTRING(["client_name"],"(",1),FINDSTRING(["client_name"],"(",1) - FINDSTRING(["client_name"],"(",1))

if evaluates in the expression box, but when I try to debug it,...

Ergh!

1) created a variable to hold the whole command string:

"DECLARE @cmd VARCHAR(MAX);

set @cmd = '-SQL \"restore LOG [PCC-RRDB-CHG] FROM DISK = ''\\\\BI01\\PccLogFiles\\+ @[User::v_fileName] + ''' WITH STANDBY = ''G:\\PCCBackupDONOTREMOVE\\Undo_projects.dat'',PASSWORD...

Steve,

Yes, that's the plan. Right now, if the exec stmt fails and the task fails, that's good enough, but in truth, there are several error messages that could come...

Honestly, I think it might even be enough that if anything is returned, it's probably an error so we can have the job fail at that point.

unless anyone has another...

When I execute the procedure (which is now working thanks to James and SQLRUs), I get two rows back in my sql window. One is an exitcode, the other...

Right now I am just trying to execute it in a sql edit window. I plan on taking it and putting it into a SQL task in an SSIS...

gonna go grab some food 🙂 Thanks so much!