cfexcute

Forum|Forum|17 years ago
August 5, 2008
15 replies
2005 views

The following doesnt copy the data from csv into db table... why? Any help appreciated...My CF and SQL server are on my local machine.

Advanced techniques

This topic has been closed for replies.

Show previous replies

E

emmim44Author

Inspiring

Still same error:
<cfset saves = "Saves">
<cfloop index="i" list="#saves#">
<cfscript>
targ = structNew();

targ.Exe = "c:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsrun.exe";
targ.server = "NYCWSITSSALEEM";
targ.verBase= "30";
</cfscript>

<cfexecute name = "#targ.Exe#"
arguments = "/S #targ.server# /N C:/Documents and Settings/vozturk/My Documents/scorecard_30_import_saves.dtsx /U cf_user /P 1 /A DateToUse:8=#DateFormat(now(), 'MM/DD/YYYY')#"
timeOut = "300">
</cfexecute>
</cfloop>

K

Kronin555

Participating Frequently

You also need to be sure that the user that ColdFusion is running under can see that file.

What user is ColdFusion running as? Can that user see that file?

E

emmim44Author

Inspiring

<cfset saves = "Saves">
<cfloop index="i" list="#saves#">
it is saved on my document folder as 'scorecard_30_import_saves'
Still same error...help

K

Kronin555

Participating Frequently

Give it a full path to that file. You also need to be sure that the user that ColdFusion is running under can see that file.

E

emmim44Author

Inspiring

The new error is :
DTSRun: Loading... Error: -2147217900 (80040E14); Provider Error: 14262 (37B6) Error string: The specified DTS Package ('Name = 'scorecard_30_import_Saves'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0

K

Kronin555

Participating Frequently

So I ask again:
Where is the file "scorecard_30_import_Saves" located?

This line of code:
<cfloop index="i" list="Saves">
loops over a list. However, if "Saves" is a variable containing a list, you need to enclose it in pound signs:
<cfloop index="i" list="#Saves#">
Without the pound signs, ColdFusion thinks you're passing the string "Saves" in as the list, which, as a comma-delimited list, only contains one element, "Saves".

D

Daverms

Inspiring

Hi,

Did you encounter any errors?... Have you checked the application logs?...

K

Kronin555

Participating Frequently

Where is the file "scorecard_30_import_Saves" located?