Goodness, this one's gone on, hasn't it? And now I'm in it cuz of the row-size QOTD that had a naive age calculation thrown in.

Anyway, before...

The calculated age question was QOTD at the start of March.

http://www.sqlservercentral.com/Forums/Topic464861-1181-1.aspx

Interestting that it's come back to life..........

First, you probably want to avoid Active-X scripts in favor of the Script task (if you really need a script). Active-X is in SSIS as a compatibilityfeature for easing...

I'd be leery of doing a CONVERT on each row to compare to a string; it seems that would add unnecessary processing overhead to the query. So how is...

Although the "Between" approach may appear to work, I'd advise making sure it doesn't pick up any records for the next day. Remember that "Between" is inclusive, so theoretically...

Stuart, I'm not sure where your problem is, but had no trouble using the @@rowcount. I set up my Exec SQL task with direct input and followed the...

Although setting up a foreach loop with a WMI event watcher works algorithmically, there's an "issue" with SSIS not releasing memory at the end of the loop. Jamie Thompson ...

Cool script. I did have to make a correction/addition to avoid trying to string together a NULL in the middle of the schedule description. The case statement that would...

I'm with the "give a hint, not the answer" group, here.

I would have thought that if he had hit the "help" menu and asked for "Date", that he...

I'm no expert, but can suggest a couple of possibilities. If you're running the package locally but accessing a remote db, or simply returning a large result, your wide-area...

You may want to look at Jamie Thomson's blog entry on loading related tables at http://blogs.conchango.com/jamiethomson/archive/2006/02/17/SSIS_3A00_-How-to-load-related-tables.aspx .

You may have to register to access this site. He offers...

Wish I'd seen this (or asked myself) before buying the "Step by Step" book. I made the mistake of thinking that since it was published by the same...