na servere ne rabotaet DTS ,ishy lyshshii spocob kak eto cdelat" ISQL ili OSQL


Glory predloshil takoi variant export to text file ,

1-ый варинт
DECLARE @result int

EXEC @result = master..xp_cmdshell 'osql -S MYSQLSERVER -E -Q "SELECT TOP 10 * FROM pubs.dbo.authors" -b -o c:\myoutput.txt', no_output
IF (@result = 0)
PRINT 'Success'
ELSE
PRINT 'Failure'

a kak mne v query "SELECT TOP 10 * FROM pubs.dbo.authors"

napisat" : " SELECT TOP 10 * FROM pubs.dbo.authors
where datecreted < '20020901 00:00:00 ' "

ia imey v vidy kavichki zdec" : '20020901 00:00:00 '
i eshe mne nado razdelitel" ykazat" i header

pocovetyite pls !