Nice article!

But I hope it will become obsolete with Denali, when they have changed the way annotations work 🙂

I have absolutely no experience with DB2, so I have no idea.

It should be possible I guess.

It ain't that hard to do the conversion in SSIS. Add a data conversion...

Nice question, but only 1 point?

Transactions and the NULL insert in the primary key have actually nothing to do with the actual question, they just serve as trickery in my...

You could also do it in the script task, using DirectoryInfo and FileInfo (VB.NET). With DirectoryInfo you can use wildcards when you search for files, so that should solve your...

Here is a small tutorial:

http://www.bimonkey.com/2009/09/the-import-column-transformation/

Read it through and see if you missed something 🙂

What are you trying to achieve?

Some package is deployed to a server (SQL Server I guess, hopefully with Integration Services installed).

And you just want a find a way to start...

How did you create the package configurations?

How did you change the environment?

What do you mean with: I saved the name and the password?

What are the errors that you get?

And no,...

If possible, load the data into a staging table accepting the data from DB2. Then, do the conversion in your database.

Couldn't agree more. But thanks for the effort anyway.

Craig Farrell (12/16/2010)

The correct answer, then, is: "I don't know,...

Well, I did learn from this question, so mission accomplished!

And one...

Congratulations!

I passed the exam today. 😀

Nice question and an important point, but I have executed the code a 100 times or more and I always get the error.

Statistically I'm allowed to say that the correct...

Oh allright, it is for an interview. Why didn't you mention this in the beginning?

Your answer should definately be:

first yellow boxes. If you're lucky, green boxes. If not, red boxes....

You...