Skip to main content
L
Lei_Hu
Known Participant
January 28, 2009
Question

code for command line

  • January 28, 2009
  • 3 replies
  • 1519 views
Hello everyone,
I have a SQL SSIS package that I would like to trigger through Cold fusion. I looked into SQL help, it said that using "dtexec" at command line will work. My question is: how do I get Cold Fusion do a command line job? What is the sytext/code for that?

Thanks in advance.
    This topic has been closed for replies.

    3 replies

    F
    Fetch
    Participating Frequently
    January 28, 2009
    Also, keep in mind that this probably won't work on a shared webhost since CFExecute is often disabled for security reasons (and rightly so).
    J
    JR__Bob__Dobbs-qSBHQ2
    Inspiring
    January 28, 2009
    Try the cfexecute tag.
    L
    Lei_HuAuthor
    Known Participant
    January 28, 2009
    Thanks a lot for your suggestions.
    I was looking for <cfexecute> in the Help inside Dreamweaver. I could not find it. I am going to the online tutorial on Adobe site, hopefully I will find some coding example. Will let you know if it works out.

    For some reason, on this forum, the "Search" function has not beening since early this afternoon. every time an error message would come up. Otherwise I could search for <cfexecute> on the forum.
    F
    Fetch
    Participating Frequently
    January 28, 2009
    Here's a Forta example, though a little dated:

    http://www.forta.com/blog/index.cfm/2006/7/31/Using-CFEXECUTE-To-Execute-Command-Line-Utilities
    N
    Newsgroup_User
    Inspiring
    January 28, 2009
    Lei Hu wrote:
    > Hello everyone,
    > I have a SQL SSIS package that I would like to trigger through Cold fusion.
    > I looked into SQL help, it said that using "dtexec" at command line will work.
    > My question is: how do I get Cold Fusion do a command line job? What is the
    > sytext/code for that?
    >
    > Thanks in advance.
    >

    The <cfexecute...> tag allows ColdFusion to run command line code. It
    can take a lot of trial and error to get that to work properly. User
    permissions of the ColdFusion server standard output versus standard
    error, version of ColdFusion are all potential hickups with this type of
    code.

    Take it slow, one step at the time is the best advice I can give you for
    using <cfexecute...>.

    Ian
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices