October 15, 2012 at 3:02 pm
Hi friends,
I Need to get particular date(eg: todays date) date from PROD to Dev tables.where the tables already exist in both enviornments with some data.
I created ( OLEDB source and destination ) , but need only todays data. How to do taht.
can any one help me with this plz!!!
Thanks,
Komal
October 15, 2012 at 4:10 pm
komal145 (10/15/2012)
Hi friends,I Need to get particular date(eg: todays date) date from PROD to Dev tables.where the tables already exist in both enviornments with some data.
I created ( OLEDB source and destination ) , but need only todays data. How to do taht.
can any one help me with this plz!!!
Thanks,
Komal
You didn't provide any details so I can't provide a detailed response.
You need to use date logic in your query. Where some field > somedate and some field <= somedate or something along those lines. If you don't have datetime columns in your table you are facing the impossible.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 16, 2012 at 12:35 am
One more way!
1. Get Today date from Script Task and store it in an variable.
Now.AddDays(0).Date.ToString("MM/dd/yyyy")
2. Pass that variable in your DB Source along with your condition.
SELECT <Column Name>
FROM TableName
WHERE .... =/> <Variable Name>
. Use your convert function to convert as per req.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy