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 |
|
jayp369
Starting Member
26 Posts |
 Posted - 2007-04-20 : 12:05:44
|
| I have a sales DTS, that runs every night successfully for the last 3 years. But last night the job failed. There are two fields coming over from JDE, in JDE both fields have data, but the transformation only one field had data. Can anyone explain this?Jay |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-20 : 16:48:31
|
| Is it new column? Did you put that column in the package? |
 |
|
|
maevr
Posting Yak Master
169 Posts |
Posted - 2007-04-20 : 19:04:15
|
| Is there any values in the column that is not following your critiera? |
|
|
|
jayp369
Starting Member
26 Posts |
Posted - 2007-04-23 : 11:09:13
|
| NO, it's not a new column and when you preview the data it's there. And there are only 30 records.Jay |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-23 : 15:20:02
|
| You can set profiler trace when run the package to see what's going on. |
|
|
|
jayp369
Starting Member
26 Posts |
Posted - 2007-04-23 : 18:10:54
|
| i try that. tonight and get back too you.Jay |
|
|
|
|
|
|
DTS failed to copy a column