Errors running AWDataWarehouseRefresh package

0

I'm trying to learn SSIS with AdventureWorks, I have SSDT (Visual Studio 2017) and SQL Server 2017 installed. I downloaded MSFTISProdSamples and I opened the AWDataWarehouseRefresh in SSDT, but when I execute said package I get a bunch of errors:

SSIS package "D:\Downloads\MSFTISProdSamples\sourceCode\sourceCode\Katmai_June_CTP\Package Samples\AWDataWarehouseRefresh\AWDataWarehouseRefresh\AWDWRefresh.dtsx" starting. Error: 0xC001404B at AWDWRefresh, Log provider "SSIS log provider for Text files": The SSIS logging provider has failed to open the log. Error code: 0x80070003. The system cannot find the path specified. Error: 0xC001404B at AWDWRefresh, Log provider "SSIS log provider for Text files": The SSIS logging provider has failed to open the log. Error code: 0x80070003. The system cannot find the path specified. Warning: 0x8001C004 at Drop temp tables: The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty. Warning: 0x8001C004 at Create temp tables: The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty. Error: 0xC002F304 at Bulk Insert tempStore-MinPayment, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.tempStore-MinPayment'.". Error: 0xC002F304 at Bulk Insert tempSpecialOffer-ForeignData, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.tempSpecialOffer-ForeignData'.". Error: 0xC002F304 at Bulk Insert tempIndividual-ForeignData, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.tempIndividual-ForeignData'.". Error: 0xC002F304 at Bulk Insert tempProduct-ForeignNames, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.tempProduct-ForeignNames'.". Error: 0xC002F304 at Bulk Insert tempProductSubcategory-ForeignNames, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.tempProductSubcategory-ForeignNames'.". Error: 0xC002F304 at Bulk Insert tempCustomer-YearlyIncome, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.tempCustomer-YearlyIncome'.". Error: 0xC002F304 at Bulk Insert tempProductCategory-ForeignNames, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.tempProductCategory-ForeignNames'.". Warning: 0x80019002 at AWDWRefresh: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (7) 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: 0x8001C004 at Create tables: The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty. Information: 0x4004300A at Data Flow Task - DimCurrency, SSIS.Pipeline: Validation phase is beginning. Error: 0xC002F304 at Bulk Insert FactFinance, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.FactFinance'.". Error: 0xC002F304 at Bulk Insert DimAccount, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.DimAccount'.". Warning: 0x80049304 at Data Flow Task - DimCurrency, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console. Information: 0x40043006 at Data Flow Task - DimCurrency, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task - DimCurrency, SSIS.Pipeline: Pre-Execute phase is beginning. Error: 0xC0204026 at Data Flow Task - DimCurrency, SQL Server Destination [23]: The metadata for "[dbo].[DimCurrency]" cannot be retrieved. Make sure the object name is correct and the object exists. Error: 0xC004701A at Data Flow Task - DimCurrency, SSIS.Pipeline: SQL Server Destination failed the pre-execute phase and returned error code 0xC0204026. Information: 0x4004300B at Data Flow Task - DimCurrency, SSIS.Pipeline: "SQL Server Destination" wrote 0 rows. Information: 0x40043009 at Data Flow Task - DimCurrency, SSIS.Pipeline: Cleanup phase is beginning. Task failed: Data Flow Task - DimCurrency Error: 0xC002F304 at Bulk Insert AdventureWorksDWBuildVersion, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.AdventureWorksDWBuildVersion'.". Task failed: Bulk Insert tempIndividual-ForeignData Task failed: Bulk Insert tempProductCategory-ForeignNames Task failed: Bulk Insert tempProduct-ForeignNames Task failed: Bulk Insert tempStore-MinPayment Task failed: Bulk Insert tempCustomer-YearlyIncome Task failed: Bulk Insert tempSpecialOffer-ForeignData Task failed: Bulk Insert tempProductSubcategory-ForeignNames Information: 0x4004300A at Data Flow Task - DimDepartmentGroup, SSIS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task - DimSalesTerritory 1, SSIS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task - DimGeography, SSIS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task - DimEmployee, SSIS.Pipeline: Validation phase is beginning. Error: 0xC002F304 at Bulk Insert DimScenario, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.DimScenario'.". Error: 0xC002F304 at Bulk Insert DimTime, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.DimTime'.". Error: 0xC002F304 at Bulk Insert DimOrganization, Bulk Insert Task: An error occurred with the following error message: "Invalid object name 'dbo.DimOrganization'.". Information: 0x40043006 at Data Flow Task - DimGeography, SSIS.Pipeline: Prepare for Execute phase is beginning. Warning: 0x802092A7 at Data Flow Task - DimEmployee, SQL Server Destination [104]: Truncation may occur due to inserting data from data flow column "EmergencyContactName" with a length of 101 to database column "EmergencyContactName" with a length of 50. Information: 0x40043006 at Data Flow Task - DimDepartmentGroup, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043006 at Data Flow Task - DimEmployee, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task - DimGeography, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x40043006 at Data Flow Task - DimSalesTerritory 1, SSIS.Pipeline: Prepare for Execute phase is beginning. Error: 0xC0202009 at Data Flow Task - DimGeography, OLE DB Source [2]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Invalid object name 'Sales.CustomerAddress'.". Error: 0xC004701A at Data Flow Task - DimGeography, SSIS.Pipeline: OLE DB Source failed the pre-execute phase and returned error code 0xC0202009. Information: 0x40043007 at Data Flow Task - DimDepartmentGroup, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x40043007 at Data Flow Task - DimSalesTerritory 1, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x40043007 at Data Flow Task - DimEmployee, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300B at Data Flow Task - DimGeography, SSIS.Pipeline: "SQL Server Destination" wrote 0 rows. Information: 0x40043009 at Data Flow Task - DimGeography, SSIS.Pipeline: Cleanup phase is beginning. Task failed: Data Flow Task - DimGeography Information: 0x4004300A at Data Flow Task - FactInternetSalesReason, SSIS.Pipeline: Validation phase is beginning. Error: 0xC0204026 at Data Flow Task - DimDepartmentGroup, SQL Server Destination [23]: The metadata for "[dbo].[DimDepartmentGroup]" cannot be retrieved. Make sure the object name is correct and the object exists. Error: 0xC004701A at Data Flow Task - DimDepartmentGroup, SSIS.Pipeline: SQL Server Destination failed the pre-execute phase and returned error code 0xC0204026. Information: 0x40043008 at Data Flow Task - DimDepartmentGroup, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task - DimDepartmentGroup, SSIS.Pipeline: "SQL Server Destination" wrote 0 rows. Information: 0x40043009 at Data Flow Task - DimDepartmentGroup, SSIS.Pipeline: Cleanup phase is beginning. Warning: 0x802092A7 at Data Flow Task - FactInternetSalesReason, SQL Server Destination [26]: Truncation may occur due to inserting data from data flow column "SalesOrderNumber" with a length of 25 to database column "SalesOrderNumber" with a length of 20. Task failed: Data Flow Task - DimDepartmentGroup Error: 0xC0204026 at Data Flow Task - DimSalesTerritory 1, SQL Server Destination [32]: The metadata for "[dbo].[DimSalesTerritory]" cannot be retrieved. Make sure the object name is correct and the object exists. Information: 0x4004300A at Data Flow Task - DimSalesReason, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task - FactInternetSalesReason, SSIS.Pipeline: Prepare for Execute phase is beginning. Error: 0xC004701A at Data Flow Task - DimSalesTerritory 1, SSIS.Pipeline: SQL Server Destination failed the pre-execute phase and returned error code 0xC0204026. Information: 0x40043008 at Data Flow Task - DimSalesTerritory 1, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task - DimSalesTerritory 1, SSIS.Pipeline: "SQL Server Destination" wrote 0 rows. Information: 0x40043009 at Data Flow Task - DimSalesTerritory 1, SSIS.Pipeline: Cleanup phase is beginning. Information: 0x40043007 at Data Flow Task - FactInternetSalesReason, SSIS.Pipeline: Pre-Execute phase is beginning. Task failed: Data Flow Task - DimSalesTerritory 1 Information: 0x40043006 at Data Flow Task - DimSalesReason, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task - DimSalesReason, SSIS.Pipeline: Pre-Execute phase is beginning. Error: 0xC0204026 at Data Flow Task - DimSalesReason, SQL Server Destination [29]: The metadata for "[dbo].[DimSalesReason]" cannot be retrieved. Make sure the object name is correct and the object exists. Error: 0xC004701A at Data Flow Task - DimSalesReason, SSIS.Pipeline: SQL Server Destination failed the pre-execute phase and returned error code 0xC0204026. Information: 0x4004300B at Data Flow Task - DimSalesReason, SSIS.Pipeline: "SQL Server Destination" wrote 0 rows. Information: 0x40043009 at Data Flow Task - DimSalesReason, SSIS.Pipeline: Cleanup phase is beginning. Task failed: Data Flow Task - DimSalesReason Task failed: Bulk Insert FactFinance Task failed: Bulk Insert DimAccount Error: 0xC0202009 at Data Flow Task - DimEmployee, OLE DB Source [2]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Invalid object name 'AdventureWorks.Person.Contact'.". Error: 0xC004701A at Data Flow Task - DimEmployee, SSIS.Pipeline: OLE DB Source failed the pre-execute phase and returned error code 0xC0202009. Information: 0x4004300B at Data Flow Task - DimEmployee, SSIS.Pipeline: "SQL Server Destination" wrote 0 rows. Information: 0x40043009 at Data Flow Task - DimEmployee, SSIS.Pipeline: Cleanup phase is beginning. Task failed: Data Flow Task - DimEmployee Error: 0xC0204026 at Data Flow Task - FactInternetSalesReason, SQL Server Destination [26]: The metadata for "[dbo].[FactInternetSalesReason]" cannot be retrieved. Make sure the object name is correct and the object exists. Error: 0xC004701A at Data Flow Task - FactInternetSalesReason, SSIS.Pipeline: SQL Server Destination failed the pre-execute phase and returned error code 0xC0204026. Information: 0x40043008 at Data Flow Task - FactInternetSalesReason, SSIS.Pipeline: Post Execute phase is beginning. Task failed: Bulk Insert AdventureWorksDWBuildVersion Information: 0x4004300B at Data Flow Task - FactInternetSalesReason, SSIS.Pipeline: "SQL Server Destination" wrote 0 rows. Information: 0x40043009 at Data Flow Task - FactInternetSalesReason, SSIS.Pipeline: Cleanup phase is beginning. Task failed: Data Flow Task - FactInternetSalesReason Task failed: Bulk Insert DimScenario Task failed: Bulk Insert DimTime Task failed: Bulk Insert DimOrganization SSIS package "D:\Downloads\MSFTISProdSamples\sourceCode\sourceCode\Katmai_June_CTP\Package Samples\AWDataWarehouseRefresh\AWDataWarehouseRefresh\AWDWRefresh.dtsx" finished: Failure. The program '[18228] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).

P.S: I'm a complete beginner at SQL Server and SSIS

sql-server
ssis
etl
adventureworks

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0