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
