For around 10 years now, until starting at my most recent company, I have been paid on a 'day rate', but its also specified how long a 'day' is. ...

That would be me. I have...

Obviously, this article hit a real sensitive spot with me and rather than rant for an hour about the real underlying problem that it addresses, I'll just say that the...

But wouldn't they be using sp_executesql if they're using polished dog-turds dynamically generated sql?

Its not DB2, its Oracle.

I am having some progress by moving to 2008R2 and using the Attunity oracle connector, but its still not 100% working.

I'll give that a try but my instinct tells me that is not the issue - it seems to 'read' the first 9000-ish rows quickly, then takes an inordinate length...

+ 1

I've tried an OLEDB connection into Oracle, and also an ado.net connection to Oracle. The OLEDB connection crashes the table browser in the dataflow destination when I click...

Jon - your message popped up on my screen this morning, and I cannot remember what the issue was, or how I fixed it unfortunately.

I know this is old, but I never thought I'd use SQL 2000 again....until today 🙁 :crying:

select j.[name]

, case freq_type when 1 then 'Once'

when 4 then 'Daily'

when 8 then 'Weekly'

when...

Homework completed

Hmmm - after doing a bit of searching around the winzip website myself, I've come to the conclusion that there is no commmand line interface for WinZip these days.

However, the...

Have you tried googling the command line parameters? (command line parameters winzip) in google gives this (winzip) as the second result. Without knowing what version of winzip...

Or - you could set the task property "DisableEventHandlers" to true (defaults to false)

Eliot - to get the runtime value, you have to lock the variable for reading (by name), then you can get the value through the variable dispenser (as per the...

I think the system.collections.generic is needed, although Ihaven't tried it without yet - obviously I tried a lot of different ways...