Hi David,

I've included the .dtsx file inside a .zip attachment. The SSIS package includes a single connection manager that points to localhost, and a database named "DataWarehouse". I...

Hello,

BKColumnList is a comma separated list of the fields that make up the business key or natural key of your dimension. The sample uses a single field (Product_Nbr) as...

A good option is to use DTUTIL. Since you are copying from SQL, I think it will be tricky to create a batch file to do this, so you...

I have implemented something similar using a script component that calls a stored procedure. The stored procedure inserts a record and returns the new identity value, which can then...

Anil,

Welcome to SSIS! This article admittedly covers a more advanced topic and is not geared for SSIS beginners. Here is some reference material you may find helpful. ...

That's a good catch. The SourceName field does not exist in this solution and it should not be included in the screenshot (Figure 14).

It can be beneficial to record...