Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

set the data flow task to run only on month basis


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
motioneye
Asked:
motioneye
  • 2
2 Solutions
 
Barry CunneyCommented:
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
 
Aaron ShiloChief Database ArchitectCommented:
use a condition for the DFT and and check the previos run agenst the current day,
0
 
motioneyeAuthor Commented:
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
 
motioneyeAuthor Commented:
solution not complete
0
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

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now