question

VishalhSingh avatar image
VishalhSingh asked

SQL Metal (or metl) command, are they exists?

Is there any TSQL command called METL or METAL (I am not aware of any). One of the guy was arguing on this proving the command used for file merge or to read from flat files (similarly like Bulk read/write)
tsqldatabase-designfileflat-file
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
METL was apparently a candidate name for SSIS, post DTS
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image David Wimbush commented ·
+1 for top trivia skillz!
0 Likes 0 ·
VishalhSingh avatar image VishalhSingh commented ·
Yup Kev, I read that in Brian Knight's book "Professional SQL Server 2005 Integration Services". The guy mentioned this in such a contest that this is TSQL command using which one can read from a flat file, perform some logical operation and output them in file or any other format. CRAP - I was wondering all he time since then as I never hear of this for file based operation using TSQL. +1 for top trivia skill (echo with David Wimbush)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.