You probabably will also need a TSNAMES.ORA file on your workstation with the appropriate Oracle connection strings.

Have you turned on package logging (Click SSIS...Package Logging in Visual Studio) for that pacakge? I prefer to log to a SQL table rather than a file. You...

Wow! And I thought I'd be the first one to complain.

Default means "default"!

Take if from someone who's been engaged in doing exactly what you are talking about...re-write your packages in SSIS if you can. You'll get a lot of bang for...

Assuming the tables are already related with foreign keys, you can create a new diagram in SQL Management Studio and simply add all of the tables in the database. ...

Documentation is superfluous. The code is obvious.

😉

I love this topic...you don't get to do bitwise operations all that often.

I did this with the bitwise AND operator ("&") and a bitmask to find the values of the...

Plan on just redeveloping your cubes in SSAS 2005.  There is not a straightforward migration path.

Also, if you're using DTS for ETL, plan on redeveloping that in SSIS as well. ...

I think this has been a problem in every IT shop since the earth cooled.  If it weren't for the darn coders (and users), our servers would run like tops...

Hugo,

I'm with you.  I also picked "B" although I was dubious of it because of the word "always" in the question but I was unaware of the restriction you described...

So you want the smallest MIN(Col2) where Col1 = MIN(Col1) right?

Why not

SELECT Col1, MIN(Col2)

  FROM Table

WHERE Col1 = (SELECT MIN(Col1) FROM Table)

GROUP BY Col1

I especially like the salt-shaker question...I have used "How do you test a toaster?" myself.

If there are any old mainframers out there...they'll appreciate this one...

There is an error code on...

My practice (best or not) is to replace lengthy text keys like the one you describe with a system assigned key...either a four or eight byte integer or a GUID...

That's a great question because that kind of data is so common.  Unfortunately, there's not a built-in transform to handle it (but there should be).  You could code a custom...

Try this on for size...

select

dateadd(d, -1, dateadd(m