376 reputation
18
bio website
location
age
visits member for 3 years, 1 month
seen Oct 29 at 10:02

Oct
27
asked SSIS 2012 metadata not refreshing on re-deploy
Sep
1
awarded  Curious
May
14
comment How to find duration in a dataset
Hmmm. Maybe move the WHERE clause from the CTE to the SELECT.
May
14
revised How to find duration in a dataset
Added corrected logic
May
14
comment How to find duration in a dataset
Ahhh, good point. This looks like a job for Gaps and Islands. I'll update my answer.
May
14
answered How to find duration in a dataset
May
12
comment Creating an SSIS package that uses a stored procedure
Oh! Go to the properties for the Data Flow Task itself to set Delay Validation to true.
May
12
comment Creating an SSIS package that uses a stored procedure
Are you defining the temp table inline or with a SELECT INTO statement? If you're using SELECT INTO, try doing a CREATE/INSERT setup instead. The problem is that SSIS is trying to parse the table and since it can't find a schema it can't build metadata. @Kin's suggestion to delay validataion will work but only once you have metadata actually assigned the first time 'round, in design mode.
Jan
12
comment Getting each status change in a table
'Cause it's not just those columns; it's a metric ton of data per day, but this one column is all I care about for this crappy subquery. Martin saved my bacon!
Jan
12
accepted Getting each status change in a table
Jan
12
comment Getting each status change in a table
Perfect! And now I am more edumacated.
Jan
12
comment Getting each status change in a table
Sorry, power knocked out the office for about 10 hours. :P No, I need each date for each status change. So if it goes into status A 5 times, I need 5 dates. Be nice if it were just the first instance of A, but no such luck.
Jan
11
asked Getting each status change in a table
Nov
8
awarded  Tumbleweed
Nov
1
asked Error 7373 connecting to SSAS 2008 only from one machine
Jul
12
comment Sneaky rollback in SQL Server 2008 R2
Trace didn't show anything. I moved the t-log to a different drive and then added a new one and shrunk the current one down to nothing with no growth allowed so it essentially wouldn't be used. So far so good; unfortunately it's one of those 'have to define a positive with a negative' situations.
Jul
9
comment Sneaky rollback in SQL Server 2008 R2
SSIS workflow with no changes for months, and rollbacks that happen spontaneously: normally I'd be looking at SSIS too but it just doesn't compute. If a logic error exists for something that runs daily for months or years at a time, it would have shown up before now. I've gone through it and cannot find anything that would've been triggered these two random times. Hoping the t-log will shed some light but so far no dice.
Jul
9
awarded  Commentator
Jul
9
comment Sneaky rollback in SQL Server 2008 R2
Would t'were that it were so, but this is an automated system that only a select few have access to, and fewer have the ability to make changes to. And it happened again last night between 11 p.m. and 2:30 a.m. Is it possible that a corruption in the t-log would trigger a rollback of committed transactions? 'Cause these are committed, and they are rolling back.
Jul
8
comment Sneaky rollback in SQL Server 2008 R2
It's a set of nested SSIS pkgs and stored procs; each individual piece of the load has its own transaction wrapping it, with the exception of the bulk inserts. There are no nested transactions.