Could not find file
-
Please assist. I don't know if the actual file does not exist( it does not exist in mentioned folder) or if the file path in the variables are the problem. Am i jumping the gun here?
[Excel Source - Master Data Reference [14]] Error: System.IO.FileNotFoundException:
Could not find file '\\ZADURFS01\Departments\Finance\Business Intelligence, Reporting and Analytics
(BIRA)\Source Data - Excel\BRACS Base Files\Actuals\BRACS Data Masterfile Actuals - P01 - LY - LY.xlsx'.
File name: '\\ZADURFS01\Departments\Finance\Business Intelligence, Reporting and Analytics (BIRA)\
Source Data - Excel\BRACS Base Files\Actuals\BRACS Data Masterfile Actuals - P01 - LY - LY.xlsx'
at ZappySys.PowerPack.Adapter.SqlDataComponentBase.HandleException(Exception ex)
at ZappySys.PowerPack.Adapter.SqlDataComponentBase.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Excel Source - Master Data Reference returned error code 0x80070002. 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.
Var_Path_to_file:
\\ZADURFS01\Departments\Finance\Business Intelligence, Reporting and Analytics (BIRA)\Source Data - Excel\BRACS Base Files\
Var_final_path: "@[User::Var_Path_to_file] + @[User::Var_Determine_Scenario] + @[User::Var_use] + @[User::Var_Final_FIle_Name]"
-
Hi there,From the details you've provided, it seems like the issue might be with the file path specified in your SSIS package. The FileNotFoundException typically indicates that the path provided doesn't lead to an existing file. It's possible that either the file doesn't exist in the specified location, or there's a mismatch in the file path defined in your SSIS variables.I'd suggest double-checking the file path and ensuring that the file exists at that location. Also, review the concatenation logic in your SSIS package that constructs the file path. Sometimes, an incorrect concatenation (like missing backslashes or an extra space) can lead to an incorrect path, even though each individual variable is correct.If the file and path are both correct, it might be worth checking the access permissions to the file location. Network and permission issues can also cause such errors.Hope this helps and you're able to resolve the issue quickly
-
- The error was because two variables sort of overlapped each other and that lead to the ETL seeking file "\BRACS Data Masterfile Actuals - P01 - LY - LY.xlsx" which does not exist(this error has been fixed).
- Somewhere in the variables it is filtering for "Actuals", "Forecast" and "Budget" columns. It is filtering specific periods or may omit some periods. I am missing some periods:
- "Actuals"
- , "Forecast" is missing period 8
and "Budget" etc.
I inherited this SSIS package. I don't know exactly where it is filtering or excluding the missing periods. I have attached the SSIS package.
-
- The error was because two variables sort of overlapped each other and that lead to the ETL seeking file "\BRACS Data Masterfile Actuals - P01 - LY - LY.xlsx" which does not exist(this error has been fixed).
- Somewhere in the variables it is filtering for "Actuals", "Forecast" and "Budget" columns. It is filtering specific periods or may omit some periods. I am missing some periods:
- "Actuals"
- , "Forecast" is missing period 8
and "Budget" etc.
I inherited this SSIS package. I don't know exactly where it is filtering or excluding the missing periods. I have attached the SSIS package.
-
You'll be lucky to get detailed help with this one. If anyone opens up your package, they will no doubt be confronted with validation errors because the data sources are not available to them. Also, I imagine that most SSIS devs do not have the ZappySys add-ons installed, which adds another layer of difficulty.
It might be easier if you tell us what the package does ... component by component. The filtering that you mention can only be happening in a few places.
Working in debug mode & using Data Viewers within your data flow should also help you work out where the filtering is occurring.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
Here is the complete use case of the package(it runs with no errors):
-
None of the components shown does any direct filtering. Maybe your FOR loop is going wrong somewhere.
Can you post the full Expression definitions for the six variable which have expressions, please?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
I believe i did?
@[User::Var_Period_loop_Start] == 1 ? "01":
@[User::Var_Period_loop_Start] == 2 ? "02":
@[User::Var_Period_loop_Start] == 3 ? "03":
@[User::Var_Period_loop_Start] == 4 ? "04":
@[User::Var_Period_loop_Start] == 5 ? "05":
@[User::Var_Period_loop_Start] == 6 ? "06":
@[User::Var_Period_loop_Start] == 7 ? "07":
@[User::Var_Period_loop_Start] == 8 ? "08":
@[User::Var_Period_loop_Start] == 9 ? "09":
@[User::Var_Period_loop_Start] == 10 ? "10":
@[User::Var_Period_loop_Start] == 11 ? "11":
@[User::Var_Period_loop_Start] == 12 ? "12": "End"
@[User::Var_Scenario_loop_Start] == 1 ? "Actuals": @[User::Var_Scenario_loop_Start] == 2 ? "Budget": @[User::Var_Scenario_loop_Start] == 3 ? "Forecast - Q1": @[User::Var_Scenario_loop_Start] == 4 ? "Forecast - Q2": @[User::Var_Scenario_loop_Start] == 5 ? "Forecast - Q3": @[User::Var_Scenario_loop_Start] == 6 ? "Actuals":@[User::Var_Scenario_loop_Start] == 7 ? "Actuals":@[User::Var_Scenario_loop_Start] == 8 ? "Actuals":"End"
@[User::Var_Scenario_loop_Start] == 1 ? "": @[User::Var_Scenario_loop_Start] == 2 ? "": @[User::Var_Scenario_loop_Start] == 3 ? "": @[User::Var_Scenario_loop_Start] == 4 ? "": @[User::Var_Scenario_loop_Start] == 5 ? "": @[User::Var_Scenario_loop_Start] == 6 ? " - LY":@[User::Var_Scenario_loop_Start] == 7 ? " - LLY":@[User::Var_Scenario_loop_Start] == 8 ? " - LLLY":"End"
@[User::Var_Start_File_Name] + @[User::Var_Determine_Scenario] + @[User::Var_Mid_FIle_Name] + @[User::Var_Determine_Period] + @[User::Var_Determine_Scenario_File] + @[User::Var_End_File_Name]
@[User::Var_Path_to_file] + @[User::Var_Determine_Scenario] + @[User::Var_use] + @[User::Var_Final_FIle_Name]
@[User::Var_Scenario_loop_Start] == 6 ? " - LY" : @[User::Var_Scenario_loop_Start] == 6 ? " - LLY" :@[User::Var_Scenario_loop_Start] == 6 ? " - LLLY" : "" -
OK, I don't know. Can't see anything obvious.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply