Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
5
Impact
~1k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
May
25
comment Is there a standard language/interface for programmatic ETL in SQL Server?
But more to the point, I'm interested in a purely programmatic approach to this problem. I'm not surprised we're using an ETL GUI here, but I find it hard to believe that all the hotshot little startups out there (many of which must have ETL needs) are using SSIS and Informatica. What tools are they using?
May
25
comment Is there a standard language/interface for programmatic ETL in SQL Server?
@Sankar I updated my question with an example of the problems we're having.
May
25
comment Is there a standard language/interface for programmatic ETL in SQL Server?
I don't believe the learning curve is a problem. I know how to do the tasks I want to do in SSIS. I'm looking into a new process because the solutions I've found are repetitive, fragile and needlessly complex.