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 Srinivassrinivas

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.

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