Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Question of the Day for 13 Sep 2005


Question of the Day for 13 Sep 2005

Author
Message
Robert Lomax
Robert Lomax
SSChasing Mays
SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)

Group: General Forum Members
Points: 630 Visits: 14
I could send some Pink Paper to Redmond, this bug shows there is a terrible shortage there.
cliffb
cliffb
Say Hey Kid
Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)

Group: General Forum Members
Points: 713 Visits: 438

That makes no logical sense at all. I'll sign the pink paper if you want. =)





Rudyx - the Doctor
Rudyx - the Doctor
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3707 Visits: 2486
Great question that points out a terrible 'undocumented feature' (bad bug) in 64 bit ...

Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
~pgerrits
~pgerrits
SSC Eights!
SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)

Group: General Forum Members
Points: 999 Visits: 4

Actually, I don't think its a bug per say, its more of I need to get this 64bit edition to market so I can say we support it and I dont care if some of the tools are still 32 bit, DTS being one of them.

The DTS runtime and its designer tools are not available on the 64-bit platform. You can read data from and write data to a 64-bit system from a 32-bit system running DTS, and you can physically store your DTS packages in a 64-bit SQL Server database. But the DTS packages themselves will not run on the 64-bit platform.

In addition to DTS being in 32bit, the 64-bit server must be administered remotely from a 32-bit workstation or server. Most of the tools, such as SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, and all of the Analysis Services utilities are not available on SQL Server 2000 (64-bit).





Rudyx - the Doctor
Rudyx - the Doctor
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3707 Visits: 2486
Thanks ... I stand even more enlightened about 64 bit (never having to research it). Definitely a 'rush to market thing'. I am now more inclided to say 'partial product' (a combinatino of software and vaporware). I'm not knocking things (been a SQL Server DBA since v4.21), just calling it as I see it. After all the price is still 'full' (no discounts for workarounds), so I'd expect 'complete' software for 'full' price.

Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
~pgerrits
~pgerrits
SSC Eights!
SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)

Group: General Forum Members
Points: 999 Visits: 4
I agree with you fully there, MS should never release products that are not complete, but hey they do it all the time and for some reason, ppl accept that and still continue to buy thier incomplete products, and I guess it because its done in the absence of anything else out there (scratch that, probably cause you need the increased performance of 64bit and all your apps are in sql2000 and can't be ported to something else, so your stuck with buying an incomplete product).



Laurel Todd-245733
Laurel Todd-245733
SSC Journeyman
SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)

Group: General Forum Members
Points: 84 Visits: 1
I think the question was worded wrong. The question did not mention migrating from the 32-bit version... I researched this and would have chosen the correct answer, but not in the context of the question "Can you run a DTS package on SQL Server 2000 64-bit edition?"
GilaMonster
GilaMonster
SSC Guru
SSC Guru (60K reputation)SSC Guru (60K reputation)SSC Guru (60K reputation)SSC Guru (60K reputation)SSC Guru (60K reputation)SSC Guru (60K reputation)SSC Guru (60K reputation)SSC Guru (60K reputation)

Group: General Forum Members
Points: 60162 Visits: 44742

It's hardly undocumented. If you look through the articles on 64-bit SQL (on the MS site) it's quite clear that most of the tools don't have a 64-bit version. The DTS runtime is one of them.

I've got a 64-bit server here, and to be quite honest, it's not that large an issue. My main production server is 64 bit (itanium) and I've got a second server (32 bit) which has all the DTS stored on it.

A much bigger issue which I had is that there are very few (stable) OLE DB/ODBC drivers available for 64 bit.



Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search