?
Solved

GetDate Expression in SSIS

Posted on 2012-09-14
3
Medium Priority
?
518 Views
Last Modified: 2012-09-19
I need help in creating an expression in SSIS that enables the package to insert yesterdays date when it is executed today.
0
Comment
Question by:olongus
  • 2
3 Comments
 

Accepted Solution

by:
olongus earned 0 total points
ID: 38399807
I just figured it out playing with the getdate function, thanks any way!!!


DATEADD("day", -1, GETDATE())
0
 
LVL 12

Expert Comment

by:Jared_S
ID: 38399810
dateadd(d,-1,getdate())
0
 

Author Closing Comment

by:olongus
ID: 38412911
This solution worked perfectly for me....
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
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.
Suggested Courses

621 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