cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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}

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

It sounds like your are importing from or rather to a TXT file. I would review the package and make sure the data sources are correct.