Need to get particular date date from PROD to Dev tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Need to get particular date date from PROD to...

Need to get particular date date from PROD to Dev tables

Rate Topic

Display Mode

Topic Options

Author

Message

komal145

Posted Monday, October 15, 2012 3:02 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 1:38 PM
Points: 168, Visits: 540

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

Post #1372955

Sean Lange

Posted Monday, October 15, 2012 4:10 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 7:02 AM
Points: 8,606, Visits: 8,248

komal145 (10/15/2012)

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1372981

sqlusers

Posted Tuesday, October 16, 2012 12:35 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 1:34 AM
Points: 196, Visits: 464

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.

Post #1373051

« Prev Topic | Next Topic »

Permissions