"rajesh" <rajesh_1999@yahoo.com> wrote in message
news:031001c34f38$c7ef7db0$a501280a@phx.gbl...
> I have a dts package which takes input as text file name(
> from global variable) and then transfer the data to a
> table.I run this dts package from c# program by assigning
> different file name. Each time it loads to the same table.
>
> The new requirement has come. The input file is a
> tabdelimited file. Normally it has 4 coulmn fields. But in
> some case it may have 6 column fields.
>
> In current approch I am mapping the file column field to
> database column field.
>
> Is there a way to transfer data to database-
> 1. if tab delimited file does not have additional field
> insert null in those field to database table
> 2. if additional filed are present pass all the data to
> database.
>
> currently if a make a dts with total text file field 6 and
> map it to database table with field, It is working fine
> only if input text file has 6 column. If it has only 4
> column it gives error saying (rest two field not present)
>
>
> How can I resolve the issue within DTS.
> I will appreciate any help.
>
> thanks
> raj