sql server - Bulk Insert from sqlcmd not firing trigger -
i'm using sqlcmd
in batch file weekly imports.
sqlcmd -u xxxx -p xxxx -i e:\data\importtc.sql
the command executing,
bulk insert [xxxx].[dbo].[stage] 'e:\acct\timecards\timecard.txt' (fieldterminator = ',', rowterminator = '\n', fire_triggers) go
from inside sql server management studio, works fine. when exec sqlcmd
won't fire trigger manipulates of data.
anyone encountered before? thank you.
Comments
Post a Comment