Home Forums SQL Server 7,2000 General How To? -- DTS, Excel, Send Mail Task RE: How To? -- DTS, Excel, Send Mail Task
wildh
SSCarpal Tunnel
Points: 4370
More actions
January 7, 2004 at 3:49 am
#488916
I skin my cat this way - I create a sql task who's connection is the spreadsheet and drop the table and recreate it. eg. drop table err_screwup go create table 'err_screwup' ('user' varchar(30), 'err' decimal (28,8)). Works a treat.