?
Solved

SSRS 2008 - Transferring New Data Only within my Package

Posted on 2011-02-24
1
Medium Priority
?
225 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 40

Accepted Solution

by:
lcohan earned 2000 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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
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.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

589 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