My source is TXT Flat File Source, Destination is of OLE DB type. (see image)
I found a very simple basic Code Project tutorial for creating a package. I have finished the steps, but when debugging I get a strange error (below):
Can someone give an explanation for this error? It took me several hours to find an error on the Internet.
SSIS "C:\Users\USRNAME\Desktop\Projects\DataGeneratorSsis\DataGeneratorSsis\Package.dtsx" . : 0x4004300A , SSIS.Pipeline: . : 0x4004300A , SSIS.Pipeline: . : 0x80047076 , SSIS.Pipeline: "intApplication" (7) " " (6) " " (2) . . : 0x40043006 , SSIS.Pipeline: . : 0x40043007 , SSIS.Pipeline: . : 0x402090DC , 2: "C:\Users\USRNAME\Desktop\ddd.txt" . : 0x4004300C , SSIS.Pipeline: . : 0x402090DE , Flat File Source 2: , "C:\Users\USRNAME\Desktop\ddd.txt" - 2. : 0xC0202009 Data , OLE DB [43]: SSIS DTS_E_OLEDBERROR. OLE DB. : 0x80040E21. OLE DB . : "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E21 : " OLE DB . OLE DB, . ". : 0xC020901C , OLE DB [43]: OLE DB Destination.Inputs [OLE DB Destination Input]. [AppID] OLE DB Destination.Inputs [OLE DB Destination Input]. : " - ". : 0xC0209029 , OLE DB [43]: SSIS DTS_E_INDUCEDTRANSFORMFAILUREONERROR. "OLE DB Destination.Inputs [OLE DB Destination Input]" , 0xC0209077, "OLE DB Destination.Inputs [OLE DB Destination Input]" . . . : 0xC0047022 , SSIS.Pipeline: SSIS DTS_E_PROCESSINPUTFAILED. ProcessInput " OLE DB" (43) 0xC0209029 " OLE DB Input" (56). ProcessInput. , . . : 0x40043008 , SSIS.Pipeline: . : 0x402090DD , 2: "C:\Users\USRNAME\Desktop\ddd.txt" . : 0x4004300B , SSIS.Pipeline: " OLE DB" 0 . : 0x40043009 , SSIS.Pipeline: . : : 0x80019002 : SSIS DTS_W_MAXIMUMERRORCOUNTREACHED. Execution , (4) (1); . , , MaximumErrorCount. MaximumErrorCount . SSIS "C:\Users\USRNAME\Desktop\Projects\DataGeneratorSsis\DataGeneratorSsis\Package.dtsx" : .
OLE DB Destination.Inputs [OLE DB Destination Input].Columns [AppID] OLE DB Destination.Inputs [OLE DB Destination Input]. : " - ".