Search


	Podcast:		voiceofthedba's podcast
	Episode:		Brush Up on Your ETL Skills
	Category:		Technology
	Duration:		00:02:26
	Publish Date:		2018-02-20 20:00:00
	Description:		Many of us that work with data will find requests and demands to import or export data at some point. Plenty of us have regular processes that perform these actions, and we may regularly troubleshoot or enhance these activities. In fact, I know some people have a full time, or nearly full time, position just dealing with ETL operations. Working with data in disparate formats and the myriad of inconsistencies even when formats are known is a challenge. Integration Services is a useful tool, but many us find that we need to pre or post process data separate from a simple import or export. Some of us may prefer using T-SQL or other languages, such as R or Python, to process data rather than programming SSIS. It seems that I often find that every client wants a slightly different format or change to their data that a simple query export won't handle. Read the rest of Brush Up on Your ETL Skills
	Total Play:		0