Here is the error which I am getting when I run my SSIS package.I am trying to load 6 tables from a batabase in sql server to one destination table of the same database where my sources are there.I am getting the below error message.Can someone explain me what is wrong.PLEASE ITS URGENT. Information: 0x40016038 atPROJECT PACKAGE: The package is attempting to configure from the environment variable "SSISConfiguration". Information: 0x40016040 atPROJECT PACKAGE: The package is attempting to configure from SQL Server using the configuration string "" ";"[dbo].[SSIS Configurations]";"DBAConfiguration";". Warning: 0x80012017 atPROJECT PACKAGE: The package path referenced an object that cannot be found: "\Package.Variables[DBAConfiguration::strOLEDB2].Properties[Value]". This occurs when an attempt is made to resolve a package path to an object that cannot be found. Warning: 0x80012017 atPROJECT PACKAGE: The package path referenced an object that cannot be found: "\Package.Variables[Database::strSourceConnStr].Properties[Value]". This occurs when an attempt is made to resolve a package path to an object that cannot be found. Warning: 0x80012017 atPROJECT PACKAGE: The package path referenced an object that cannot be found: "\Package.Variables[Database::strDestConnStr].Properties[Value]". This occurs when an attempt is made to resolve a package path to an object that cannot be found. Warning: 0x80012017 atPROJECT PACKAGE: The package path referenced an object that cannot be found: "\Package.Variables[DBAConfiguration::strPROJECTtsXCDb].Properties[Value]". This occurs when an attempt is made to resolve a package path to an object that cannot be found. Warning: 0x80012017 atPROJECT PACKAGE: The package path referenced an object that cannot be found: "\Package.Variables[DBAConfiguration::strPROJECTDb].Properties[Value]". This occurs when an attempt is made to resolve a package path to an object that cannot be found. Information: 0x40016040 atPROJECT PACKAGE: The package is attempting to configure from SQL Server using the configuration string ""OLE SSISMasterDB";"[dbo].[SSIS Configurations]";"PROJECT1";". Warning: 0x80012054 atPROJECT PACKAGE: Table "[dbo].[SSIS Configurations]" does not have any records for configuration. This occurs when configuring from a SQL Server table that has no records for the configuration. SSIS package "PROJECT.dtsx" starting. Information: 0x4004300A at LOAD PROJECT, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at LOAD PROJECT, DTS.Pipeline: Validation phase is beginning. Information: 0x40043006 at LOAD PROJECT, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at LOAD PROJECT, DTS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at LOAD PROJECT, DTS.Pipeline: Execute phase is beginning. Warning: 0x3 at Script Task: Precompiled script failed to load. Attempting to recompile. For more information, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885). Error: 0xC0202009 at LOAD PROJECT, OLE DB Destination [1768]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unspecified error". Warning: 0x3 at Script Task: Precompiled script failed to load. Attempting to recompile. For more information, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885). Error: 0xC020901C at LOAD PROJECT, OLE DB Destination [1768]: There was an error with input column "GroupId" (1822) on input "OLE DB Destination Input" (1781). The column status returned was: "The value violated the integrity constraints for the column.". Warning: 0x3 at Script Task: Precompiled script failed to load. Attempting to recompile. For more information, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885). Error: 0xC0209029 at LOAD PROJECT, OLE DB Destination [1768]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (1781)" failed because error code 0xC020907D occurred, and the error row disposition on "input "OLE DB Destination Input" (1781)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Warning: 0x3 at Script Task: Precompiled script failed to load. Attempting to recompile. For more information, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885). Error: 0x4 at Script Task: The Script returned a failure result. Task failed: Script Task Error: 0xC0047022 at LOAD PROJECT: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (1768) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Warning: 0x3 at Script Task: Precompiled script failed to load. Attempting to recompile. For more information, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885). Error: 0x4 at Script Task: The Script returned a failure result. Task failed: Script Task Error: 0xC0047021 at LOAD PROJECT: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited. Warning: 0x3 at Script Task: Precompiled script failed to load. Attempting to recompile. For more information, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885). Warning: 0x80019002 at Script Task: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) 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. Task failed: Script Task Error: 0xC02020C4 at LOAD PROJECT, OLE DB Source [1686]: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. Warning: 0x3 at Script Task: Precompiled script failed to load. Attempting to recompile. For more information, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885). Warning: 0x80019002 at Script Task: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) 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. Task failed: Script Task Error: 0xC0047038 at LOAD PROJECT: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1686) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. Warning: 0x3 at Script Task: Precompiled script failed to load. Attempting to recompile. For more information, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885). Warning: 0x80019002 at Script Task: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) 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. Task failed: Script Task Error: 0xC0047021 at LOAD PROJECT: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. Information: 0x40043008 at LOAD PROJECT, DTS.Pipeline: Post Execute phase is beginning. Information: 0x402090DF at LOAD PROJECT, OLE DB Destination [1768]: The final commit for the data insertion has started. Information: 0x402090E0 at LOAD PROJECT, OLE DB Destination [1768]: The final commit for the data insertion has ended. Information: 0x40043009 at LOAD PROJECT, DTS.Pipeline: Cleanup phase is beginning. Information: 0x4004300B at LOAD PROJECT, DTS.Pipeline: "component "OLE DB Destination" (1768)" wrote 0 rows. Task failed: LOAD PROJECT Warning: 0x80019002 at Sequence Container: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (8) 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. Warning: 0x80019002 atPROJECT PACKAGE: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (10) 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. SSIS package "PROJECT.dtsx" finished: Failure. Thank you.

It seems you have tried to do some configuration and it is not having any records in it. Can you look into the below on ? Warning: 0x80012054 atPROJECT PACKAGE: Table "[dbo].[SSIS Configurations]" does not have any records for configuration. This occurs when configuring from a SQL Server table that has no records for the configuration. Check for this table to have records of configuration or check the server you are pointing for the configuration is correct ?

A lot of things are going wrong. First of all, the configurations failed, as Sorna has pointed out. However, that will not fail your package. You have an error in an OLE DB Destination: The value violated the integrity constraints for the column. So some constraint in the database was violated by some data you tried to insert. Check your data to see if it is clean. Furthermore your script task failed to load, so I would also look into that.MCTS, MCITP - Please mark posts as answered where appropriate.