Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andyjaar
Starting Member
8 Posts |
 Posted - 2006-02-27 : 12:48:07
|
| Hi,I have an application that would massively benefit from the ability to create a DTS package using ColdFusion, or by calling a Stored Proc from ColdFusion which sets up the DTS package. The DTS package would just be creating a CSV file from a given query on a given interval.Will it be a nightmare to do this in comparison to getting ColdFusion or Java to just query the DB and then create a CSV itself. It would be nice to make use of the DTS functionality that is already there if it isnt going to take 10 times longer.Thanks for any helpAndy Hall. |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-02-27 : 16:50:46
|
| What do u want to be done?To run a DTS package from an outside program like ColdFusion?To create a Stored procedutre to create a CSV file and run it by calling from ColdFusion?U want to create a DTS to create CSV files in a pre-scheduled time?or something else? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-27 : 17:05:38
|
| If you create the package in Enterprise Manager, then do a save as and save it as a VB file, you can then see the SQL DMO code that you can use in your application. You could also execute a DTS package from your application, but that wouldn't be recommended.Tara Kizeraka tduggan |
|
|
|
andyjaar
Starting Member
8 Posts |
Posted - 2006-02-28 : 05:17:06
|
| Hi, Sorry if I was unclear, I could go with either:1. Create a DTS to create CSV files in a pre-scheduled time.I would want to do this from ColdFusion, or get a StoredProc to do it and call the SP from ColdFusion. The VB option looks possible but could take some time to set up.2. Create a Stored Proc to create the CSV fileI can then call the stored proc from a scheduled ColdFusion task.Thanks for your help. |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-02-28 : 08:31:16
|
| 1. DTS can be created using Enterprise Manager. I don't know how to "Create" it from ColdFusion. Its a one time thing and it doesn't nececessarily need to be run / scheduled to run by ColdFusion. It can be scheduled to run from the task scheduling of SQL Server - Enterprise Manager2. Stored procedure also can be created / scheduled to run by Query Analyzer / Enterprise Manager If u want u can run the stored procedure from a front end tool like ColdFusion, but I'm not good in ColdFusion to explain how to do it. First select what do u need to do.Then read on that (May be Books On Line) and start doing it urself.If u comeup with issues, which u cannot resolve, ask from us |
|
|
|
|
|
|
Creating DTS packages without wizard