Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pearsont74
Starting Member
27 Posts |
 Posted - 2006-07-10 : 16:13:23
|
| ok....im not quite the newbie to SQL but i dont pretent to be any type of guru. i have a dts package to update my db from an access file and my problem is when i run this package it is suppsoed to wipe out the data (truncate) and replace it with the new data. It runs ok but in some cases i get duplicates and other cases the fields do not import correctly. for example, a column thats eitehr 1 or 0 and the import <nulls> everything in that column.Is truncate the correct statement? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-11 : 03:48:12
|
is there a 'truncate' in access? i think it's delete * from tablename, not quite sure, try it on small table in access though --------------------keeping it simple... |
 |
|
|
pearsont74
Starting Member
27 Posts |
Posted - 2006-07-11 : 08:25:44
|
| no...the truncate is to the sql tables before the import of the data from the access file. |
|
|
|
pearsont74
Starting Member
27 Posts |
Posted - 2006-07-12 : 08:47:53
|
| ok....hopefully i get some answers on this...basically we need to wipe out data and reimport every time we do the import...whats the easiest and best way to do this. |
|
|
|
|
|
|
DTS import package