Data transformation services migration problem

I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
I want to do some migrations and tried to migrate Data Transformations.
In Legacy I choose " Data Transformation Services" and rightclick on
"migration wizard"
Everything looks fine and the wizard is telling me verything was ok.
But now I cannot find the new migrated files'
Where can I find these?
Hans"Hans" <info@.tct.nl> wrote in message
news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
> I want to do some migrations and tried to migrate Data Transformations.
> In Legacy I choose " Data Transformation Services" and rightclick on
> "migration wizard"
> Everything looks fine and the wizard is telling me verything was ok.
> But now I cannot find the new migrated files'
> Where can I find these?
> Hans
>
Hi
Have you tried backing up the databases and restoring them on the new
server? Check out http://support.microsoft.com/kb/314546
John|||The tables have been copied, no problem, but the Data Transformations does
not work. I also cannot create new data transformations like I did in
SQL2000
Hans
"John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
> "Hans" <info@.tct.nl> wrote in message
> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
>>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
>> I want to do some migrations and tried to migrate Data Transformations.
>> In Legacy I choose " Data Transformation Services" and rightclick on
>> "migration wizard"
>> Everything looks fine and the wizard is telling me verything was ok.
>> But now I cannot find the new migrated files'
>> Where can I find these?
>> Hans
> Hi
> Have you tried backing up the databases and restoring them on the new
> server? Check out http://support.microsoft.com/kb/314546
> John
>|||"Hans" <info@.tct.nl> wrote in message
news:48083b38$0$14782$ba620dc5@.text.nova.planet.nl...
> The tables have been copied, no problem, but the Data Transformations does
> not work. I also cannot create new data transformations like I did in
> SQL2000
> Hans
> "John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
> news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
>> "Hans" <info@.tct.nl> wrote in message
>> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
>>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
>> I want to do some migrations and tried to migrate Data Transformations.
>> In Legacy I choose " Data Transformation Services" and rightclick on
>> "migration wizard"
>> Everything looks fine and the wizard is telling me verything was ok.
>> But now I cannot find the new migrated files'
>> Where can I find these?
>> Hans
>> Hi
>> Have you tried backing up the databases and restoring them on the new
>> server? Check out http://support.microsoft.com/kb/314546
>> John
Hi
In SQL 2005 (which comes with SBS 2003 R2) you should use SSIS rather than
DTS. These may help answer some of your questions
http://msdn2.microsoft.com/en-us/library/ms345120.aspx
http://msdn2.microsoft.com/en-us/library/ms143706.aspx
John|||Where can I find SSIS program?
Or do you mean that VB .NET ? But that's very complicated for a simple user.
What I still don't understand is:
The migration wizard imports the DTS into the SQL 2005, but I cannot find it
anywhere in the databases? Where is this saved and where can I open the
imported files?
Hans
"John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
news:%23%23Qke8SoIHA.420@.TK2MSFTNGP02.phx.gbl...
> "Hans" <info@.tct.nl> wrote in message
> news:48083b38$0$14782$ba620dc5@.text.nova.planet.nl...
>> The tables have been copied, no problem, but the Data Transformations
>> does not work. I also cannot create new data transformations like I did
>> in SQL2000
>> Hans
>> "John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
>> news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
>> "Hans" <info@.tct.nl> wrote in message
>> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
>>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
>> I want to do some migrations and tried to migrate Data Transformations.
>> In Legacy I choose " Data Transformation Services" and rightclick on
>> "migration wizard"
>> Everything looks fine and the wizard is telling me verything was ok.
>> But now I cannot find the new migrated files'
>> Where can I find these?
>> Hans
>> Hi
>> Have you tried backing up the databases and restoring them on the new
>> server? Check out http://support.microsoft.com/kb/314546
>> John
> Hi
> In SQL 2005 (which comes with SBS 2003 R2) you should use SSIS rather
> than DTS. These may help answer some of your questions
> http://msdn2.microsoft.com/en-us/library/ms345120.aspx
> http://msdn2.microsoft.com/en-us/library/ms143706.aspx
> John
>|||"Hans" wrote:
> Where can I find SSIS program?
> Or do you mean that VB .NET ? But that's very complicated for a simple user.
> What I still don't understand is:
> The migration wizard imports the DTS into the SQL 2005, but I cannot find it
> anywhere in the databases? Where is this saved and where can I open the
> imported files?
> Hans
>
> "John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
> news:%23%23Qke8SoIHA.420@.TK2MSFTNGP02.phx.gbl...
> >
> > "Hans" <info@.tct.nl> wrote in message
> > news:48083b38$0$14782$ba620dc5@.text.nova.planet.nl...
> >> The tables have been copied, no problem, but the Data Transformations
> >> does not work. I also cannot create new data transformations like I did
> >> in SQL2000
> >>
> >> Hans
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> schreef in bericht
> >> news:eTMLA1$nIHA.4848@.TK2MSFTNGP05.phx.gbl...
> >>
> >> "Hans" <info@.tct.nl> wrote in message
> >> news:48061e52$0$25482$ba620dc5@.text.nova.planet.nl...
> >>I have now SBS 2003 with SQL. I had a SBS2000 with SQL.
> >> I want to do some migrations and tried to migrate Data Transformations.
> >>
> >> In Legacy I choose " Data Transformation Services" and rightclick on
> >> "migration wizard"
> >> Everything looks fine and the wizard is telling me verything was ok.
> >>
> >> But now I cannot find the new migrated files'
> >> Where can I find these?
> >>
> >> Hans
> >>
> >> Hi
> >>
> >> Have you tried backing up the databases and restoring them on the new
> >> server? Check out http://support.microsoft.com/kb/314546
> >>
> >> John
> >>
> > Hi
> >
> > In SQL 2005 (which comes with SBS 2003 R2) you should use SSIS rather
> > than DTS. These may help answer some of your questions
> > http://msdn2.microsoft.com/en-us/library/ms345120.aspx
> > http://msdn2.microsoft.com/en-us/library/ms143706.aspx
> >
> > John
> >
Hi
Migrated DTS packages will be under the Management\Legacy\Data
Transformation Services See
http://technet.microsoft.com/en-us/library/ms143706.aspx
You should aim to re-write the packages in SSIS (integration services) to
take advantage of the new system. To write a new package you will have to
use BIDS (SQL Server Business Intelligence Development Studio) and create an
Integration Services Project. More information about this can be found in
Books Online also check out http://www.sqlis.com/ and the videos on
http://www.jumpstarttv.com/Channel.aspx?cat=c871236d-8554-42e3-8683-4d422356c0bd
John