Can''t precompile script

Hi,

with a script task I get an error "This task is configured to pre-compile the script but the binary code is not found. Please visit the IDE in Script Task editor by clicking Desing Script button to cause binary code to be generated".

Well, if I do so the error doesn't disappear. The only chance I have is to switch of precopilation, which is quite a performance issue...

I have no idea where this error is comming from... The script is quite easy, just some string and file operations (find out file change date using system.io)...

Any idea?

I can only think that there is an error in compilation because this should of course work!

-Jamie

|||...any idea where to look? If I switch of precompile everything works, so there shouldn't be any error in the script...|||

Hmmm...bizarre.

Sorry Thomas, can't help you there!

|||This is an old one, but I just had the same problem and just noticed that my script had a syntax error. Once I fixed the syntax error, the problem was resolved.|||im facing the same problem....for the first time....simply cant keep precompile option to true as binary code is not getting generated....the issue is my env may change to 64 bit....evn keepin the option precompile false wont help then( which is workin fine now)
...just as im writin this....was this a issue bfr SP1... i havent checked if i have run it in new installation...
will check n post back if success....
ne suggestions welcome in the meanwhile...|||This is just wrong - when I set property precompile = false for the Script Task everything works fine.

SSIS works in odd ways sometimes (or perhaps it is just me)

Actually I now noticed that whatever package's script i open up - they dont compile anymore - I wonder what causes all of a sudden all the scripts on my workstation not to compile?|||as i guessed...SP1 solves this problem...worked for me... i had a new local server installation n missed out on the service packs....so install SP1 and 2 and ur done.....but ya ull have to then change all precompilei otions to true and open n close the script once to get the binary code........

sorry for the delay in reply!!

Can''t precompile script

Hi,

with a script task I get an error "This task is configured to pre-compile the script but the binary code is not found. Please visit the IDE in Script Task editor by clicking Desing Script button to cause binary code to be generated".

Well, if I do so the error doesn't disappear. The only chance I have is to switch of precopilation, which is quite a performance issue...

I have no idea where this error is comming from... The script is quite easy, just some string and file operations (find out file change date using system.io)...

Any idea?

I can only think that there is an error in compilation because this should of course work!

-Jamie

|||...any idea where to look? If I switch of precompile everything works, so there shouldn't be any error in the script...|||

Hmmm...bizarre.

Sorry Thomas, can't help you there!

|||This is an old one, but I just had the same problem and just noticed that my script had a syntax error. Once I fixed the syntax error, the problem was resolved.|||im facing the same problem....for the first time....simply cant keep precompile option to true as binary code is not getting generated....the issue is my env may change to 64 bit....evn keepin the option precompile false wont help then( which is workin fine now)
...just as im writin this....was this a issue bfr SP1... i havent checked if i have run it in new installation...
will check n post back if success....
ne suggestions welcome in the meanwhile...|||This is just wrong - when I set property precompile = false for the Script Task everything works fine.

SSIS works in odd ways sometimes (or perhaps it is just me)

Actually I now noticed that whatever package's script i open up - they dont compile anymore - I wonder what causes all of a sudden all the scripts on my workstation not to compile?|||as i guessed...SP1 solves this problem...worked for me... i had a new local server installation n missed out on the service packs....so install SP1 and 2 and ur done.....but ya ull have to then change all precompilei otions to true and open n close the script once to get the binary code........

sorry for the delay in reply!!

Can't precompile script

Hi,

with a script task I get an error "This task is configured to pre-compile the script but the binary code is not found. Please visit the IDE in Script Task editor by clicking Desing Script button to cause binary code to be generated".

Well, if I do so the error doesn't disappear. The only chance I have is to switch of precopilation, which is quite a performance issue...

I have no idea where this error is comming from... The script is quite easy, just some string and file operations (find out file change date using system.io)...

Any idea?

I can only think that there is an error in compilation because this should of course work!

-Jamie

|||...any idea where to look? If I switch of precompile everything works, so there shouldn't be any error in the script...|||

Hmmm...bizarre.

Sorry Thomas, can't help you there!

|||This is an old one, but I just had the same problem and just noticed that my script had a syntax error. Once I fixed the syntax error, the problem was resolved.|||im facing the same problem....for the first time....simply cant keep precompile option to true as binary code is not getting generated....the issue is my env may change to 64 bit....evn keepin the option precompile false wont help then( which is workin fine now)
...just as im writin this....was this a issue bfr SP1... i havent checked if i have run it in new installation...
will check n post back if success....
ne suggestions welcome in the meanwhile...|||This is just wrong - when I set property precompile = false for the Script Task everything works fine.

SSIS works in odd ways sometimes (or perhaps it is just me)

Actually I now noticed that whatever package's script i open up - they dont compile anymore - I wonder what causes all of a sudden all the scripts on my workstation not to compile?|||as i guessed...SP1 solves this problem...worked for me... i had a new local server installation n missed out on the service packs....so install SP1 and 2 and ur done.....but ya ull have to then change all precompilei otions to true and open n close the script once to get the binary code........

sorry for the delay in reply!!

Can't precompile script

Hi,

with a script task I get an error "This task is configured to pre-compile the script but the binary code is not found. Please visit the IDE in Script Task editor by clicking Desing Script button to cause binary code to be generated".

Well, if I do so the error doesn't disappear. The only chance I have is to switch of precopilation, which is quite a performance issue...

I have no idea where this error is comming from... The script is quite easy, just some string and file operations (find out file change date using system.io)...

Any idea?

I can only think that there is an error in compilation because this should of course work!

-Jamie

|||...any idea where to look? If I switch of precompile everything works, so there shouldn't be any error in the script...|||

Hmmm...bizarre.

Sorry Thomas, can't help you there!

|||This is an old one, but I just had the same problem and just noticed that my script had a syntax error. Once I fixed the syntax error, the problem was resolved.|||im facing the same problem....for the first time....simply cant keep precompile option to true as binary code is not getting generated....the issue is my env may change to 64 bit....evn keepin the option precompile false wont help then( which is workin fine now)
...just as im writin this....was this a issue bfr SP1... i havent checked if i have run it in new installation...
will check n post back if success....
ne suggestions welcome in the meanwhile...|||This is just wrong - when I set property precompile = false for the Script Task everything works fine.

SSIS works in odd ways sometimes (or perhaps it is just me)

Actually I now noticed that whatever package's script i open up - they dont compile anymore - I wonder what causes all of a sudden all the scripts on my workstation not to compile?|||as i guessed...SP1 solves this problem...worked for me... i had a new local server installation n missed out on the service packs....so install SP1 and 2 and ur done.....but ya ull have to then change all precompilei otions to true and open n close the script once to get the binary code........

sorry for the delay in reply!!

Can't get SQL Server 2000 to use more than 2GB of RAM

Hi,

I have configured my SQL Server to use AWE and the /3GB switch in the boot.ini. Also the SQLService account has the "lock pages in memory" user rights. Yet SQL Server and Windows together do not want to utilize more than 2GB of memory, while 4GB is available. Some details below:

4 GB memory (2 GB available)
Windows 2000 Server Enterprise (SP3)
SQL Server 2000 Enterprise (SP4)

In the SQL Server log I can read "Address Windowing Extensions enabled" and "Warning: unable to allocate 'min server memory' of 2560MB"

Does anyone know what I am missing here? Thanks in advance.

Erik.

Hi Erik,

To my knowledge if you only have 4GB of memory or less you should only put in the /3GB switch and not turn AWE on. Maybe try turning AWE off.

Also, what is are the minimum and maximum memory settings on your server? You can view this in Enterprise Manager by right clicking on the server, selecting "Properties" and then viewing the "Memory" tab in the window that appears (sorry if you already knew that).

Also, is the server configured to dynamically manage memory or did you set it so that a fixed memory size is used?

Hope that helps a little bit or sheds a little light on things for future investigation, but sorry if it didn't.
|||Could you post the results of DBCC MEMORYSTATUS ?|||

Eric C. wrote:

Could you post the results of DBCC MEMORYSTATUS ?

Buffer Distribution Buffers
--
Stolen 8500
Free 1353
Procedures 13625
Inram 32521
Dirty 1085
Kept 0
I/O 1
Latched 376
Other 141211

Buffer Counts Buffers
--
Commited 198672
Target 198672
Hashed 175197
InternalReservation 448
ExternalReservation 14006
Min Free 1016
Visible 198672

Procedure Cache Value
--
TotalProcs 1638
TotalPages 13625
InUsePages 8525

Dynamic Memory Manager Buffers
--
Stolen 16978
OS Reserved 1096
OS Committed 1074
OS In Use 1054
General 3094
QueryPlan 13983
Optimizer 0
Utilities 18
Connection 686

Global Memory Objects Buffers
--
Resource 1307
Locks 147
XDES 64
SQLCache 172
Replication 2
LockBytes 2
ServerGlobal 24

Query Memory Objects Value
--
Grants 9
Waiting 0
Available (Buffers) 74325
Maximum (Buffers) 93475

Optimization Queue Value
--
Optimizing 0
Waiting 0
Available 32
Maximum 32

|||I don't think you need AWE unless you're accessing over 4GB of memory. Also you may want to check your virtual memory settings in Windows 2000 Server. If it is dynamically allocating Virtual Memory, do a defrag to see if more than one block of Unmovable bytes exists. If you have fragmented Virtual Memory space, it can cause strange memory errors. If you see fragmentation, try changing the setting to a fixed amount so that it will recreate the VM space in a single block.|||

This was a bug in SP4. Go to http://www.microsoft.com/downloads/details.aspx?FamilyID=7C407047-3F1F-48B8-9E4C-DC32875E1961&displaylang=en

|||

You can use AWE if the amount of physical memory on the machine exceeds the amount of virtual memory. On 32 bit systems there is 2GB of private address space. Since 4GB > 2GB you can enable AWE and set max server memory up to 3.5 GB, depending on the other applications and requirements on the system.

Eric is correct, you need to download the update to sql sp4 at the link provided.