July 25, 2009 at 2:42 am
How can we Handle Empty Excel File load Through SSIS ?
The Business Problem
To provide some background, the component is being developed for a Finance company
They provide an excel file of all Revenue & Expense Details filed within the last quarter. This file is replaced every quarter containing all the new Revenue & Expenses from the previous quarter. The name of the Location, its Account, Month Name, & Value Details provided are specified in this file.
This data is loaded through Scheduled SQL Jobs. But If Business provides an empty excel file, The Scheduled SQL Job using SSIS Package is failing.
To recap,
SQL Server Job runs SSIS Package using dtexec command to load the data from excel.
our SSIS ETL process will accomplish three basic processes:
Extract
Read from an Excel file
Transform
Adding some default columns and
Load
loading into a SQL table
Please provide a solution...
July 25, 2009 at 2:49 am
What do you mean by 'empty' exactly?
a) No file
b) File exists, but no data or meta data in it
c) File exists, column headings exist, but no data rows
d) Something else?
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
July 25, 2009 at 12:10 pm
Yes File Exists, Columns names are present but no data
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply