Click here to Skip to main content
15,881,380 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
indian1434-Oct-17 6:58
indian1434-Oct-17 6:58 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan4-Oct-17 22:24
mveRichard MacCutchan4-Oct-17 22:24 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
indian1435-Oct-17 3:15
indian1435-Oct-17 3:15 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan5-Oct-17 3:25
mveRichard MacCutchan5-Oct-17 3:25 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
indian1435-Oct-17 3:35
indian1435-Oct-17 3:35 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan5-Oct-17 3:51
mveRichard MacCutchan5-Oct-17 3:51 
AnswerRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Gerry Schmitz4-Oct-17 6:02
mveGerry Schmitz4-Oct-17 6:02 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table - able to achieve but a small issue still remaining Pin
indian1434-Oct-17 7:06
indian1434-Oct-17 7:06 
Hi Buddy,

I could able to figure it out some how to convert the values into float, date using Data Conversion of SSIS, but there is one small problem I am getting when I convert the Date string that looks like '8/31/2017 12:59:00 AM' into Dt_DbDateTimeStamp or Dt_Date, it is only importing the like this: '8/31/2017 00:00:00 AM'

Can anybody please suggest me what to do to import the full Date time stamp at least up to minutes or seconds if possible.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."


-- modified 5-Oct-17 9:14am.
QuestionImprove the performance of the reading of Excel Files using interop Pin
indian1433-Oct-17 11:45
indian1433-Oct-17 11:45 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Dave Kreskowiak3-Oct-17 13:42
mveDave Kreskowiak3-Oct-17 13:42 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Gerry Schmitz4-Oct-17 5:37
mveGerry Schmitz4-Oct-17 5:37 
SuggestionRe: Improve the performance of the reading of Excel Files using interop Pin
Richard Deeming4-Oct-17 9:15
mveRichard Deeming4-Oct-17 9:15 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Patrice T7-Oct-17 15:43
mvePatrice T7-Oct-17 15:43 
QuestionArranging the box concept Pin
Member 1289648327-Sep-17 4:29
Member 1289648327-Sep-17 4:29 
AnswerRe: Arranging the box concept Pin
Pete O'Hanlon27-Sep-17 4:31
mvePete O'Hanlon27-Sep-17 4:31 
AnswerRe: Arranging the box concept Pin
Eddy Vluggen27-Sep-17 5:30
professionalEddy Vluggen27-Sep-17 5:30 
QuestionConverting 32 bit Excel Files to 64 bit Excel files Programatically Pin
indian14326-Sep-17 6:53
indian14326-Sep-17 6:53 
AnswerRe: Converting 32 bit Excel Files to 64 bit Excel files Programatically Pin
Richard Deeming26-Sep-17 7:28
mveRichard Deeming26-Sep-17 7:28 
QuestionNeed to find out which versions of the Oracle and Office Drivers are installed on my machine Pin
indian14321-Sep-17 10:18
indian14321-Sep-17 10:18 
AnswerRe: Need to find out which versions of the Oracle and Office Drivers are installed on my machine Pin
Gerry Schmitz21-Sep-17 12:44
mveGerry Schmitz21-Sep-17 12:44 
GeneralRe: Need to find out which versions of the Oracle and Office Drivers are installed on my machine Pin
Peter R. Fletcher14-Oct-17 11:24
Peter R. Fletcher14-Oct-17 11:24 
QuestionConvert String to HEX Format Represents a 32-Bit Signed Integer Pin
chr1s211-Sep-17 1:40
chr1s211-Sep-17 1:40 
AnswerRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
Richard Deeming1-Sep-17 2:34
mveRichard Deeming1-Sep-17 2:34 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
chr1s211-Sep-17 4:07
chr1s211-Sep-17 4:07 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
jschell18-Sep-17 12:24
jschell18-Sep-17 12:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.