Link to home
Start Free TrialLog in
Avatar of enrique_aeo
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
Transact-SQL
The bcp utility
Replication
Avatar of Matthew Kelly
Matthew Kelly
Flag of United States of America image

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.
Avatar of enrique_aeo
enrique_aeo

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of Matthew Kelly
Matthew Kelly
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial