am rezolvat-o astfel:

un script bat folosind bcp pus apoi in schedule task si utilizand de asemenea un trigger:

SET DAY=%DATE:~4,2%
SET MTH=%DATE:~7,2%
SET YR=%DATE:~10,4%
SET HR=%TIME:~0,2%
SET HR0=%TIME:~0,1%
IF "%HR0%"==" " SET HR=0%TIME:~1,1%
SET MIN=%TIME:~3,2%
SET SEC=%TIME:~6,2%
SET MYDATE=%YR%%MTH%%DAY%-%HR%%MIN%%SEC%

bcp "select rtrim(companyname)+'#'+rtrim(t) from q.dbo.customers" queryout c:\export_%MYDATE%.txt -S instanta -U username -P pass-c

multumesc