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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-15 : 08:24:53
|
| William writes "I use DTS to load data from CSV files ( which are produced by earlier steps in the same package). I load the files inta stage tables. recently I've noticed that , after the load of a particular file there are zero rows in the target table - but there are records in the file. THe next night they might load. The DTS is scheduled as a job. Anytime I execute the Package directly it works fine .I have now idea whats happening ? SQL Server V7." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-15 : 14:21:17
|
| Does the SQL service have access to the file that isn't working?Tara |
 |
|
|
|
|
|
DTS ocassionally dosn't load data from file.csv