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 |
|
freesoul
Starting Member
35 Posts |
 Posted - 2007-08-14 : 12:46:39
|
| I changed the UID before migrating in the DTS and then migrated it but after Migrating the UID was as it was earlier in the DTS and was not the changed one ....I am unaable to find out how it is happening ???anybody having a clue to it ...please shed some light |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-14 : 22:44:44
|
| Migrate dts packages to ssis? Can be more specific? |
 |
|
|
freesoul
Starting Member
35 Posts |
Posted - 2007-08-16 : 06:28:11
|
| For DTS when we disconnect edit a DTS package we can change the connection properties , I also changed one connection proerty from one login to another , changing the password as well...then i saved it and imported that DTS to SQL Server 2005 ........ after that i went to the Management --> Legacy --> DTS , from there i migrated this DTS package to SSIS .... now after migrating this package , i thought of running the package to make sure it is working fine .....but when i click on the option RUN PACKAGE i can see the "Connection Properties" tab .....there the UID have not changed at all and is still the one which was there before modified and not the one which i have changed it to ...how's it possible ...... and how can i check this thing ? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-16 : 23:16:54
|
| Did you double check saved package in sql2k? |
|
|
|
freesoul
Starting Member
35 Posts |
Posted - 2007-08-17 : 03:09:17
|
| Yes First time i thought like this only but then i checked and imported the DTS again ...but again no change ..... same problem ...... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-18 : 00:28:44
|
| Tried delete previous versions of the package then migrate? |
|
|
|
freesoul
Starting Member
35 Posts |
Posted - 2007-08-27 : 06:33:30
|
| Tried that , worked for one but still having problem wid others ...clueless abt why its happening ?? |
|
|
|
|
|
|
UID not changing after migration