Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

When should I use one versus the other? For instance, let's say I have 20 comma delimited, denormalized text files and I want to transform the data and load it into normalized SQL Server tables.

share|improve this question

closed as primarily opinion-based by Jim G., GlenH7, World Engineer Jul 29 '13 at 14:19

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise.If this question can be reworded to fit the rules in the help center, please edit the question.

    
    
Sharing your research helps everyone. Tell us what you've tried and why it didn’t meet your needs. This demonstrates that you’ve taken the time to try to help yourself, it saves us from reiterating obvious answers, and most of all it helps you get a more specific and relevant answer. Also see How to Ask –  gnat Jul 29 '13 at 6:14
1  
Voting to put on hold to give you a moment to revise your question. Please add some more details around your tasks and what you have researched so far. –  GlenH7 Jul 29 '13 at 11:18

2 Answers 2

up vote 1 down vote accepted

What are the size of the files? T/SQL is pretty fast, I've done million record imports in less than three seconds. Is this 'once' or 'scheduled'?

SSIS is for complicated scenarios. SSIS can schedule FTPs, external commands (such as ZIP and unZIP), branching paths on step failures, etc. Therefore it isn't as simple as importing data, it's the entire 'overnight data exchange process'.

Given that you have CSVs (presumably with column names) much of your work would appear to have been done already. If you don't need to filter out bad records you're just doing 'group bys' to generate validation fact tables.

More information is needed.

share|improve this answer
    
Thanks for the response. All of the data is valid so I don't have to check for errors or anything of such, and periodically new valid text files will be added to the directory to be loaded into the database. The files are relatively small (the biggest is 7Mb) and at the moment there's only 52 text files. –  Robert Jul 28 '13 at 16:11
    
If these files are the same over and over, then you can set up SSIS scripts to do them periodically. If DBA involvement is necessary to deal with unpredictable names or new table schemas, SSIS won't do much for you. –  Meredith Poor Jul 28 '13 at 19:35

There has been a discussion on a similar subject on Linked in .

From what you said l would use TSQL.

One of the features l liked about SSIS was the ability to include some information regarding errors. So if the package crashed l knew where to look and had some idea why. Similar idea to this posting over kill for 20 CSV files. Just another way to solve a challenge.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.