Integration Services (SSIS)

Technical Article

The OLE DB Command Transformation

  • Article

In the newsgroups we have been asked on a number of occasions how to execute a stored procedure once for every row of input data. There's currently no really good way of doing this but in SQL Server 2005 DTS that is about to change. This article is going to show you how to take values from a source table and for every row execute a stored procedure which inserts values into another table.

2004-11-11

1,551 reads

Blogs

Daily Coping 4 Jul 2022

By

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

SQLServerCarpenter Tools

By

Over the past couple of years, I’ve developed several tools that I’ve been using...

usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON

By

/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...

Read the latest Blogs

Forums

CAST AS DATE Assistance

By carlton 84646

Can someone let me know why I'm not able to use CAST method to...

Deploying a standalone Azure VM running SQL Server into an availability zone

By DBANewbie

If i deploy a standalone Azure VM running SQL Server into an availavility zone;...

SQL Server 2014 Question

By kazana

So I have inherited an older SQL 2014 Server and have been working on...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers