title: Generate Unique Random number in SSIS
body: <p>I'm loading data from Flat file to SQL Server database. Along with the normal column, i want to add one more column with unique random number. I have around <code>500000</code> rows as of now. I have created a Derived column and added the expression </p>
  
  <pre><code>ABS(CHECKSUM(NEWID()))
  </code></pre>
  
  <p>to that. But it is throwing error <code>NEWID was not recognised</code>. I understand this is not supported in SSIS. Please help me here. Is there any other function that i can use for this? I searched some of the stackoverflow question but it didn't helped.</p>