Solved

run a stored procedure in dta flow task of ssis

Posted on 2010-08-18
7
361 Views
Last Modified: 2013-11-10
Hi All,

Currently I am running a stored procedure in a oledb command and using the output in my other tasks .

My stored procedure updates a column by one number in a loop but oledb command does only one row per dataset.its resulting the same barcode number to all columns.

so i need to know a way to run my stored procedure in data flow and capture results.
0
Comment
Question by:kakarlapudidivya
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 16

Expert Comment

by:vdr1620
ID: 33469167
You can use

SET FMTONLY OFF
SET NOCOUNT ON

Exec StoredProcedureName

that would run similar to any select statement
0
 

Author Comment

by:kakarlapudidivya
ID: 33469316
can we run 2 stored procedures in a ooledb command

if yes then how???
0
 
LVL 16

Expert Comment

by:vdr1620
ID: 33469342
No, you cannot run two stored procedures in a ole db command
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 30

Expert Comment

by:Reza Rad
ID: 33469442
look at my post here:
http://rad.pasfu.com/index.php?/archives/24-Output-Parameter-of-Stored-Procedure-In-OLE-DB-Command-SSIS.html

does it what you looking for exactly?
if not explain more about what you want to do
0
 
LVL 30

Accepted Solution

by:
Reza Rad earned 500 total points
ID: 33469451
you can combine two stored procedure in one stored procedure, and run it by an OLE DB Command also if you need.
0
 

Author Comment

by:kakarlapudidivya
ID: 33469573
I exactly did the same thing bu caling one rocedure in to another adn i worked fine

thanks
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 33469606
your welcome,
Regards,

0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question