Home > IT Answers > Microsoft Windows > SQL Export to Excel file column?
Shamilh
10 pts.
 SQL Export to Excel file column?
Microsoft Excel, SQL Export to Excel, SSIS, SSIS 2005, SSIS Package 2005
I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance

Software/Hardware used:
ASKED: March 18, 2009  1:13 AM
UPDATED: April 4, 2009  5:01 PM
RELATED QUESTIONS
Answer Wiki:
You can use the <a href="http://msdn.microsoft.com/it-it/library/ms174420.aspx">DATEPART </a>to get just given parts of the DT filed.
Last Wiki Answer Submitted:  April 4, 2009  5:01 pm  by  alessandro.panzetta   9,695 pts.
All Answer Wiki Contributors:  alessandro.panzetta   9,695 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _