June 18, 2008 at 4:49 am
I have an SSIS package which exports the data to an Excel file using Excel Destination component.
I have created a job schedule, which will run this package .
While executing the job, only the column header are generated in the file,
the below error is reported.... Please help....
Progress: 2008-06-18 11:39:26.91 Source: Preparation SQL Task Executing query "CREATE TABLE `Query` ( `gender_cat` LongText, `des".: 100% complete End Progress
Progress: 2008-06-18 11:39:27.05 Source: Data Flow Task Validating: 0% complete End Progress
Progress: 2008-06-18 11:39:27.21 Source: Data Flow Task Validating: 33% complete End Progress
Progress: 2008-06-18 11:39:27.27 Source: Data Flow Task Validating: 66% complete End Progress
Progress: 2008-06-18 11:39:27.27 Source: Data Flow Task Validating: 100% complete End Progress
Error: 2008-06-18 11:39:27.27 Code: 0xC00470FE Source: Data Flow Task DTS.Pipeline
Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW.
The product level is insufficient for component "Destination - Query" (46). En... The package execution fa... The step failed.
June 18, 2008 at 5:12 am
Add package logging. This will assist you to troubleshoot the error within the package
~PD
June 18, 2008 at 5:25 am
where should i add this package logging?
can you tell me in detail?
thanks
June 18, 2008 at 5:28 am
Readup in BOL on package logging.
This will provide you with a detailed error message which you can use
June 18, 2008 at 8:56 am
That error looks like you have not installed the full version of integration services. only few components of SSIS might have been installed on your box.
June 19, 2008 at 7:08 am
Can u verify the number of rows or columns is not exceeding the limit of excel.
June 19, 2008 at 7:30 am
Verified, it is not exceeding the limits.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply