Data Warehouse Construction (1)

The following prompt is displayed during package execution today:

[Distribution Center 1 [1781] error: the output column "rebate" (1792) on "ole db source output" (1807) has an error. The returned column status is: "The text is truncated, or one or more characters are in the targetCodeThere is no match in the page .".

At first, I thought that some steps in the process set the Data Type incorrectly, but this was not solved after repeated debugging.

There are too few SSIS-related materials, and no reason is found on the Internet at noon.

 

Therefore, the smallest unit method is used for gradual debugging.

After removing the intermediate link, the error persists.

Change the target source to a text file, so that the target source does not have data overflow problems, and the error persists.

The Data Length of the target source and target columns is changed to 1000. Change the data type with multiple errors.

Suddenly the ghost machine moves and does not output the results. Only two processes are retained, source output and sorting. Because sorting is irrelevant to the data type, this step will certainly pass, otherwise it will be a problem of source output.

Indeed, if the sorting process fails to be executed, the process stops in the first step. It is determined that it is a problem of source output.

Now we use the "ole db source" and try to change it to the "ado net source". Haha, it passed.

 

I really don't understand SSIs. I used the "ado net source" for the output source a few days ago, but the error always occurred. So I changed it to "OLE DB source ". Today, I reversed it. The "OLE DB source" is not working. It seems that there is still a lack of in-depth understanding.