?
Solved

SSRS 2008 - Transferring New Data Only within my Package

Posted on 2011-02-24
1
Medium Priority
?
217 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
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 …
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

764 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