Viewing 15 posts - 3,991 through 4,005 (of 5,685 total)
niall.baird (2/16/2011)
February 16, 2011 at 4:27 pm
Just a quick question, is this an ADP that connects to a SQL 2k5 backend, or an actual MS Access database? The error is SQL so I assume you're...
February 16, 2011 at 4:21 pm
Jole84 (2/16/2011)
Andreas Goldman (2/16/2011)
WHERE [DATE] >= DATEADD(HOUR, - 1, GETDATE())
hm... this query gets all data from table. My last record was inserted 08/02/2011 11:44:56 PM so
it must return zero rows...
February 16, 2011 at 4:16 pm
Well, yes and no.
First in the script task you have to expose the variables to the script task in the Script Task editor window, at the least as ReadOnlyVariables.
If you...
February 16, 2011 at 4:12 pm
Well, it's the long way around the barn these days, but it's not that uncommon in SQL 2k and back. However, you always start with the inside moving out....
February 16, 2011 at 11:22 am
Most likely they were stale when you did the backup. To avoid things like this, do your reindexing/statistic updating before you do your backups.
February 16, 2011 at 11:16 am
Mine tends to be whatever mood strikes me at the time, or can be triggered by a conversations.
I believe this one was from a recent conversation where it was agreed...
February 16, 2011 at 11:11 am
Yep, different errors. These are easier to deal with:
OnError CRM CRM\Administrator Package {32833F60-011C-44C1-AE01-DE591DC521B8} {0A292E65-3966-4E42-810E-AF6857A821DC} SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB...
February 16, 2011 at 11:05 am
thepotplants (2/15/2011)
I haven't heard of tally tables, so I'll have a look. Thanks for the suggestion.
No problem. You'll find the Tally and/or Calendar table much quicker than any while...
February 15, 2011 at 11:44 pm
Triality (2/15/2011)
February 15, 2011 at 11:38 pm
You got your code in my THREAD! ARGGGHHH... We need to take this outside!
I believe, if memory serves, there was an algorithm for using XML instead of the...
February 15, 2011 at 11:30 pm
The three standard ways to handle this with T-SQL would be the following:
- While Loop (slowest but most common)
- Calendar Table (requires upkeep)
- Tally Table ( requires understanding of using...
February 15, 2011 at 8:24 pm
dlatch (2/15/2011)
It was actually an SSIS package that I had written. Doing a lookup against the key and column splits on the critical tested fields. ...
February 15, 2011 at 6:57 pm
Triality (2/15/2011)
Ah thats exactly what I was looking for, makes complete sense! Thanks Craig!
My pleasure. I've been crash coursing in more advanced SSIS for the last two months...
February 15, 2011 at 5:29 pm
LutzM (2/15/2011)
Therefore, it's sometimes referenced as T(c) which is Table(column).
The one column itself holds...
February 15, 2011 at 5:25 pm
Viewing 15 posts - 3,991 through 4,005 (of 5,685 total)