Hi All, getting script component compile error when executing the SSIS package. My Environment: Windows 2003 R2 with SP2, SQL Server 2005 Dev edition with SP2 Below is the error message I got from the BIDS window. Error: 0x3 at convert: Precompiled script failed to load. The computer that is running the Script Task does not have a compiler capable of recompiling the script. To recompile the script, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885). Task failed: convert Warning: 0x80014058 at convert: This task or container has failed, but because FailPackageOnFailure property is FALSE, the package will continue. This warning is posted when the SaveCheckpoints property of the package is set to TRUE and the task or container fails. Information: 0x40016049 at Mariposa_main_slot_init_to_dw: Checkpoint file "C:\Program Files\Mariposa\SSIS\Mariposa_main_slot_init_to_dw.chk" update starting. Information: 0x40016047 at convert: Checkpoint file "C:\Program Files\Mariposa\SSIS\Mariposa_main_slot_init_to_dw.chk" was updated to record completion of this container. Warning: 0x80019002 at OnError: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. Thank you Srinivas srinivas

So have you read Microsoft Knowledge Base article KB931846? What exactly does your package do? What's the script task doing?Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

Thanks for the reply. I read the article before posting the question. my package call another package using script task. in the child package I am using script component to handle some business logic. Thank you Srinisrinivas

my package call another package using script task. Srini srinivas This statement confuses me as you need to use an Execute Package Task to executs a child package, not Script Task.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

Hi Srinivas, Have you tried the methods suggested in the KB? Are you trying to call the package using C# code (SSIS api programming)? Mostly this looks like the hotfix or service pack issue.Happy to help! Thanks. Regards and good Wishes, Deepak.

Thanks for the reply, but for me it didn't work.srinivas

Thanks for the reply, but for me it didn't work. srinivas What do you mean by this? Did you get an error? Is the same as the above? What is your script trying to execute? Can youplease post a copy of the script in the script taskJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

HI Jeff, I cannot use execute package task as my packages are developed and tested completly on Windows 2003 but I am using my packages on Windows 2008 R2 as side project and also I cannot change my script tasks to Execute package tasks. Please suggest. Thank you Srinisrinivas

I cannot change my script tasks to Execute package tasks Why not?Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Those are released from Testing department. If I change I need to resend to testing team. Thank you Srinisrinivas

So what you need to do is use the correct task and then get your testing department to test and approve the changes.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings MC ID: Microsoft Transcript Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

my package call another package using script task. Srini srinivas This statement confuses me as you need to use an Execute Package Task to executs a child package, not Script Task. Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD Jeff, we can invoke child packages from Script task. there is no issue in that.My Blog | Ask Me | Test your SSIS skills

HI Jeff, I cannot use execute package task as my packages are developed and tested completly on Windows 2003 but I am using my packages on Windows 2008 R2 as side project and also I cannot change my script tasks to Execute package tasks. Please suggest. Thank you Srini srinivas Is there an error only for te script task calling the child package or are other scripts tasks giving error as well? Though I would suggest if you are not calling multiple packages from the script task you should try and convince your team to make changes to your package by removing the script task and replacing it with Execute Package task as suggeste y Jeff.My Blog | Ask Me | Test your SSIS skills

Also can you do a test by removing the checkpoint and executing the pacakge. Do you still see the same issue? Sorry for multiple posts ;)My Blog | Ask Me | Test your SSIS skills

All my script task packages are giving the same error message even though I removed the check point file.srinivas

is the test environment [where packages failing ] updated with latest sps, fixes ... can you meanwhile try out setting the precomplie to false in script task .. and redeploy package see if it is still failing ...Hope that helps ... Kunal

Everything is up to date regarding SP's. I tried Precompile to false also. But nothing worked for me.srinivas

It would be interesting to know the Hardware: Is one of the system you used ws a 64 bit and the new system where are trying to use the script task 32 bit or viceversa.Abhinav