and you would like it to be displayed this way (time set to "0"): 2012-11-27 00:00:00.0000000
Tip :
declare @myDate datetime2;)
select @mydate = DATEADD(DD, 0, DATEDIFF(DD, 0, GETDATE()))
declare @myDate datetime2;)
select @mydate = DATEADD(DD, 0, DATEDIFF(DD, 0, GETDATE()))
Description: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available. End Error Error: 2012-10-18 15:43:10.76 Code: 0xC00291EC Source: create xls file for Execute SQL Task Description: Failed to acquire connection "DestinationConnectionExcel". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 15:43:08 Finished: 15:43:10 Elapsed: 2.309 seconds. The package execution failed. The step failed.