SSIS Package with a Derived Column

Question

SSIS Package with a Derived Column

thomasstricker2001

SSC Veteran

Points: 204
More actions
February 5, 2018 at 10:58 pm

#343487

Comments posted to this topic are about the item SSIS Package with a Derived Column

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

RonKyle SSC-Dedicated Points: 31557 More actions · Answer 1

I make it a practice to open SSIS and SSDT as administrator to avoid annoying permission errors. This error seems to appear most frequently during the Data Flow process.

This does seem to be necessary since the introduction of the .ipsac file with the move to the project mode of development and deployment. It is annoying, however, and in my view reflects poorly on the project. However, I'm otherwise a big fan of the changes, so I'll make due. Hopefully this is on the list of things to be "corrected" for a future release.

drew.allen SSC Guru Points: 76989 More actions · Answer 2

RonKyle - Tuesday, February 6, 2018 7:46 AM
However, I'm otherwise a big fan of the changes, so I'll make due.

Make do vs. make due

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

Naidu PK SSCrazy Points: 2481 More actions · Answer 3

Thanks for sharing useful Info Thomas.
I had a case recently in my org where data is moved to SQL Server already but coming towards the derived column part, one challenge I saw in my company recently was: Calculate the difference in price per square foot relative to the two immediate neighbors.
This one is like you need to know the data from previous or next rows to make this calculation. Is there any easy way to achieve this?

Thanks,
Naveen.
Every thought is a cause and every condition an effect