exec stored proc from dts package -- sql server programming

azie76
7/18/2005 8:18:01 PM

hi all,
i had a problem to process a sql query. when the query is executed from a vb
command (vb program), it takes a long time and sometimes it terminates the
program by giving 'runtime error'.

now, i tried to put the query in a stored proc. the stored proc now is
executed by a dts package whereas the dts package is executed by the vb
command. the idea here is to have the query running directly on the SQL
server to avoid shorten the query time. but the problem now time taken is
even longer than before.
any great ideas to help?

thanks.

Uri Dimant
7/19/2005 12:00:00 AM

Hi
If the query thrown run-time error it does not relate to performance
issue. First you will have to fix the problem and start to optimize the
query

Yes, putting query into a stored procedure will improve the perfomance but I
don't undesrtand why it should be ran by dts? Actually in terms of
performance it does not matter and you will have to investigate if you
have a proper indexes defined on the tables and if the optimizer is
available to use them.

I'd run SQL Server Profile to see what is going on.

[quoted text, click to view]

sql server programming : exec stored proc from dts package