Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itsonlyme4
Posting Yak Master
109 Posts |
 Posted - 2010-08-06 : 09:31:15
|
| This has probably been answered before.. but I've googled this to death and it is still very confusing to me. Here is my scenerio. I have a sql server 2005 on a 32 bit platform and we run about 20 DTS packages in backward compatibility mode.. in other words, the DTS packages show up under the LEGACY tab in Management Studio and they all run fine. Now we are migrating to a SQL Server 2005 Server on 64 bit platform. What are the steps that need to happen to get these DTS packages migrated to and running on the new 64bit Server?? |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-07 : 08:06:59
|
| If you set a job to run particular DTSX package, you can checkbox 32bit|64bit platform under which job was created.I've tried it three times and each time worked perfectly. |
 |
|
|
|
|
|
Migrating DTS packages 32 bit to 64bit