Moving a DTS package to SQL Server 2008

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  June 17, 2010 at 10:21 am

  #220201

  Hi,

  We have a DTS package in SQL Server 2005 32 bit and it's running fine. Now I moved the DTS package to SQL Server 2008 64 bit as below:

  On Server A, Open the DTS package->Save As->then select the Source SQL Server instance on Server B->click OK.

  Then the DTS package has appread under SQL Server 2008's Data Transfermation Services.

  After Migrating the DTS package, there is job to run the DTS package to import data from a file located in D drive as below:

  dtsrun /S SQL1 /E /N import /A gstrServer:8=SQL1 /A gstrClient:8=CF /A gstrEnvironment:8=QA /A gstrPath:8="d:\"

  When run this job, I'm getting the below error:

  Executed as user: abc\dba. The process could not be created for step 1 of job 0xB46A6C3674357945AB89A9ED632E203F (reason: The system cannot find the file specified). The step failed.

  and then I tried to delete the DTS package and I'm getting the below error:

  TITLE: Open DTS 2000 Package

  ------------------------------

  Retrieving the COM class factory for component with CLSID {10030000-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error: 80040154. (Microsoft.SqlServer.DtsObjectExplorerUI)

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

  Please advice..

  Thanks

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  June 17, 2010 at 11:41 am

  #1181756

  This is worked after performing the following:

  Install SQLServer2005_BC_x64.msi after installing SQL Server 2008 x64.

  While installing SQLServer2005_BC_x64.msi, just select the 1st option "Data Transformation Services 2000 runtime"

  even though the MS link http://msdn.microsoft.com/en-us/library/ms143755.aspx

  says that DTS packages are NOT fully supported on 64 bit environment of SQL Server 2008, mine is working fine..

  Please correct me if I misunderstood the information from MS link;-);-)

  Thanks

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  July 13, 2010 at 1:31 am

  #1191819

  Could you please share your inputs about this..

  Thanks

• sundara

  Valued Member

  Points: 59

  More actions

  November 8, 2011 at 10:53 am

  #1404726

  Thanks . This worked..4 me.