Error on dataflow task
-
I am atempting to read an xml file into a tempory recordset ( purely a learning curve ) and thus far have created a project, added a XML Source task and used that task to create a XSD. The XSD have several elements. I have also added a Import column task, and referenced the input Output selection as follows
Output is referenced to the XML sourve output of Header
Input is referenced to Inport Column
In the advanced editor for the inport column, i select the fields i require from the avalible input Columns under the input Columns tab. i start comming up with errors as follows
Error at Data Flow Task [Import Column [1026]]: ther "input column" reporttype" (1051)" references output column ID 0, and that column is not found on the output
this error has occured for all input columns i have ticked
ok can anybody explain to me in english what this means and how to rectify it ?
Thank you in advance for any assistance
-
It sounds like you linked up the tasks before you defined the columns to be included. Drop the link between, then set the columns, then reattach the link. It should work better, if I'm reading what you've got correctly.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Grant,
I have tried that , i deleted the link between the tasks ( XML Source task and Import Column task ), now when i go into Import Column task it shows no avalible input columns
im at a total loss now,
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply