Re: How to create files/folders

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 04/22/04 

Date: Thu, 22 Apr 2004 07:11:04 -0500

One method is to create a DTS package that you can launch with DTSRUN via
xp_cmdshell. You can pass global variable values to the package (e.g.
server name and path) as with command-line arguments.

See www.sqldts.com for DTS examples and tutorials. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"kamal" <anonymous@discussions.microsoft.com> wrote in message
news:29fb01c42860$89cde4c0$a601280a@phx.gbl...
> I need to create a file(Path) and Need to transform one or
> more table data into that text file. from stored procedure
>
> Any article or solution regarding thanks in advance

Relevant Pages

  • Re: "Failed" Job runs DTS package
    ... pulls new data from a database on a different server. ... Now the DTS Package completes, but the Job says it failed. ... DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: ... DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: ...
    (microsoft.public.sqlserver.dts)
  • Wrong pathname in logfile of scheduled DTS package
    ... I have a scheduled DTS package that transfers data from a table to a flat ... When the DTS package was first created the file was put on a server, ... DTSRun OnProgress: Copy Data from Results to \\serverA\... ...
    (microsoft.public.sqlserver.dts)
  • Re: dts / com objects
    ... Do you have the COM object registered on the server? ... > run the dts package from within sql server(either within the dts package, ... > or by right clicking execute), but when I execute from the dtsrun command ... > either in a dos window, or in the sql scheduler, I get a dts/vbScript ...
    (microsoft.public.sqlserver.dts)
  • Re: Launch DTS Package using preferred resources
    ... > run using the resources of the remote machine. ... >DTS Package remotely and have it use the resources of the server? ... You need to launch it on the server to get it to execute there. ...
    (microsoft.public.sqlserver.dts)
  • Re: Wrong pathname in logfile of scheduled DTS package
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I have a scheduled DTS package that transfers data from a table to a flat file every night. ... > When I now look in the Output file the path there is the old path, ... > DTSRun: Executing... ...
    (microsoft.public.sqlserver.dts)