All Forums Tools
gksadak 1 post Joined 10/12
11 Oct 2012
TPT12120 error in TPT export operator

Hi,
 
I am trying to export data using TPT export operator. It is successing if I dont use any qualify function in SQL, but failing if i use one.
can we use Qualify (like qualify row_number() over(partition by col1 order by col2, col3) = 1) function in TPT export SQL
thanks

feinholz 1234 posts Joined 05/08
15 Oct 2012

Please post the script, and the entire output from the job.
 

--SteveF

feinholz 1234 posts Joined 05/08
15 Oct 2012

I looked up the TPT12120 error. It states:
"Order By clause and Multiple Instances are mutually exclusive"
 
This is pretty obvious.
Your SELECT statement has an ORDER BY clause in it, but you have requested multiple instances to execute in the Export operator. You cannot have parallelism when you have an ORDER BY clause in the SELECT.
Either remove the ORDER BY, or change your script so that you are only specifying 1 instance of the Export operator.
 

--SteveF

You must sign in to leave a comment.