Link to home
Start Free TrialLog in
Avatar of compdigit44
compdigit44

asked on

SQL 2000 DTS Problems

I'm using Sql 200 Ent .I used the IMport / Export wizard to export a table to a CSV file but selected the option to "Drop and Receate" the rows each time. In Design Package I don't see this selection that I make listed any where.. Please help
Avatar of SQL_SERVER_DBA
SQL_SERVER_DBA
Flag of United States of America image

if your exporting as you say "export a table to a CSV file" then there is nothing to drop and recreate. This is only if your importing.
Avatar of compdigit44
compdigit44

ASKER

So the file is over writen each time the job runs then correct?
ASKER CERTIFIED SOLUTION
Avatar of Rajesh_mj
Rajesh_mj
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial