Hello All: I need some help please!
Im using a couple of neat stored procedures to call a DTS package and write the output to a UNC path. My issue is that it only works when I output to my local SQL server hard drive or output to the UNC path by executing the DTS package from my SQL server Enterprise Manager. If I try to execute the CFSTOREDPROC from my CF server that goes to the UNC path a get an error from the SQL server. All permissions have been set to gives the 3 machines rights for read and write access. Any Ideas? Regards, James Blaha These are the stored procs. http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS <CFSTOREDPROC PROCEDURE="spExecuteDTS" DATASOURCE="xx" debug="YES" returnCode = "Yes"> <cfprocresult name="importData"> <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname= "@Server" value= "mySqlServer" null="no"> <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname= "@PkgName" value= "DTS_HR" null="NO"> <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ServerPWD" value="xx" null="NO"> <!--- Note: If you ran this with a local SA account you will need the line below. ---> <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@IntSecurity" value="1" null="NO"> </CFSTOREDPROC> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89 70.4
