I am new to workiing with SSIS package and I would like help to try to determine what is wrong. Basically when I look at the input file, it looks fine to me.
The following is the error message when the ssis package is running:
Executed as user: OMAHAPS\SA_701 Microsoft (R) SQL Server Execute Package Utility Version 11.0.7001.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 9:44:48 AM Error: 2019-09-06 09:44:53.29 Code: 0xC0202009 Source: Data Flow Task - Get the month related to the upload Excel Source [2] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37. End Error Error: 2019-09-06 09:44:53.30 Code: 0xC02020E8 Source: Data Flow Task - Get the month related to the upload Excel Source [2] Description: Opening a rowset for "CommodityData$A1:AK2" failed. Check that the object exists in the database. End Error Error: 2019-09-06 09:44:53.40 Code: 0xC004706B Source: Data Flow Task - Get the month related to the upload SSIS.Pipeline Description: "Excel Source" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2019-09-06 09:44:53.40 Code: 0xC004700C Source: Data Flow Task - Get the month related to the upload SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2019-09-06 09:44:53.40 Code: 0xC0024107 Source: Data Flow Task - Get the month related to the upload Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:44:48 AM Finished: 9:44:53 AM Elapsed: 4.735 seconds. The package execution failed. The step failed.
When try to open the apparent visual studio 2008 and convert to visual studio 2010, I get the following error messge:
* Error 0xc0047062: Data Flow Task - Get the month related to the upload: Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications.Core, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
* Error 0xc0047062: Data Flow Task - Get the month related to the upload: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications.Core, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
Since I am a .net programmer, I am wondering if I can add the requested file to the visual studio environment? If so, can you tell me how to add the requested file to the enviroment?
Basically can you tell me what I can to to solve this issue?