I find this very interesting. I working with ASP right now :( and we did the
MS way of running a DTS package, but we would like to make it cleaner by
firing the DTS package from a stored proc. Could you be so kind and give be
a hint on how to fire a DTS package from with in a Stored proc?
TIA
Shawn Regan
Applications Developer
Pacific Technology Solutions
-----Original Message-----
From: McCollough, Alan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 8:53 AM
To: Fusebox
Subject: RE: Executing DTS Packages Via CF
Nah... That's too complex! Besides, it exposes the password directly in the
CF code. Here is how I do it, not that it's a lot better:
It ain't pretty, but here is how I've been doing this:
<!-- /sql/act_exec_dts_import_squid_raw_data.cfm -->
<!---
|| I will start the stored procedure that will fire off the DTS script for
importing the squid raw data into the database.
Take note that all I'm doing is calling the stored proc 'sp_start_job'
within the MSDB table.
Now, within MSDB, I created a ROLE with EXEC permissions for sp_start_job. I
have a SQL login which I use for this purpose, and this login is a member of
the role, and the login is the one I use through CF to invoke this tag.
|| [EMAIL PROTECTED]
||
++> application.msdb_dsn: The ODBC datasource for this app.
||FUSEDOC--->
<cfquery name="act_exec_dts_import_squid_raw_data"
datasource="#application.msdb_dsn#">
EXEC msdb..sp_start_job 'DTS__import_squid_raw_data'
</cfquery>
> -----Original Message-----
> From: Ken Wilson [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 5:26 PM
> To: Fusebox
> Subject: RE: Executing DTS Packages Via CF
>
>
> How about this article titled "Execute SQL Server DTS packages from CF" by
> Simon Horwith from Figleaf:
>
>
> http://www.cfcomet.com/cfcomet/SQL_Server/index.cfm?ArticleID=A51CB8F7-C29
> 7-4E80-92CC7A8907B0A5B2
>
> Ken
>
>
> -----Original Message-----
> From: Marc Funaro [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 9:05 PM
> To: Fusebox
> Subject: OT: Executing DTS Packages Via CF
>
>
> Sorry for the OT... feel free to respond directly to my email address to
> keep the list happy...
>
> I need to know if there's a way to execute DTS packages that reside on a
> Microsoft SQL Server, using ColdFusion. If there is, can anyone point me
> to
> some code examples?
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
