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 |
|
shakilhyd
Starting Member
16 Posts |
 Posted - 2008-07-06 : 09:55:42
|
| I run a report weekly on Monday. There is a spreadsheet in which I change the Startdate and enddate only. Suppose I am running report on Monday 07, 2008. I will put startdate as 06/30/2008 and Enddate will be 07/07/2008. After putting the date I run the executable file which is looking data from spreadsheet and I get the result in text format.I just want to automate the spreadsheet to avoid weekly input data of startdate and enddate. My question is how can I create DTS-package so that when I run the DTS-package, automatically change the startdate and enddate and run the executable file.Spreadsheet name is: WeeklyMSfile.xlsExecutable file name is : WeeklyMS.exeThanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-06 : 13:13:53
|
| Dup post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=106068 |
 |
|
|
|
|
|
DTS-Package