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 |
dutyfree
Starting Member
5 Posts |
Posted - 2007-08-10 : 07:25:41
|
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. |
|
|
|
|