0

I am loading multiple excel files into multiple SQL server table.

these excel files are the city, state, etc. Is it possible to create a single flat file connection? currently, I am creating for city and state and for other src. attached the screenshot for better understanding.

enter image description here

Improve this question

1 Answer 1

Reset to default
1

If all of the source files are structured exactly the same (number of columns, data types, header rows, etc.), it would be possible to re-use a single flat file connection.

In general, though, the best practice is to create a connection for each file. It makes the package easier to understand in a year or two when you, or someone else, has to open it up again to fix or update it. It will also make it much easier to fix later if one or more of the files ends up changing (new columns, etc.).

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Further to Eric's answers here is the link that shows how to do it: mssqltips.com/sqlservertip/4165/…

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.