I created a package which runs everydays and dumps the data into an excel file.
The problem iam facing is that -today the package runs and fills in the excel file,tomorrow it again runs and fills in the data without deleting the previous records.......
But i want it to delete the records already present and fill in the excel
second stup am using excute sql task to create the same excel sheet,
But am getting the same result ,Table is not deleted and not created in the second stup
can some one pls find the problem and resolve as earliest
The external columns for comp
onent "Excel Destination" (28
) are out of synchronization with the data source columns. The external column "SERV_LOCATION_ST" needs to be updated
i GOT THIS WARNING FINALLY ........
Use an empty excel template each time you export.
Refer this link,
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?