The procedure never exits without the results.

I always get good results.

The Procedure calls some other procedures but they all are available in the database.

1. Does the proc you are trying to execute exist in the DB you have in your connection string?

It does exist in the database

2. Does the...

After removing Set FmtOnly OFF;

i got the same message

Msg 7357, Level 16, State 2, Line 1

Cannot process the object "EXEC Rpt_AccountsReceivableAgingSp '2011-01-31','2011-01-31',NULL,NULL,'A','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','B','1','0','1','1','D','1','0','0','A','12345','I','30','Current','60','31-60','90','61-90','120','91-120','999','Over 120','Phil','1','1'". The OLE DB provider "SQLNCLI" for...

result of @sql is

SELECT * INTO tempdb.dbo.TempAging FROM OPENROWSET('SQLOLEDB', 'Server=phlsl801;Trusted_Connection=Yes;Database=phil_pilot_app', 'Set FmtOnly OFF; EXEC Rpt_AccountsReceivableAgingSp ''2011-01-31'',''2011-01-31'',NULL,NULL,''A'',''1'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,''0'',''B'',''1'',''0'',''1'',''1'',''D'',''1'',''0'',''0'',''A'',''12345'',''I'',''30'',''Current'',''60'',''31-60'',''90'',''61-90'',''120'',''91-120'',''999'',''Over 120'',''Phil'',''1'',''1''')

Error When i execut...

THIS IS THE STRING I GOT FROM @SQL

SELECT * INTO tempdb.dbo.TempAging FROM OPENROWSET('SQLOLEDB', 'Server=phlsl801;Trusted_Connection=Yes;Database=phil_pilot_app', 'Set FmtOnly OFF; EXEC Rpt_AccountsReceivableAgingSp '2011-01-31','2011-01-31',NULL,NULL,'A','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','B','1','0','1','1','D','1','0','0','A','12345','I','30','Current','60','31-60','90','61-90','120','91-120','999','Over...

Here is what i want to do.

declare @IpStoredProcName as varchar(200)

DECLARE @IpParms AS VARCHAR(4000)

declare @IpFileName as varchar(100)

SET @IpStoredProcName = 'Rpt_AccountsReceivableAgingSp'

SET @IpParms = '2011-01-31,2011-01-31,,,A,1,,,,,,,,,0,B,1,0,1,1,D,1,0,0,A,12345,I,30,Current,60,31-60,90,61-90,120,91-120,999,Over 120,Site1,1,1'

SET @IpFileName = 'c:\temp\test1tt.txt'

/* Other Variables */

DECLARE @OpParms...

This will work just fine.

But i would like to create the indexes as well.