Hi all expert...please help...
I need two help from you all. Where I have exported data from sql server to Excel by SSIS. However i meet 2 difficutly :
1st :
when data exported, the boolean/bit datatype show me "-1" in excel (suppose it should show "TRUE"), anyway to solve this problem?
2nd:
the spreadsheet name is like "User Records", but no matter how i create table (in SSIS) by giving the name "User Records", the excel spreadsheet name would become "User_Records" after new spreadsheet/table is created.
any help much much appreciated.
Thanks.