If i pass 1,2,3,4,5 from text file to OLE DB Command and result of the same to another text file it is returning same 1,2,3,4,5 it not executing the SP...

You don't need an OLE DB Destination, but an OLE DB Command.

This article explains a bit how to set it up with a stored procedure:

Output Parameter of Stored Procedure In...

Hi Have you tried before i couldn't able to connect it. :w00t:

can anyone guide me on step by step basis.

Thanks

Koen Verbeeck (2/15/2012)

---

Read the text file using a Flat File source and pass the two columns as parameters in an OLE DB Command component.

The OLE DB Command will have a...

Hi,

But how to pass each and every value one by one basis.

The thing is like this

I am having a text file which is having around 100 records with 2 columns

say Empid, mgrid

1...

Yes i tried but same result.:w00t:

Hi,

I am not using two systems only one system is been used.i tried to install all the .net fram work related to 2005 though it is not working for me...

Declare @Temp table (Rid int identity,String varchar(25))

declare @string varchar(100)

declare @Input int...

tfifield (12/21/2011)

---

Once you know which procedure has your search word, you can dump that into a table that has each line of text for the procedure. Then search the...

Hi,

What information you need?

where did you need me to explain?.

i have given conditions i think you where not able to read my post correctly.Other peoples who have read...

Hi any one got the solution :w00t: still i am unable to get.