 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / April 2008Data 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 >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. [quoted text clipped - 7 lines] > > 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 >>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. [quoted text clipped - 14 lines] > > 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 [quoted text clipped - 20 lines] >> >> 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 >> The tables have been copied, no problem, but the Data Transformations >> does not work. I also cannot create new data transformations like I did [quoted text clipped - 29 lines] > > John > Where can I find SSIS program? > Or do you mean that VB .NET ? But that's very complicated for a simple user. [quoted text clipped - 39 lines] > > > > 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.