Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Overwrite the data in excel using SSIS
Mannu k
Mar 1 2016 6:16 AM
388
Reply
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..
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
C# Unable to get ProcessId of Excel Object...How to get it?
how to create database for hospital management system