In some cases we need to load data from SQL Server table to Excel destination and the existing data or sheet in Excel file needs to be removed, then we can do this process using the File System Task in SSIS to delete the file. Also use the Execute SQL Task to create the file with same column name.
Below are the figure illustrate step by step process:
Below are the figure illustrate step by step process:
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.