Problems executing stored procedures from DTS

#1

We are importing a lot of data from text files to our SQL Server
tables. We use DTS's to achieve this. After many problems, and a lot
of frustration, the DTS's seem to be working fine, except that now
some stored procedures behave differently when executed from the DTS
vs when we execute them from Query Analyser.

Any tips??? Please help!

tnx

#2

What do you mean by differently? Could you give us one example?

"Joca" <jjone99 (AT) hotmail (DOT) com> wrote

Quote:

We are importing a lot of data from text files to our SQL Server
tables. We use DTS's to achieve this. After many problems, and a lot
of frustration, the DTS's seem to be working fine, except that now
some stored procedures behave differently when executed from the DTS
vs when we execute them from Query Analyser.

Any tips??? Please help!

tnx

#3

They shouldn't execute any differently.

Example ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Joca" <jjone99 (AT) hotmail (DOT) com> wrote

Quote:

We are importing a lot of data from text files to our SQL Server
tables. We use DTS's to achieve this. After many problems, and a lot
of frustration, the DTS's seem to be working fine, except that now
some stored procedures behave differently when executed from the DTS
vs when we execute them from Query Analyser.

Any tips??? Please help!

tnx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Problems executing stored procedures from DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Problems executing stored procedures from DTS - 07-11-2003 , 08:34 AM

Re: Problems executing stored procedures from DTS - 07-11-2003 , 08:38 AM

Re: Problems executing stored procedures from DTS - 07-11-2003 , 08:40 AM