<div>
Might not be a bad idea for you to spell out exactly what you are asking us. &nbsp;One so that we know exactly what you're asking us to do, and two so this question does not turn into a Google Monkey contest of other experts searching Google for 'surrogate key pipeline' and posting the first thing they find without adding any extra helpful content.
</div>


Might not be a bad idea for you to spell out exactly what you are asking us.  One so that we know exactly what you're asking us to do, and two so this question does not turn into a Google Monkey contest of other experts searching Google for 'surrogate key pipeline' and posting the first thing they find without adding any extra helpful content.

<div>
Hi Morpheus7,<br />
Could you please explain your requirement in detail? We can provide you more specific details about the solution.<br />
<br />
Regards,<br />
Pawan
</div>


Hi Morpheus7,
Could you please explain your requirement in detail? We can provide you more specific details about the solution.

Regards,
Pawan

<div>
Hi,<br />
Many thanks for the replies.<br />
<br />
I need to be able to allocate surrogate keys for each dimension table and then be able to set up an incremental load to feed in to the warehouse. Currently there are 15 dimension tables. I would like to be able to include this process in the initial load and then into the incremental loads. &nbsp;I am using a staging db to bring all the data into first.<br />
<br />
Thanks
</div>


Hi,
Many thanks for the replies.

I need to be able to allocate surrogate keys for each dimension table and then be able to set up an incremental load to feed in to the warehouse. Currently there are 15 dimension tables. I would like to be able to include this process in the initial load and then into the incremental loads.  I am using a staging db to bring all the data into first.

Thanks

<div>
No, not yet.<br />
Still trying to work out how to create the keys for the initial load.
</div>


No, not yet.
Still trying to work out how to create the keys for the initial load.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Could anyone point me in the direction of a good article that explains generating a surrogate key pipeline in ssis. Including the initial load.<br />
<br />
Many thanks
</div>
</div>


Hi,

Could anyone point me in the direction of a good article that explains generating a surrogate key pipeline in ssis. Including the initial load.

Many thanks

Creating an SSIS surrogate key pipeline

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.