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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.