Skip to main content
Microsoft Dynamics GP forum
Suggested answer

SQL Server 2008 with DTS

editSubscribe (0) ShareShare
ReportReport
Posted on by 10,956 UG Leader

This is not a GP related question but since all of us who works on GP also do considerable amount of work in SQL and it's an incredible community where everyone tries to help other. I am asking this question here.

I am following this post  and trying to enable DTS in SQL Server 2008 R2.

but no luck.

0827.png

8360.png

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,002 Super User on at
    RE: SQL Server 2008 with DTS

    Hi Almas,

    I thought DTS was deprecated in SQL 2005 and shouldn't be used anymore.. you're on 2008 and should replace them by SSIS packages going forward.. Those DTS packages must have been inherited from SQL 2000 ?

    As stated in the error message, the migration wizard will only connect to a SQL 2000 or 7.0 server to import DTS packages and convert them possibly in SSIS packages.

    Have you tried to use Visual Studio instead of SSMS to proceed with the import ?

    have you followed those MS instructions ? docs.microsoft.com/.../cc768544(v=sql.100)

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 10,956 UG Leader on at
    RE: SQL Server 2008 with DTS

    Richard,

    It's a new installation, the DTS packages need to be open in designer for small changes.

    DTS packages are from earlier version.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: SQL Server 2008 with DTS

    What version of SQL is your source? Can you create a linked server to that server? There are SSIS packages over there, correct? If you log into the source instance you can see the packages?

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,045 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,570 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans