"Nash" <nmepani@gmail.com> wrote in message
news:1186742565.837397.305550@x35g2000prf.googlegroups.com...
>I have SSIS(DTS) using the dataflow OLE db which query the database to
> extract information for actions done yestarday. In the sql statement
> i'm using calling the function DATEADD(dd, -1, getdate()) to extract
> the yestardays information on a date field.
> This package sends information in excel format as the final
> destination. Then i have a job which located the DTS package and
> executes.
> The trouble is when i run the job created from sql server agent it add
> the data to the existing file making it double the size. How can i
> make sure that the desitination file (excel) data does not get added
> or even better get renamed with yestarday's date.
>
> thanks
>

wrote:
> Hi
> There is a property call ExcelFilePath, in the excel connection, that you
> can set to the value of a variable. This is the name of the excel file you
> create.
> So create a string variable, using a script assing the date to the variable
> and then assign to the excel connection property the value of the variable
> cheers
>
> --
>
> Francisco A. Gonzalez
> fgonza...@solidq.com
>
> "Nash" <nmep...@gmail.com> wrote in message
>
> news:1186742565.837397.305550@x35g2000prf.googlegroups.com...
>
>
>
> >I have SSIS(DTS) using the dataflow OLE db which query the database to
> > extract information for actions done yestarday. In the sql statement
> > i'm using calling the function DATEADD(dd, -1, getdate()) to extract
> > the yestardays information on a date field.
> > This package sends information in excel format as the final
> > destination. Then i have a job which located the DTS package and
> > executes.
> > The trouble is when i run the job created from sql server agent it add
> > the data to the existing file making it double the size. How can i
> > make sure that the desitination file (excel) data does not get added
> > or even better get renamed with yestarday's date.
>
> > thanks- Hide quoted text -
>
> - Show quoted text -

> and then assign to the excel connection property the value of the variable" Any ideas.
>