free case study: BillyJohn's unbiased review of SSIS
Would you like to learn about products from people using them now? Simplify your research with trusted advice from people like you.
Download this FREE Data Integration case study, based on BillyJohn's UNBIASED USER EXPERIENCE with SSIS:
Where should we email your case study?
SSIS review
BillyJohn
Data Engineer at DataHyv
It's easy to use but setting up a large number of tables and columns can get...
SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this...
Since 2012, we've had 816,406 professionals use our research.