Can I create a random number in an SSIS derived column
4
votes
1
answer
3260
views
I have a task where I am trying to assign a random PIN to an account. I have SQL code that will generate a random integer between 1000 and 9999. I was wondering if I could put that in a Derived Column task in SSIS and not do it in the source data?
Also, I can probably write a Script Task to accomplish this. At this point it's more an exercise to see if it's possible since I have alternatives.
Asked by Chris The DBA
(43 rep)
Mar 29, 2016, 05:38 PM
Last activity: Mar 26, 2024, 05:28 PM
Last activity: Mar 26, 2024, 05:28 PM