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 |
|
ranjithkumar2319
Starting Member
9 Posts |
 Posted - 2007-07-25 : 20:43:26
|
| I want to edit and add few more DTS packages to the existing Data migration project. When i tried to do it, I cannot create, edit data transformation tasks in DTS packages. When i create source and destination, i can only map data transformation task between them but i am unable to open properties of the task to apply the transformation, its giving error message.mmc.exe - Application errorThe instruction at "XXXXXXXX" referenced memory at "XXXXXXX". The memory could not be "read".When i execute the existing packages, all are getting executed without any errors, when i try to edit the data transformation task, i get that error.please someone help me in trouble shooting it. Thanks in advance, |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
ranjithkumar2319
Starting Member
9 Posts |
Posted - 2007-07-25 : 21:52:30
|
| eyechart,the link tells me to install service packs.For me it's not that am working for the first time with this version of application, i have created dts packages earlier and did data migration. This error is started suddenly when i tried to edit some of the packages which were created on the same system and with the same sql server 2000. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-25 : 22:44:26
|
| Service pack fixes bugs, you should apply latest one if didn't do that yet. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-07-25 : 23:19:28
|
quote:
Originally posted by ranjithkumar2319
eyechart,the link tells me to install service packs.For me it's not that am working for the first time with this version of application, i have created dts packages earlier and did data migration. This error is started suddenly when i tried to edit some of the packages which were created on the same system and with the same sql server 2000.
how about you try applying the latest service pack and then post back here in this forum if it doesn't work. It isn't like this is the first question like this that I have ever answered.-ec |
|
|
|
ranjithkumar2319
Starting Member
9 Posts |
Posted - 2007-07-27 : 03:27:13
|
| thanks for the information, i will install the service pack first and then i will see how it goes. |
|
|
|
|
|
|
|
|
mmc.exe application error