Integration Services (SSIS)

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

SQL Prompt and SSMS 18.5

By

I downloaded SSMS 18.5, as there were a lot of fixes in here and...

Jupyter Book Challenges in ADS

By

I was excited to try the Jupyter Book feature in the March Azure Data...

Join me (virtually) in Adelaide!

By

I will be presenting a session to the Adelaide SQL Server User Group on...

Read the latest Blogs

Forums

Expression builder problem

By as1981

All, Can anyone advise the correct way to put this expression together? I've tried...

Exporting large amount of data out of AS400

By Brad Allison

Good morning from my home office.  Hope all is well. I have successfully configured...

Query Required this scenario

By vs.satheesh

Hai, One company multiple employees working data entry operators.Employees working two different  shifts. First...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

ADF Triggers

See possible answers