Skip to Content
0
Former Member
Jan 25, 2016 at 09:07 AM

Import SQL error "Number of input columns..."

1143 Views

Hi,

When I try to load DM package “Import SQL” or “Import SQL into Fact Table” I get the following errors. I have connection to the database and the table I am trying to import from. I am a bit concerned that the first error points to a text file. Could it be that I have missed some part in the setup? Any ideas out there? (I am running BPC MS 10.1)

Regards

Mikael

An error occurred while executing a package.

Package Error Events:

ErrorCode = -1071636453

Source = SQLToTxt

SubComponent= TextFile [44]

Description = The number of input columns for TextFile.Inputs[Flat File Destination Input] cannot be zero.

IDOfInterfaceWithError= {8266A638-4A4B-4A82-8648-F54B5B879197}

Package Error Events:

ErrorCode = -1073450901

Source = SQLToTxt

SubComponent= SSIS.Pipeline

Description = "TextFile" failed validation and returned validation status "VS_ISBROKEN".

IDOfInterfaceWithError= {8266A638-4A4B-4A82-8648-F54B5B879197}

Package Error Events:

ErrorCode = -1073450996

Source = SQLToTxt

SubComponent= SSIS.Pipeline

Description = One or more component failed validation.

IDOfInterfaceWithError= {8266A638-4A4B-4A82-8648-F54B5B879197}

Package Error Events:

ErrorCode = -1073594105

Source = SQLToTxt

SubComponent=

Description = There were errors during task validation.

IDOfInterfaceWithError= {770FE594-F52C-4B5A-81F9-FB7B4B52974F}