I need to create a package that pumps two different types of CSV files into
database.The only thing I know is that CSV files are definitely comma
seprated ,might be double-qoute delimitted or not ,in one format there is 10
fields and in the other one there is 12 fields.

Is there some ideas that can help?

Thanks

So you build two data pump tasks that handle these files.

You have an Active Script task that checks the file and asks "What type are
you?"

The answer will determine which path in the workflow gets turned on or off.

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"J-T" <J-T (AT) nospam (DOT) com> wrote