Coldfusion calling DTS

[surenr]

Do any one know how call Data Transformation Services using coldfusion?I need
to transform a CSV file into a the Database table.Any kind of information or
resourses will be of great help.
thnx in advance.
surenr_15

[Mountain Lover]

[url]http://cfregex.com/cfcomet/SQL_Server/index.cfm?ArticleID=A51CB8F7-C297-4E80-92CC7A8907B0A5B2[/url]

HTH

--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[surenr]

I had plugged the code in the below link, the system can recognize the DTS
package but the package is not being executed.


[url]http://cfregex.com/cfcomet/SQL_Server/index.cfm?ArticleID=A51CB8F7-C297-4E80-92C[/url]
C7A8907B0A5B2

Do anyone know what must be the problem?any other solutions for Coldfusion to
call DTS. Any kind of feedback is valuable.
Thnx in advance.

[Mr Black]

Just use BULK INSERT statement from <CFQUERY>.

[MikerRoo]

Wow Tim,

That code rocks! I had no trouble implementing it.

surenr,
If you can't get the COM call to work, you can always use <cfexecute> to run dtsrun.exe.

Good luck,
-- MikeR

[surenr]

I tried calling DTS using Coldfusion and it did work ( I used bulk insert in my
DTS package). Now I realised that we have to upload the file into the server
before we run DTS.Is there any other means where I can read the text file
directly from my Desktop, rather than first upload it into the coldfusion
server?

[Mr Black]

Unfortunately, magic is not possible. You must have file available (to SQL Server - not CF server), if you want to load it into your database.