Sql server 2008: is it possible to specify a format instead of using formatfile?

Question

USE AdventureWorks2008R2; GO INSERT INTO myTestSkipField SELECT * FROM OPENROWSET(BULK 'C:\myTestSkipField-c.dat', FORMATFILE='C:\myTestSkipField.fmt' ) AS t1; GO 

I do not want to specify formatfile !!! I just want to specify the inline format. is it possible?

Answer 1

Cannot specify format as parameter for OPENROWSET or BULK INSERT .

However, you can insert data into the view . IMO is an elegant solution.