数据转换器SSIS数据流组件中相应列的转换后的数据类型应该是什么? [英] What should the converted data type of the corresponding column within the Data Converter SSIS Data Flow Component be?

问题描述

我们在其中一台服务器上安装了普通的Microsoft SQL Server 2008

We have the plain Microsoft SQL Server 2008 on one of our servers

我们决定在文件系统上创建DTSX文件，以便我们可以使用BIDS 2008打开DTSX文件

We decided to create DTSX files on the filesystem so that we can use BIDS 2008 to open the DTSX files

一个SSIS控制流组件，该组件从Microsoft SQL Server 2008 SQL select查询中获取大约18-19列中的数据，然后转换这些值以将其放置在Microsoft Access表中.我有许多列是使用称为OLE DB源的DataFlow组件从Microsoft SQL Server 2008表中检索的.检索数据后，我有一个数据转换器数据流组件，用于转换值.最后，转换后的值由OLE DB目标数据流组件放置，并放置在Microsoft Access表中.

One SSIS Control Flow Components that takes data from around 18-19 columns from a Microsoft SQL Server 2008 SQL select query, and then converts the values in order to place them in the Microsoft Access table. I have a number of columns that I retrieve from Microsoft SQL Server 2008 table using a DataFlow Component called OLE DB Source. After retrieving the data, I have a Data Converter data Flow Component that converts the values. Finally, the converted values are placed by an OLE DB Destination data Flow Component, and placed in a Microsoft Access table.

对于Microsoft SQL Server 2008中的列之一，数据类型为varchar(5)

For one of the columns from a Microsoft SQL Server 2008 , the data type is varchar(5)

需要使用名为OLE DB Source的SSIS DataFlow组件作为字符串[DT_STR]数据类型，从Microsoft SQL Server 2008中提取上述varchar(5)列中的值 它需要使用Data Converter SSIS数据流组件进行转换 最后，需要将其放置在Microsoft Access表中名为文本"的数据类型的列中.

The value in the above varchar(5) column needs to be extracted from Microsoft SQL Server 2008 using a SSIS DataFlow Component called OLE DB Source as a string [DT_STR] Data Type It needs to converted using the Data Converter SSIS data Flow Component Finally, it needs to placed in the Microsoft Access table to a column of the data type called Text.

数据转换器SSIS数据流组件中相应列的转换后的数据类型应该是什么?

What should the converted data type of the corresponding column within the Data Converter SSIS Data Flow Component be?

推荐答案

@ vikramsinh-shinde感谢您的网页链接.以下实现似乎可以确保SSIS包正确运行，但是，我希望这是处理SSIS包中转换的正确方法.

@vikramsinh-shinde Thanks for the webpage links. The following implementation seemed to ensure that the SSIS package ran properly, however, I hope it's the proper way to handle conversion in the SSIS packages.

Microsoft SQL Server 2008中的
1. -varchar(5)列值
2. 提取为字符串[DT_STR]，在名为OLE DB Source的SSIS DataFlow组件中的长度为5，代码页为1252.
3. -在称为数据转换器"的SSIS数据流组件中转换为Unicode字符串[DT_WSTR]，长度为5(且不可修改的codePage为0)
4. -加载到名为Text的数据类型的Microsoft Access列值中

1. -varchar(5) column values in Microsoft SQL Server 2008
2. -extracted as string [DT_STR] that has a length of 5 and Codepage of 1252 within SSIS DataFlow Component called OLE DB Source
3. -converted to Unicode string [DT_WSTR] that has length of 5 ( and non-modifiable codePage of 0 ) within SSIS Data Flow Component called Data Converter
4. -loaded into Microsoft Access column values of data type called Text

这篇关于数据转换器SSIS数据流组件中相应列的转换后的数据类型应该是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！