April 18, 2011 at 3:45 pm
I have a SQL server 2008 server. I have a user whose SSIS package (which runs on the server via a agent job) outputs a MS excel document and then Manipulates the content via VBA to create its final report file. This file is mailed via the SSIS package.
Beacuse of the ability to make changes via VBA, the Output file format cannot be csv (as the data/report manipulation cannot be done). The only option I see to install MS Office on the SQL server. This I think is a security risk. Are there any add-ins that can do the job of MS excel. Can you guys suggest any other alternatives here. Thanks
April 18, 2011 at 4:00 pm
You can manipulate VBA programming with dotnet and create the DLL and use this dll as a CLR in SQL Server
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 18, 2011 at 4:03 pm
That will be little outside of the "how to " knowledge of the LOB who write/manage these SSIS packages. Thanks for the suggestion though
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply