SQL Export to Excel file column?
Home > IT Answers > SQL Server > SQL Export to Excel file column?
Shamilh
10 pts.
0
Q:
SQL Export to Excel file column?
SSIS Package 2005, SSIS, SSIS 2005, Microsoft Excel, SQL Export to Excel
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
ASKED: Mar 18 2009  1:13 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You can use the DATEPART to get just given parts of the DT filed.
Last Answered: Apr 4 2009  5:01 PM GMT by Alessandro.panzetta   9615 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0