|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/22/2008 1:19:25 PM
Posts: 5,
Visits: 20
|
|
Objective: Export a large amount of data to a pipe delimited file.
Error: Output Schema does not match data from SELECT statement
What I am doing:
I am using the TPT wizard to create and run the job. As I go through the steps in TPT, when I get to the part of selecting what columns I want, I click the 'select all' option. The format of the columns that I am selecting ranges from char to int to decimal. After selecting all, I then proceed to change the type to varchar. I am changing the type because I read in the manual that if you are exporting to a delimited file, all columns need to be changed to varchars. The problem is when I run the job, anything that wasn't already a varchar causes the above error if it is selected. I am assuming I am doing something wrong in the TPT script but I figured I would ask.
|
|
|
|