Avatar of enrique_aeo
 asked on

Options for ETL: Transact-SQL

Hi experts,

I am reading about: Options for ETL, one is Transact-SQL
Can you give me an example about Transact-SQL?

This is the complete list:
Microsoft SQL Server Integration Services
The Import and Export Data Wizard
The bcp utility
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008SSIS

Avatar of undefined
Last Comment
Matthew Kelly

8/22/2022 - Mon
Matthew Kelly

Transact-SQL is literally just an extension of the SQL database language: http://en.wikipedia.org/wiki/Transact-SQL

Microsoft has different SQL syntax than say MySQL or NoSQL for example depending on the functions. The basics are the same (SELECT, WHERE, etc) but specialized functions exist.

Think of it as the difference between using PHP v4 or PHP v5, or .NET 3.5 vs .NET 4. Basically same syntax with different functions available.

My question is not very clear.

My question is: how can I do ETL operations using Transact SQL.
It is as with: The Import and Export Data Wizard
but do not understand how I can do it with Transact SQL
Matthew Kelly

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy