"Jeremy Greaves " <mssqldba-ezmlmshield-x75035585.[Email address protected]
wrote on 09/27/2007 12:05:43 PM:

> I'm sure you're aware that SSIS is 32bit only, SSIS won't work on a
64bit
> SQL box.
> So if you're thinking of migrating to a wondey 64bit environment, don't
> expect to host SSIS on the same box. Oh it'll install, it just won't
> work.... not according to Microsoft anyway... D'Oh!!
> They never made a 64bit version. It'll run via command line, but who
wants
> to go commando in a 64bit environment???
> So we have to launch/schedule the task within a 32bit machine to build
the
> cube on the 64bit machine....

Hmmm. Not exactly what M$ has said, at all. SSIS certainly works on
64-bit SQL, but...

For what's probably more details than you want, see:

http://technet.microsoft.com/en-us/library/ms141766.aspx

Frank Ress
Gas Technology Institute

MS Sql Server LazyDBA home page