CODEWITHSUNDEEP
ssismsbi
nitesh
nitesh

Reputation: 41

Columns are not defined for this connection manager

When I open my flat file connection manager, I see a warning message:

Columns are not defined for this connection manager

How do I solve this issue, or is it even something I need to worry about?

Screenshot of warning message in Visual Studio

Upvotes: 2

Views: 13026

Answers (3)

toddk
toddk

Reputation: 1

I know this might sound dumb but in my case, I accidently saved the file as xlsb instead of csv. Saving the file as the correct file type resolved issue.

Upvotes: 0

Gert Duvenage
Gert Duvenage

Reputation: 21

I am doing an "online" course and during the steps of importing a flat file I also encountered it. I could not get it to work initially. Then I aborted the import and tried again and used the " as text qualifier (even though the columns in the file are separated). It worked and I could see the correct columns in preview.

Upvotes: 2

Tab Alleman
Tab Alleman

Reputation: 31775

Click "Columns" in the pane on the left and define the columns of your flat file.

Upvotes: 4

Related Questions