Click here to Skip to main content
13,558,544 members

.NET Framework

 
GeneralRe: An unhandled exception of type 'System.AccessViolationException' occurred in System.Data.dll Pin
Richard MacCutchan5-Oct-17 3:27
protectorRichard MacCutchan5-Oct-17 3:27 
GeneralRe: An unhandled exception of type 'System.AccessViolationException' occurred in System.Data.dll Pin
indian1435-Oct-17 3:34
memberindian1435-Oct-17 3:34 
GeneralRe: An unhandled exception of type 'System.AccessViolationException' occurred in System.Data.dll Pin
indian1435-Oct-17 7:46
memberindian1435-Oct-17 7:46 
GeneralRe: An unhandled exception of type 'System.AccessViolationException' occurred in System.Data.dll Pin
Richard MacCutchan5-Oct-17 21:03
protectorRichard MacCutchan5-Oct-17 21:03 
AnswerRe: An unhandled exception of type 'System.AccessViolationException' occurred in System.Data.dll Pin
Eddy Vluggen5-Oct-17 3:45
professionalEddy Vluggen5-Oct-17 3:45 
GeneralRe: An unhandled exception of type 'System.AccessViolationException' occurred in System.Data.dll Pin
indian1435-Oct-17 7:46
memberindian1435-Oct-17 7:46 
GeneralRe: An unhandled exception of type 'System.AccessViolationException' occurred in System.Data.dll Pin
Eddy Vluggen6-Oct-17 1:51
professionalEddy Vluggen6-Oct-17 1:51 
QuestionImport Date values from Pipe-Delimited file to SQL Server table Pin
indian1433-Oct-17 21:07
memberindian1433-Oct-17 21:07 
Hi,

I am trying to import Date values of Pipe-Delimited file into Sql Table, I am getting the following error
Error: 0xC0049064 at Populate Stage, Derived Column [97]: An error occurred while attempting to perform a type cast.
Error: 0xC0209029 at Populate Stage, Derived Column [97]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "Derived Column" failed because error code 0xC0049064 occurred, and the error row disposition on "Derived Column.Outputs[Derived Column Output].Columns[Payment Due Date]" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
Error: 0xC0047022 at Populate Stage, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Derived Column" (97) 
failed with error code 0xC0209029 while processing input "Derived Column Input" (98). The identified component returned an error from the ProcessInput method. 

The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.

The Following is the expression I am using for the derived Column
(DT_DATE)(SUBSTRING([Date Posted],1,4) + "-" + SUBSTRING([Date Posted],5,2) + "-" + SUBSTRING([Date Posted],7,2))

I am also trying my best searching online, can anybody please let me know if I am missing anything. Thanks in advance.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."
SuggestionRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan3-Oct-17 21:38
protectorRichard MacCutchan3-Oct-17 21:38 
AnswerRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Mycroft Holmes3-Oct-17 21:38
professionalMycroft Holmes3-Oct-17 21:38 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
indian1434-Oct-17 6:58
memberindian1434-Oct-17 6:58 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan4-Oct-17 22:24
protectorRichard MacCutchan4-Oct-17 22:24 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
indian1435-Oct-17 3:15
memberindian1435-Oct-17 3:15 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan5-Oct-17 3:25
protectorRichard MacCutchan5-Oct-17 3:25 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
indian1435-Oct-17 3:35
memberindian1435-Oct-17 3:35 
GeneralRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Richard MacCutchan5-Oct-17 3:51
protectorRichard MacCutchan5-Oct-17 3:51 
AnswerRe: Import Date values from Pipe-Delimited file to SQL Server table Pin
Gerry Schmitz4-Oct-17 6:02
memberGerry 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
memberindian1434-Oct-17 7:06 
QuestionImprove the performance of the reading of Excel Files using interop Pin
indian1433-Oct-17 11:45
memberindian1433-Oct-17 11:45 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Dave Kreskowiak3-Oct-17 13:42
mvpDave Kreskowiak3-Oct-17 13:42 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
Gerry Schmitz4-Oct-17 5:37
memberGerry Schmitz4-Oct-17 5:37 
SuggestionRe: Improve the performance of the reading of Excel Files using interop Pin
Richard Deeming4-Oct-17 9:15
mvpRichard Deeming4-Oct-17 9:15 
AnswerRe: Improve the performance of the reading of Excel Files using interop Pin
ppolymorphe7-Oct-17 15:43
mvpppolymorphe7-Oct-17 15:43 
QuestionArranging the box concept Pin
Member 1289648327-Sep-17 4:29
memberMember 1289648327-Sep-17 4:29 
AnswerRe: Arranging the box concept Pin
Pete O'Hanlon27-Sep-17 4:31
protectorPete O'Hanlon27-Sep-17 4:31 

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.


Advertise | Privacy |
Web04-2016 | 2.8.180515.1 | Last Updated 25 May 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid