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 |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2004-02-12 : 10:07:33
|
| Hi,I have a Dts package with a transform data task.This task pulls data from table(s) in one database to another sql server database which is on an other SQL Server. This pkg is scheduled as a job. The job ran fine, the job history shows the data moved etc.. but when i look at the destination table there are no rows.How can this happen, the source and destination are sql server databases.RamdasRamdas NarayananSQL Server DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-13 : 12:19:50
|
| Have you tried rebuilding the DTS package? I have found that it sometimes loses its mind and just needs to be rebuilt. It happened to me just this week. No changes were made and it just stopped working. So I rebuilt the problem task and all is fine now.Anyway, why are you using DTS for this?Why not use bcp.exe or even INSERT INTO SELECT?Tara |
 |
|
|
|
|
|
Strange Problem With DTS