tags:

views:

8

answers:

0
Q: 

How to add a text in footer in ssis using pivot.

Hi All,

  How to add a text in footer in ssis using pivot. And also getting an error while mapping in pivot.

Error at Data Flow Task [Pivot[1]]: Output column "name" (69) cannot be mapped to PivotKey input column.

Any suggestions.

Thanks in Advance.

related questions

Performance difference - Script Task
blank to numeric conversion derived column
Import Excel data to SQL Server
SSIS Lookup component only returns matching rows when using partial mode
Return dataset in dataflow
timestamp in C#
Use SSIS to import binary data in XML file
Error in retrieving data from Excel File
How to get 2 data sources to merge in SSIS?
execute SSIS package
Store Dataset to DTS Variable
About Script Task
Script Task - File Manipulation
SSIS how to split a single record in to two different records?
Script Task - Add Reference Issue
Tool for generating flat files from SQL objects dynamically
SQL Server 2008 - Script Data as Insert Statements from SSIS Package
Lookup Transformation Task
How can we abort the post in ProcessInputRow() event in SQL SSIS Script Component?
Using SSIS to import a CSV File.
What is SSIS order of data transformation component method calls
The version of component "x" is not compatible with this version of the DataFlow.
SQL Server Integration Services SSIS 2005 - How do I see all the rows in a data viewer?
Producing a revenue forecast in SQL
SSIS - Change Null columns to empty strings