Re: Execute DTS package from remote VB application

#1

You can fire a job on the server
You can use sp_OA*

See here

Execution
(http://www.sqldts.com/default.aspx?104)

--

----------------------------
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

"HawkPilot" <hawk_pilot (AT) hotmail (DOT) com> wrote

Quote:

Hi,

I'm fairly new to DTS programming and I am facing this:

I have created a DTS package that uses an ODBC driver to import data into
an
SQL2K DB.
I developed a VB6 app that runs the package and I installed on a client PC
that does not have the ODBC driver installed.
When I try to execute the VB6 app it fails when it is trying to execute
the
import steps; all other non-import steps are executing fine.

My question is: How do I instruct the DTS package to execute localy on the
server even if I give the command from the client (so the DTS package can
find the ODBC driver which is installed on the server)?

Thanks in advance

#2

Thank you for your answer.

The sp_OA* aproach seems too complicated for me. What I did was to create an
sp running the DTS package through xp_cmdshell. Running the sp solves the
problem. Do you think that this aproach is rising security issues - having
to execute the xp_cmdshell which is considered a bad thing

??

HP

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

You can fire a job on the server
You can use sp_OA*

See here

Execution
(http://www.sqldts.com/default.aspx?104)

--

----------------------------
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

"HawkPilot" <hawk_pilot (AT) hotmail (DOT) com> wrote in message
news:eW0qGzrcDHA.616 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
Hi,

I'm fairly new to DTS programming and I am facing this:

I have created a DTS package that uses an ODBC driver to import data
into
an
SQL2K DB.
I developed a VB6 app that runs the package and I installed on a client
PC
that does not have the ODBC driver installed.
When I try to execute the VB6 app it fails when it is trying to execute
the
import steps; all other non-import steps are executing fine.

My question is: How do I instruct the DTS package to execute localy on
the
server even if I give the command from the client (so the DTS package
can
find the ODBC driver which is installed on the server)?

Thanks in advance

#3

Allowing users permission to execute xp_cmdshell is generally considered a
bad thing yes. Mind you no more so I guess than sp_OA*. Of course it can
only be executed by Users on the server.

--

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

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

Re: Execute DTS package from remote VB application

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

Re: Execute DTS package from remote VB application - 09-04-2003 , 03:37 AM

Re: Execute DTS package from remote VB application - 09-05-2003 , 01:29 AM

Re: Execute DTS package from remote VB application - 09-05-2003 , 01:55 AM