Dinesh Priyankara

Accessing .NET assemblies with SSIS

SQL Server Integration Services has changed the ETL process dramatically with many new capabilities. It's extensibility is unmatched, allowing you to build workflows that were not possible in DTS. Dinesh Priyankara brings us a useful new technique for referencing your .NET assemblies from within SSIS to take advantage of code reuse.

4.5 (2)

2007-08-21

9,750 reads

UDF as Computed Column

UDF's are useful if somewhat tricky. Dinesh uses a common scenario where you have a self referencing table (the common example is an employees table where each employee has a managerid that links to another employee in the same table) to illustrate how a UDF can make querying easier, how to use it as the basis of a computed column, and how to index that column.

5 (2)

2003-06-18

10,962 reads

Blogs

Distributing Jupyter Notebooks

By

If you’re working with the Microsoft Data Platform, you should be, at the least,...

SQLSaturday Orlando Notes – Large Printed Schedules

By

One of the things we’ve done most years in Orlando is to print poster...

Upgrading Windows 10 Home to Pro

By

I use Hyper-V and a few other things that require Windows 10 Pro. When...

Read the latest Blogs

Forums

R)R)* https://presidentscupcup.co/2019/

By presidentir

https://presidentscupcup.co https://presidentscupcup.co/live/ https://presidentscupcup.co/2019/ https://presidentscupcup.co/golf/ https://presidentscupcup.co/stream/ https://presidentscupcup.co/tournament/ https://presidentscupcup.co/the-presidents-cup-2019/

R)R)* https://presidentscup-the.co/golf/

By presidentir

https://presidentscup-the.co https://presidentscup-the.co/live/ https://presidentscup-the.co/2019/ https://presidentscup-the.co/golf/ https://presidentscup-the.co/stream/ https://presidentscup-the.co/tournament/ https://presidentscup-the.co/the-presidents-cup-2019/

R)R)* https://thepresidentscup.co/stream/

By presidentir

https://thepresidentscup.co https://thepresidentscup.co/live/ https://thepresidentscup.co/2019/ https://thepresidentscup.co/golf/ https://thepresidentscup.co/stream/ https://thepresidentscup.co/tournament/ https://thepresidentscup.co/the-presidents-cup-2019/

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers