Sunday, February 26, 2012

DTS migration from ss2000 --> ss2005

hi,
I'm planning to move my existing DTS that I've made in ss2000 to ss2005.
At this moment I'm not planning to migrate existing DTS to SSIS, I
just want to use backward compatibility for now.
What's the "best practice" technique for moving ss2000 DTS --> ss2005?
ThanksPablo
Right Click on Data Transformation Services and choose Migration Wizard
"Pablo Cognito" <pcognito@.gmail.com> wrote in message
news:uXs7OOJDHHA.3660@.TK2MSFTNGP02.phx.gbl...
> hi,
> I'm planning to move my existing DTS that I've made in ss2000 to ss2005.
> At this moment I'm not planning to migrate existing DTS to SSIS, I just
> want to use backward compatibility for now.
> What's the "best practice" technique for moving ss2000 DTS --> ss2005?
> Thanks|||Sorry, firstly save the DTS as stucture storage file
secondly Right Click on Data Transformation Services and choose Import
Package File option
choose Import option
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OMMOegJDHHA.3492@.TK2MSFTNGP06.phx.gbl...
> Pablo
> Right Click on Data Transformation Services and choose Migration Wizard
>
> "Pablo Cognito" <pcognito@.gmail.com> wrote in message
> news:uXs7OOJDHHA.3660@.TK2MSFTNGP02.phx.gbl...
>> hi,
>> I'm planning to move my existing DTS that I've made in ss2000 to ss2005.
>> At this moment I'm not planning to migrate existing DTS to SSIS, I just
>> want to use backward compatibility for now.
>> What's the "best practice" technique for moving ss2000 DTS --> ss2005?
>> Thanks
>

No comments:

Post a Comment