Sample Header Ad - 728x90

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