Integration Services (SSIS)

Technical Article

Using a Script Transform in SSIS

  • Article

In SSIS, the data you receive from the source is rarely in the format your end users would like to see. To correct this, you can use the Script Component to transform data. In this video demo, Brian shows you how to use the Script transform to make a column proper case in the data flow. Free registration required.


1,805 reads

External Article

SQL Server 2005 Integration Services - Transaction Support - Part 25

  • Article

The latest article in our series discusses improvements in the transactional support implemented in SQL Server 2005 Integration Services. The more granular scope of transactions, which now can be assigned to arbitrarily designated Control Flow tasks and containers, makes it is possible to limit their impact or execute several of them in parallel. However, even with this improved functionality, you need to keep the blocking issues they might potentially introduce in mind.


2,138 reads


A New Word: Proluctance


proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

10 reasons why IT certifications are still important


As someone who has spent over 20 years in the Software/Data Engineering area and...

Know Thy Platform


IT and data professionals, I implore you – know thy platform. All of it....

Read the latest Blogs


what does this error mean?

By water490

I was running a SP and I got this.  This is the first time...

how to properly index?

By water490

I am not sure how to decide on how I should index my tables...

Software Updates, Outages, Processes, and Protocols

By Ryan Booz

Comments posted to this topic are about the item Software Updates, Outages, Processes, and...

Visit the forum

Question of the Day

Filestream on Linux

I want to implement a Filestream table on SQL Server 2022 running on Linux. Can I do this?

See possible answers