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
Solved

set the data flow task to run only on month basis

Posted on 2011-03-17
4
234 Views
Last Modified: 2012-05-11

I have the data flow task which will use to insert data into small db, If I plan to have multiple data flow task, for each month which will insert into different db, can we set a a DFT to run only during that month ?
0
Comment
Question by:motioneye
  • 2
4 Comments
 
LVL 17

Expert Comment

by:Barry Cunney
ID: 35164751
Is your dataflow task doing the same thing each month, the only thing that differs month to month is that it put's the data into a different database?
0
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 total points
ID: 35171861
use a condition for the DFT and and check the previos run agenst the current day,
0
 

Assisted Solution

by:motioneye
motioneye earned 0 total points
ID: 35207563
Hi ashilo,
How do I use condition in DFT ? any technical explanation for doing that ?

Hi BCUNNEY,
Yes I already have monthly db for monthly data, But I do not want to create many packages to store 36 month of data. I hope ssis will able to handle this within a single package but with multiple data source
0
 

Author Closing Comment

by:motioneye
ID: 35422612
solution not complete
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

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

809 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