I need to run a DTS package everyday twice.
Everytime it should fetch some record and put in a excel sheet (in a definite place).Now my requirement is that this DTs should override the excel file everytime.As it is a daily requirment I need this.How can I get new fresh records everytime?Refer to this KBA [http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319951] for more information.
You can schedule the DTS package in order to execute the package twice or as per the requirement.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment