使用ssis覆盖excel中的数据 [英] Overwrite the data in excel using ssis
问题描述
我必须每天从Sql server加载数据excel并且必须通过邮件发送excel。如果我运行两次相同的包,数据将被附加到excel中。我不想追加数据,但想在同一天覆盖。并且如果第二天运行它应该创建一个带有Filename的新文件,并在第一次行军时添加日期,如Filename_20160301。我们如何实现这一目标?你可以举个例子,因为我是SSIS的新手吗?
我不想使用drop并创建excel表,因为我有一些限制。我想用脚本任务实现这个目标。
提前谢谢..
答案是这里。
使用SSIS覆盖excel文件 [ ^ ]
Hi, I have to load data from Sql server to excel daily and have to send that excel via mail. If I run two time the same package , data will be appended into the excel. I dont want to append the data, but want to overwrite If same day. And If run next day It should create a new file with Filename and suffixed by Date like Filename_20160301 for 1st march. How do we achieve this? Could you give by example as i am new to SSIS?
I do not want to use drop and create excel table as I have some limitation. i want to achieve this using script task.
Thanks in advance..
The answer is here.
Overwriting an excel file using SSIS[^]
这篇关于使用ssis覆盖excel中的数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!