April 22, 2008 at 10:56 am
Hi,
I am currently migrating many database from SQL 2000 (32bit) to SQL 2005 (64bit). We do not intend to do the DTS packages just yet so I am loading these onto a remote SQL 2000 server, updating the connections and saving onto the 64bit SQL 2005 server.
In the past I have created an SSIS wrapper with an "Execute SQL 2000 DTS" task. And then added the job step as follows
"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /FILE "c:\packagename.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E
However, I would like to run the package as is without all the SSIS work involved using something like
DTSRUN /S ServerName /E /N "PackageName"
My question, will this work in a SQL 2005 64bit environment? All material out there seems somewhat confusing with regards to 64bit
Mnay Thanks in Advance
April 22, 2008 at 4:59 pm
It will work if you install the DTS 2000 runtime on the 64-bit server. It's part of the "Microsoft SQL Server 2005 Backward Compatibility Components" download at http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en. It runs in 32-bit mode.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply