<jyotikhetan@hotmail.com> wrote:

>Hello,
>
>The problem I am facing is quite weird. When I execute the SSIS package
>sometimes it rejects the correct data as well. And when the package is
>executed again, the data which it rejected last time is not rejected this
>time. Also sometimes the package is executed and no data is rejected for the
>first time but in the subsequent execution of package with the same data, it
>rejects some of the records.
>
>I am relatively new to SSIS. Please help me out. Thanks in advance.

"JXStern" <JXSternChangeX2R@gte.net> wrote in message
news:v5m8u2ds0pni5tict8ep3vprh921a48de0@4ax.com...
> On Tue, 27 Feb 2007 15:50:45 +0530, "Jyoti Khetan"
> <jyotikhetan@hotmail.com> wrote:
>
>>Hello,
>>
>>The problem I am facing is quite weird. When I execute the SSIS package
>>sometimes it rejects the correct data as well. And when the package is
>>executed again, the data which it rejected last time is not rejected this
>>time. Also sometimes the package is executed and no data is rejected for
>>the
>>first time but in the subsequent execution of package with the same data,
>>it
>>rejects some of the records.
>>
>>I am relatively new to SSIS. Please help me out. Thanks in advance.
>
> What kind of data, ascii flat or csv import?
>
> Because I've seen that behavior in DTS, it's apparently a problem with
> the OLEDB connection/driver. One workaround is to use the old ODBC
> connection, it uses the same driver but apparently it at least gives
> another data path and has worked for me.
>
> J.
>

"Jyoti Khetan" <jyotikhetan@hotmail.com> wrote in message
news:uewSFnxWHHA.5008@TK2MSFTNGP05.phx.gbl:

> The data source is the SQL SERVER 2005 table. We first dump the data from
> the source SQL SERVER 2005 database to the staging environment and then
> cleanse it. During cleansing sometimes it rejects the correct data as well.
> And this too on the adhoc basis. I mean sometimes it rejects some of the
> records and sometimes the same records are cleansedd successfully. I dont
> think it has anyting to do with the OLEDB connection/driver.
>
> "JXStern" <JXSternChangeX2R@gte.net> wrote in message
> news:v5m8u2ds0pni5tict8ep3vprh921a48de0@4ax.com...
> > On Tue, 27 Feb 2007 15:50:45 +0530, "Jyoti Khetan"
> > <jyotikhetan@hotmail.com> wrote:
> >
> >>Hello,
> >>
> >>The problem I am facing is quite weird. When I execute the SSIS package
> >>sometimes it rejects the correct data as well. And when the package is
> >>executed again, the data which it rejected last time is not rejected this
> >>time. Also sometimes the package is executed and no data is rejected for
> >>the
> >>first time but in the subsequent execution of package with the same data,
> >>it
> >>rejects some of the records.
> >>
> >>I am relatively new to SSIS. Please help me out. Thanks in advance.
> >
> > What kind of data, ascii flat or csv import?
> >
> > Because I've seen that behavior in DTS, it's apparently a problem with
> > the OLEDB connection/driver. One workaround is to use the old ODBC
> > connection, it uses the same driver but apparently it at least gives
> > another data path and has worked for me.
> >
> > J.
> >