(Dave Ballantyne) If there is one process that should be simpler than it is out of the box, it is creating Excel spreadsheets from SSIS. Over the years i’ve tried doing it a number of ways, using the built in component, Interop , OLE DB etc all suck to one degree or another.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help