How to use a XSD schema definition file to bulk insert records with fixed-width columns into a database?

I have an XSD schema definition file that I "crafted" using Access 2007 on my flatfile with fixed-width columns/fields. Using an SSIS package, I would like to bulk insert the data from the flat file to a table in TeraData. From what I've read both here and in the MSDN library, there's a BCP utility with which I can do BULK INSERT. Only looks like it could be tricky to make changes in the XSD from Access so it could be used in BCP. Has 开发者_JAVA技巧anyone done anything similar? Truth is, there's no XML file or data because, if we were to format the flat file, it would be many more Gb of data than I'd like to deal with! :)

There's an XML Task control flow item in SSIS that may work for you. This will perform selected operations on your XML file. Look here for information.

There's also an XML Source component in the Data Flow task. This component will load your data into the data flow where you can then export to the desired destination. More information can be found here.