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-05 : 07:47:30
|
| 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. |
|
|
shakilhyd
Starting Member
16 Posts |
Posted - 2008-07-05 : 07:55:59
|
| I run a report weekly on Monday. There is a spreadsheet in which I change the Startdate and enddate only in the WeeklyMSfile.xls and worksheet is Weekly and column are A1 and A2. 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-05 : 23:35:54
|
| Maybe use activex in dts? |
|
|
|
shakilhyd
Starting Member
16 Posts |
Posted - 2008-07-06 : 00:36:11
|
| Can anybody help me in my problem, as described above.Thanks. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-06 : 13:26:47
|
| Checked sqldts.com? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-07 : 02:27:37
|
| use dtsrun and call it using xp_cmdshell passing values of parameters for start and end datehttp://sql-server-performance.com/Community/forums/t/19064.aspx |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2008-07-07 : 04:17:54
|
| If there is nothing else in the Spreadsheet except the StartDate and EndDate , I recommend better use a Procedure that has parameters as getdate() - 7 and getdate() and pass the parameters to the exe fileVichttp://vicdba.blogspot.com |
|
|
|
|
|
|
DTS-Package