I do not think you can do this using SSIS.
Thanks.
|||I hope that isn't true I really have to find a way around that. Why does Microsoft limit the access to the Office Components being automated?
|||Jerry8989 wrote:
Why does Microsoft limit the access to the Office Components being automated?
It doesn't, you just have to work a little harder.
http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/07/16018.aspx
http://msdn2.microsoft.com/en-us/library/ms136007.aspx
I think automation is the only way you'll get this accomplished.
|||
Jerry8989 wrote:
I hope that isn't true I really have to find a way around that. Why does Microsoft limit the access to the Office Components being automated?
Well, for one SSIS is an ETL tool and as such isn't designed to be making fancy looking excel sheets, powerpoint presentations, etc... It's designed to read data, transform it, and load it somewhere. So the fact that you need pretty looking visual effects in your excel sheet, doesn't really warrant the need for that feature in SSIS.
No comments:
Post a Comment