• OR execute BCP right from a scheduled SQL Agent job. Here's a similar script I've used for a CSV file (you can change it for tab delimited use):

    declare @cmd varchar(1000)

    set @cmd =

    'bcp AdventureWorks.dbo.mytest in "C:\test.csv" -t "," -r -c -q -S MYSERVER -T'

    exec xp_cmdshell @cmd

    _________________________________
    seth delconte
    http://sqlkeys.com