If you want a package, drop your sql server object on your design, then a text file object, and link them with a 'transform data task' connector. Create your query in the connector and you're set



-----Original Message-----
From: Benbart [mailto:mssqldba-ezmlmshield-x21742079.[Email address protected]
Sent: Friday, May 27, 2005 03:53 AM
To: LazyDBA Discussion
Subject: DTS Package to get the output of SQL to a file

Hi all,
Can anyone tell me how to create a DTS package to sent the output of a SQL statement to a file? For example, I want to get the result set of SELECT * FROM TITLES to a file ...
Thanks in advance



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page