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 |
|
svicky9
Posting Yak Master
232 Posts |
 Posted - 2007-10-17 : 06:40:35
|
| Have anyone tried installing the DTS Designer 2000 Components in 64 Bit EnvironmentVic |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-10-17 : 12:17:30
|
| I dont think its supported on 64 bit server.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-10-17 : 13:42:48
|
| DTS designer is supported in x64.-ec |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-10-17 : 14:06:55
|
quote:
Originally posted by eyechart
DTS designer is supported in x64.-ec
you mean on 2005 server?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-10-17 : 16:09:34
|
quote:
Originally posted by dinakaryou mean on 2005 server?
ok, I see what the original question is. the DTS runtime components are x64, so DTS packages can run on SQL2K5 64bit. The design components are only x86. You would install the design components on your workstation and be able to modify DTS packages that reside on your SQL2K5 x64 system.-ec |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2007-10-18 : 04:52:13
|
| thanks for that...One more question i am trying to run a dts package by using the DTSEXEC i get the error as the specified module cannot be found and some OLEDB ErrorsThe errors are as follows Could Not Load Package "MIS_XLS_ESOutputMonthly" because of error 0xC00100AThe specified package could not be loaded on the SQL SERVER DatabaseThe package does exists...Any RecommendationsVic |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-19 : 23:36:53
|
| Tried with dtsrun? |
|
|
|
|
|
|
DTS Designer in 64 Bit Version