Thursday, January 8, 2009

MSSQL 2005 SSIS Packages - Mostly Data Flow

Lately, I've been learning the ins and outs of Visual Studio for Sql Server Intergration Services (SSIS).  And so far it is a much improved beast compared the DTS packages and its editor.  But I got to ask, why aren't the Flat File Connections using the FMT file that bulk inserts use.  Why not have one standard why of defining a file layout.  Why oh why??