Wow. That is some good insight. Thanks.

The data that i am dealing with is >500 Million rows for one table (source split as multiple files) x 20 tables. Which is why i was trying to avoid...

I will try that out today at my client visit. I was not aware of this runas capability. Thanks Brian.

Thanks everyone for the help.

Sean Lange (9/23/2011)

---

Well then if they are (foolishly imho) dead set on keeping it over normalized then you have to keep the PersonAddressTypeHowManyJoinsToKeepOutOneOrTwoRedundantPiecesOfDataDoesItTake type of structure. Do they do the...

So, with my proposal of just a Person (PersonId) - Address (PK: AddressId, FK: PersonId), does anyone see any cons with this approach ? Other than the visual redundancy.

Sean Lange (9/23/2011)

---

I personally like the approach a Person table and an Address table. The Address table would contain the foreign key to Person and an AddressType field to let...

I think there is something wrong with the way the connection string is initialized and used.

You may need to either specify the full connection string or use something like this:

DirectCast(Connections.AuthenCustomer.AcquireConnection(Nothing),...

Not sure if this helps, but in c# the way to get a string value from a reader is

myReader.GetValue(0).ToString();

and the SSIS script you have is in VB, so .....

Don't you need to convert the integer count to a string ? myRdr.Item(0).ToString() ??

Change the AlwaysUseDefaultCodePage to True in your source component properties of the data flow task.

There is one for unit testing of SSIS packages - SSISUnit (like nUnit or MBUnit). You can set up a test server and configure the environment and run the tests...

If you dont log to the log file, are you able to echo the output to the command prompt ?

Sorry dupe post.

I was trying perform a differential load from a DB2 to SQL Server. The DB2 tables have absolutely no way (no PK, no timestamp) of identifying uniquely a row. So...