Create a new table from csv file using SSIS

#1

I was able to create a new table using dts package and an incoming
flat file that had col names in the first row. Can this be done with
SSIS?

#2

Yes, use the Data Flow Task , you'll probably need to create some dynamic
variables
--

Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com

"k4" <stburks (AT) gmail (DOT) com> wrote

Quote:

I was able to create a new table using dts package and an incoming
flat file that had col names in the first row. Can this be done with
SSIS?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Create a new table from csv file using SSIS

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Create a new table from csv file using SSIS - 02-06-2008 , 08:39 AM

Re: Create a new table from csv file using SSIS - 02-07-2008 , 08:07 AM