In our DW we have contracts and they benefit across 1 to many jurisdictions.
Contracts can be serviced by many contractors.  So our Contractor tables are
set up using the bridge table to support many to many.
However; I'm tempted to think that most 1 to many dimensions should also ...

I am transfering Data from 1 database to another, how can I tell my
SSIS Package to only copy the data that is newly inserted or has
changed
Thanks

i've read the kimball books and i've created my staging tables and
star schema (dimensions and facts).  Now i need advice on my ETL (I am
using SQL Server 2005 Standard Edition).
For extract, I plan on pulling in csv files via FTP into my warehouse

Database is SQL 2005 and Front End is in C#
----------------------------------------------------
I'm looking for a good strategy to save my data that I use for testing. I
made a set of good test data, and backed it up.  I write my programs,

I have an access database that I want to put into a sql server
database.  When I pull up the upsizing wizard, select 'Create New
Database', select 'Next', use '(local)' for the server, select 'Use
Trusted Connection', and select 'Next', I get the following message.

Our data warehouse is expanding to pull in from about 10 different data
sources.  These are 10 different sub-systems in our agency - that track
contracts, grants and loans.
We are finding that there seems to be useful data in many of the sub-systems

I'm using SQL Server 2005 SP3 Dev. Edition
I understand how to create a scope (like this from BOL)
Scope
(

Hi Newsgroup
I am having difficulty working out the best method of bringing my BI
solution into production.  I have created the AS project, associated SSIS
and SSRS projects and am quite happy with the results.  However, I need

Our currenet archetecture is we have a
- PreStaging area (this is copies of the tables we are going to use - our
ODS)
- Staging (this is the results of the ETL - star schema) we have our