Noob Diving into DTS Packages

Is it possible to import a CSV and break the contents into multiple
tables?
On Apr 9, 3:59 pm, "JGiotta" <jdgio...@.gmail.com> wrote:
> Is it possible to import a CSV and break the contents into multiple
> tables?
Use a staging table for that
Denis the SQL Menace
http://sqlservercode.blogspot.com/
|||Thanks, I'll look into it.
Do you recommend any book that cover DTS well?
|||On Apr 9, 5:05 pm, "JGiotta" <jdgio...@.gmail.com> wrote:
> Thanks, I'll look into it.
> Do you recommend any book that cover DTS well?
Here is one I like
Professional SQL Server 2000 DTS (Data Transformation Services
by Mark Chaffin , Brian Knight , Todd Robinson
[url]http://www.amazon.com/gp/product/0764543687/102-5735017-0910517?ie=UTF8&tag=sql08-20&linkCode=xm2&camp=1789&creativeASIN=0764543687[ /url]
Denis the SQL Menace
http://sqlservercode.blogspot.com/
|||Thanks again