THANK U GUYS FOR YOUR ANSWERS

insert into TEMPORARYTABLE exec sp_executesql @sqlquery

This temporary table will have the definition exactly which is the output of @sqlquery.

LIKE THIS I...

SELECT eno,ename,dname

FROM TABLE5 ,TABLE6 

WHERE EMP.DEPTNO=DEPT.DEPTNO

Instead of above this is the write query

SELECT eno,ename,dname

FROM TABLE5 emp,TABLE6 dept

WHERE EMP.DEPTNO=DEPT.DEPTNO

exec sp_executesql @s-2

when i executed the above statement...

Thanks once again!!

we are using xp_cmd shell to execute the dts.

we will call 15 dts from Stored procedure and some logic is there in sp ,i cant call the dts...

Thanks once again!!

we are using xp_cmd shell to execute the dts.

we will call 15 dts from Stored procedure and some logic is there in sp ,i cant call the dts...

Thanks phillcart for responding..

The error is occuring in server.A message box will be popuped(DTSRUN.EXE ERROR-APPLICATION ERROR,THE MEMORY COULD NOT BE READ).Scheduled calls a stored procedure ,in that stored procedure DTS...

Thanks Richard Kemp..

This is the error which is popuped ,memory is not a problem.we have enough space in server.

We will run this multipel  DTS by using jobs.

dtsrun.exe -...

iam doing from sql query analyzer i didnt get any warning  message , i logged as a administrator...in my system i have only client,,,,

 server is in other place.

I think the user doesn't have write permission on that table.

With out .ldf file, database can't be attached.