• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 799
  • Last Modified:

Expired_Flag Field in SSIS

Please how do I get expired_flag to show either 0 for current or 1 for expired rows? I am migrating data from a table that has Position_Start_Date and Position_End_Date which I mapped to my new fields called Effective_Date and Expired_Date respectively in the destination table. I also do have a field on my destination table called Expired_Flag. I am having a hard time getting this field to either show 0 if the record is expired or 1 if not. How do I make use of the fields position_start_date and position_end_date to cause the expired_flag to respond accordingly?

Thanks for helping!
0
Lyn Udy
Asked:
Lyn Udy
  • 2
  • 2
1 Solution
 
vdr1620Commented:
you can load the Expired_flag field using SQL or Derived column in SSIS.. i am not sure if i understand your criteria correctly to determine if its a 0 or 1. It would be good if you can explain the formula here..

Are you planning on an incremental load or is it one time load or Daily load ??
0
 
Lyn UdyDonor Database AdministratorAuthor Commented:
It's a one time load.

And I'm also trying to use derived column in SSIS to get the value. I want the field to show a value of 1 if the position_end_date is a date in the past (expired) or 0 if it's a date in the future or current date (current)
0
 
vdr1620Commented:
Ok..That should be simple to do.. All you have to do is compare the date in that Column with getDate() function

you can use the below exp:

position_end_date <= GetDate() ? 1 : 0

Make sure that the Data Types Match..let me know if you need more help
0
 
Lyn UdyDonor Database AdministratorAuthor Commented:
Great!!! Thanks vdr1620
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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