Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2007-04-11 : 19:30:14
|
| Hello All,I want to pass two date parameters to a stored procedure within my DTS package. Below are the specifications:1. I want to create logic in my DTS package to determine if a specified date value falls between a particular weeks in a month, then assign a date for Monday and Friday. Ex. IF a date falls on the second week in the month, then assign 04/09/2007for Monday and 04/13/2007 for Friday. IF a date falls on the third week in the month, then assign 04/10/2007for Monday and 04/20/2007 for Friday.IF a date falls on the fourth week in the month, then assign 04/23/2007for Monday and 04/27/2007 for Friday.and so on…2. Once the dates values are assigned then pass it to a Stored Procedure.Can someone please give me some guidance on accomplishing this task? Help or advice would be greatly appreciated. Thanks. |
|
|
|
|
|
logic to pass two date parameters into SP from DTS