Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 How to convert xlsx to html/htm using ssis

Author  Topic 

raghav99k
Starting Member

32 Posts

Posted - 2011-11-21 : 09:44:21
HI,
Can some one send me procedure in ssis, how to convert xlsx to html/
htm using ssis.

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-21 : 11:09:23
no direct way. didnt understand reason for this requirement though. Can you explain?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

raghav99k
Starting Member

32 Posts

Posted - 2011-11-22 : 00:09:07
quote:
Originally posted by visakh16

no direct way. didnt understand reason for this requirement though. Can you explain?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/



Go to Top of Page

raghav99k
Starting Member

32 Posts

Posted - 2011-11-22 : 00:13:21
hI Visakh,

we have a excel report generated by cognos tool, when uploading the same to sharepoint folder , it is throwing error, so by converting the same excel report to html/htm page and uploading it is working fine.
But to automate this is there any script c#/vb to convert the same into html. if we generate html report using cognos. it is asking for credentials over sharepoint folder.. in order to avoid all these we generate xlsx report and processed as explained..

Can u pls give ur sugestions.

Thanks.
Go to Top of Page
   

- Advertisement -