Solved

SSRS 2008 - Transferring New Data Only within my Package

Posted on 2011-02-24
1
210 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

821 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