January 7, 2009 at 9:19 am
The reasons i am not using SSIS is that i could not find a way to auto fit the columns (one of the requirements).
January 7, 2009 at 10:46 am
You can have SSIS run .NET code, which can be used to automate Excel. Have SSIS create the Excel file, then a script opens the file through automation, auto-fits the columns, does any other layout and formatting, then closes it, then e-mail the thing.
Since you can set an SQL Agent job (with the SSIS package in it) to run under a login with whatever level of access you need, without changing the authority that SQL runs under, that might be a good solution for you.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply