Solved

SSRS 2008 - Transferring New Data Only within my Package

Posted on 2011-02-24
1
208 Views
Last Modified: 2012-06-27
Hi,

I am creating an SSRS package to copy data from 1 source DB to a target DB on a daily basis.

Data is loaded into the source DB on a daily basis via an ETL tool. I then need to subsequently transfer that 'new daily data' only to the target database.

Q. How do I ONLY select the new 'daily' data within my SSRS package, so that duplicate data is not transferred also.

Note, the package contains 30-40 tables, and each of the tables have a TimeStamp field.

Thank you.

Iain
0
Comment
Question by:mullykid
1 Comment
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 34971171
I believe you are talking about SSIS packages and if that is true then you should use a source query instead of the each 30/40 tables as input and filter source data by the timestamp column.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now