Stan Kulp


How to Compile, Deploy and Consume a SQL Server CLR Assembly

Specialized tasks like cryptography require external libraries that are not available in SQL Server. Methods for such tasks can be compiled in a .NET language and deployed to SQL Server as a CLR assembly where the assembly's methods can be referenced by SQL Server stored procedures and functions.

4.92 (37)

2013-08-13

7,089 reads

Batch ETL of Multiple Data Files Using an SSIS Foreach Loop Container

An SSIS ETL package created with the Import/Export Wizard uses a Data Flow Task to process one data file at a time. If the need arises, however, the Data Flow Task generated by the wizard can be embedded inside a Foreach Loop Container to batch-process a continuous stream of data files.

4.45 (20)

2013-06-13

7,079 reads

A script task alternative to a massive SSIS multicast transformation

A Multicast Transformation can be used to write the same data file to multiple network folders, but it can be tedious and time-consuming to set up as the number of destination files grows. Learn how you can use this transformation in this article by Stan Kulp.

4.13 (15)

2012-01-17

4,282 reads

Blogs

Updating my Kubernetes Raspberry Pi Cluster to containerd

By

There’s been a lot of conversations happening on twitter over the last couple of...

Daily Coping 3 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – December 2020 – Participate in the Advent of Code.

By

Christmas. Depending on where you live it’s a big deal even if you aren’t...

Read the latest Blogs

Forums

Export nvarchar(4000) to Excel

By Sailor

I'm trying to use the SSMS 18.7.1  Export Wizard to export to an Excel...

not able to use my user defined function

By DaveBriCam

I have a function I have created and need some help in how to...

SSRS site settings security and Home folder Security

By graham.measures

I am rewriting 100 or so reports on a SSRS 2012 server and migrating...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers