64 bit runtime issue

Question

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

nabajyoti.b SSCrazy Points: 2177 More actions · Answer 1

Also, when i assign precompile true for a particular script task;

i get the message : The task is configured to pre-compile the script, but binary code is not found, please visit IDE

What do i do with that?

nabajyoti.b SSCrazy Points: 2177 More actions · Answer 2

please check this post

gholap.rohidas Valued Member Points: 61 More actions · Answer 3

Hi,

but how to execute package through code on 64 bit for Excel connection mamager.?

nabajyoti.b SSCrazy Points: 2177 More actions · Answer 4

if there is anything with Excel or applications with OLE support, you cannot run these in 64-bit.

Its hard but you have to use the 32 version:

"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /FILE "" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI

running under the "SQL Agent Service Account