SSIS data flow path editor

Question

SSIS data flow path editor

nononame2021 261

refer to the following screen captured. may i know what is Metadata in Data Flow Path Editor when i click the "Flow path" in data flow task. is it same as the excel source 's data type and lenght. it is referring to excel source ?
i did not set it and it is auto set to 255 for DT_WSTR automatically. don't know what is it?

2 answers

Your answer

Answer 1

ZoeHui-MSFT 41,491

Hi @nononame2021 ,

Note that you have post several issues in Q&A but none of them have been accept as an answer by you which will quench the enthusiasm of the experts to help you.

If your previous problem has been solved, you could mark it as answer so other user with similar problem could see this easier.

And back to your question:

The metadata shows the name, data type, precision, scale, length, code page, and source component of each column in the output of the previous component. The source component is the data flow component that created the column. This may or may not be the first component in the data flow.

integration-services-paths

it is auto set to 255 for DT_WSTR automatically

The Excel driver recognizes only a limited set of data types. For example, all numeric columns are interpreted as doubles (DT_R8), and all string columns (other than memo columns) are interpreted as 255-character Unicode strings (DT_WSTR). It is by design.

load-data-to-from-excel-with-ssis

Regards，

Zoe

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

nononame2021 261 Reputation points

2022-03-30T07:20:40.123+00:00

may I know it will change everytime automatically when I change the value in excel, then it will define datatype at runtime?

last time I leave all cell blank , it will treat it as string field, right?

when I input one of the cell in specific column, ssis will treat that field as number field, right?
ZoeHui-MSFT 41,491 Reputation points

2022-03-30T09:51:07.837+00:00

Hi @nononame2021 ,

If you leave all cell blank , it will treat it as string field, if you format the columns as numeric, they will be treat as doubles (DT_R8).
You may do a test locally with some sample data to verify this.

If you change the format in excel, when you preview the source, it will pop up the warning just click ok it will change the datatype automatically in SSIS.
nononame2021 261 Reputation points

2022-03-30T10:24:40.79+00:00

so if the job trigger from job agent , it will fail until I open the ssis manually to replace the datatype with the current input.
ZoeHui-MSFT 41,491 Reputation points

2022-03-31T01:01:06.393+00:00

Hi @nononame2021 ,
I think it's the logic is correct, because your data source has changed, the package cannot be executed, you need to change the package and re-deploy it.

Answer 2

Olaf Helper 47,436

i did not set it and it is auto set to 255 for DT_WSTR automatically. don't know what is it?

That's by design for Excel data sources. Excel only knows an untyped value and a format information; and that untyped value is of nvarchar(255).
But what is the issue here?

Share via

SSIS data flow path editor

2 answers

Your answer