dbTalk Databases Forums  

execute pkg

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


Discuss execute pkg in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JFB
 
Posts: n/a

Default execute pkg - 01-03-2005 , 01:43 PM






Hi All,
I want to execute a package from a server that I dont have install sql using
coldfusion page.
What files can I include in this server so I can execute this package?
<CFEXECUTE name="c:\program files\microsoft sql
server\80\tools\binn\dtsrun.exe" arguments="#sArg#" timeout="1800"/>
Tks in advance
JFB



Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: execute pkg - 01-03-2005 , 02:19 PM






Have a look here

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"JFB" <jfb (AT) newSQL (DOT) com> wrote

Quote:
Hi All,
I want to execute a package from a server that I dont have install sql using coldfusion page.
What files can I include in this server so I can execute this package?
CFEXECUTE name="c:\program files\microsoft sql server\80\tools\binn\dtsrun.exe" arguments="#sArg#" timeout="1800"/
Tks in advance
JFB





Reply With Quote
  #3  
Old   
JFB
 
Posts: n/a

Default Re: execute pkg - 01-03-2005 , 03:31 PM



Tks for you reply and help Allan,
Can I put all this files in one folder, register the dll?
Or I need to create the same folder names?
JFB

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

Quote:
Have a look here

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"JFB" <jfb (AT) newSQL (DOT) com> wrote in message
news:%23NOE2xc8EHA.3616 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
Hi All,
I want to execute a package from a server that I dont have install sql
using coldfusion page.
What files can I include in this server so I can execute this package?
CFEXECUTE name="c:\program files\microsoft sql
server\80\tools\binn\dtsrun.exe" arguments="#sArg#" timeout="1800"/
Tks in advance
JFB







Reply With Quote
  #4  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: execute pkg - 01-03-2005 , 03:47 PM



Ideally you create the folder structure as per an installation of SQL Server.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"JFB" <jfb (AT) newSQL (DOT) com> wrote

Quote:
Tks for you reply and help Allan,
Can I put all this files in one folder, register the dll?
Or I need to create the same folder names?
JFB

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

Have a look here

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"JFB" <jfb (AT) newSQL (DOT) com> wrote

Hi All,
I want to execute a package from a server that I dont have install sql using coldfusion page.
What files can I include in this server so I can execute this package?
CFEXECUTE name="c:\program files\microsoft sql server\80\tools\binn\dtsrun.exe" arguments="#sArg#" timeout="1800"/
Tks in advance
JFB









Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.