Reputation
386
Next privilege 500 Rep.
Access review queues
Badges
1 10
Newest
 Informed
Impact
~35k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
Apr
15
awarded  Informed
Apr
8
awarded  Popular Question
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