Incorrect UnPivot metadata

Pat Snow 111 Reputation points
2022-08-17T00:59:06.757+00:00

I'm importing a csv file in SSIS. It breaks on the unpivot. The column is just text. The columns before it are either text, numeric, or alpha numeric. Is there a way to transform all the columns in a csv file as text?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,248 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,821 Reputation points
    2022-08-17T02:12:05.763+00:00

    Hi @Pat Snow ，

    I could not catch your meaning, could you please provide some images to describe the issue?

    To pivot or unpivot, you may consider to use unpivot-transformation and pivot-transformation.

    transform all the columns in a csv file as text

    To convert the columns as text, try with derived-column-transformation.

    If I misunderstand your issue, please incorrect me.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  2. Pat Snow 111 Reputation points
    2022-08-17T16:48:20+00:00

    I'm using an unpivot task. I just found out the problem is some of the fields are varchar and some are nvarchar. I tried using a data conversion to change the nvarchar to varchar but I'm still getting the same error on the unpivot task.