The way we have done this is to load the source data into a staging table in a staging database.

Perform validation on the source data

Lookup surrogate keys and apply them...

If you are running DTS interactively, it will run under your credentials.

If you run it from SQL Server Agent, it will run under whatever account runs the SQL Server...

What options do you have set for Security?

Be Made Without Using a Security Context is the default, so if you did not change it, this may be the cause...

We have been using VSS to hold the SSIS packages and we backup VSS every x minutes. This works very well.

If you use SQL Management Studio, go to the help...

I know I was surprised when we started doing some prelimiary testing with the June CTP. With .NET compiling to the same IL language, it really makes no sense to...

This is a new process, new file, from a client generated from a mainframe. I viewed the file in a hex editor (Ultra Edit) and did not see any high...

I guess it is more a friendly critique of the format of the question. It was a little rough to read through, and having psuedo code would have helped me...

Even though I answered correctly, it would have been nice to have had some psuedo code to help out. I had to read through the question a couple of times...

I got it wrong thinking it was a trick question. Seeing no option given to restore to 11:55 pm I chose "All of the options are false: It is...

That makes no logical sense at all. I'll sign the pink paper if you want. =)

The minimum character size is 2 characters, however, if those two characters are a reserved word (such as "to" or "as"), as found in the noise.enu file, it will give...

I agree, the dynamic properties task is great for parameterizing a package.

A secondary option would be to use the ActiveX Script task to set properties.

Here is an example...

Can you rephrase your question. I am not sure what you are asking.

I didn't say passing the results of a cursor to another stored procedure was a GOOD idea

If the PDAs already have a .NET Client, why not extend the PDA app to call the webservice? Then you are still using the company framework to accomplish your goal....