SQL Server Performance Forum – Threads Archive
export to excel – formatting number output
Hi all,<br /><br />Once again, SSIS is giving me a ‘F.U.N.’ time (ask for definition of the F.U.N. acronym another time <img src=’/community/emoticons/emotion-1.gif’ alt=’![Smile :) :)](styles/default/xenforo/smilies/smile.png)
THis is not a solution, but have you tried the same with DTS?> Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
erm – no – I haven’t tried DTS.
Can I deploy DTS jobs to a SQL 2005 server – I guess it probably would work… although (strange to admit), I’ve probably (in fact defintely) got more experience with SSIS (all of 2 months :-0 ) than DTS, even though I’ve been using SQL2000 for 5 years or so – I’ve just never needed to use it, really. Do you think/know that the same problem doesn’t exist in SQL2000 DTS? At the end of the day, it won’t really be a problem, since the data is being generate for human review – it isn’t critical that it be in number format in the generated spreadsheet, but it irritates me that it isn’t, and it feels like something we should be able to do – agree? Panic, Chaos, Disorder … my work here is done –unknown
quote:Originally posted by satya
THis is not a solution, but have you tried the same with DTS?>
Well i see some really stupied answers. But not with a solution. I guess with that kind of answers i could also say that i really like the sun and the beach. Anyway i have that same problem with the output in excel. It is really not clear how to implement a good solution.
I have the problem with a csv file that i would like to translate to an xls file thru a dts package. Offcourse i want it to be fully automated. I can create an excel file and i can format the excel file with datafilters, bold, autofit whatever and i can also create the format of the destination cells in excel. The thing is that the DTS package in the datapump section just thinks that every output cell is in the varchar 255 format.
I have seen in the datapump properties that the destination cells are all of the same type. I tried to change the properties with a dynamic properties object that would change the properties at runtime. But nothing seems to help all the output cells (columns) are still in the varchar(255) fromat.
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
http://www.acronymattic.com/results.aspx?q=F.U.N.<br />Let me guess… It’s the last one in that list? If not even worse. [<img src=’/community/emoticons/emotion-2.gif’ alt=’
![Big Grin :D :D](styles/default/xenforo/smilies/biggrin.png)
For those of you with that evil grin,<br /><br />FUN – Function Unknown Now<br /><br />[<img src=’/community/emoticons/emotion-5.gif’ alt=’
![Wink ;) ;)](styles/default/xenforo/smilies/wink.png)
Furious,
Uncontrollable
Neurosis Panic, Chaos, Disorder … my work here is done –unknown
Close to the definition in my link:<br />FUN Fantastically Unbelievable Nonsense <br />[<img src=’/community/emoticons/emotion-2.gif’ alt=’
![Big Grin :D :D](styles/default/xenforo/smilies/biggrin.png)
]]>