Re: ETL rejects records intermittently

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@xxxxxxx> wrote in message
news:v5m8u2ds0pni5tict8ep3vprh921a48de0@xxxxxxxxxx
On Tue, 27 Feb 2007 15:50:45 +0530, "Jyoti Khetan"
<jyotikhetan@xxxxxxxxxxx> 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.



.

Relevant Pages

  • Re: DTS Error EXCEPTION_ACCESS_VIOLATION
    ... >>We have some DTS jobs that runs every night called via a ... >>Package ... If this is no help, then please describe how you execute the package, ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: which authentication mechanism should I use?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >execute rather than just assigning its sql statement and execute it later.I need the result in my Activex Script. ... > 'EXIT from function if there is another instance of the same package is running ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS and MSDE
    ... that does the calling of the package as the package runs from the place calling ... I will presume that the package is stored on a SQL Server somewhere. ... The above error is not appearing the in the vb app (removed error ... I've even used the "sa" login to execute the dts pkg and still ...
    (microsoft.public.sqlserver.dts)
  • Re: Export to Text File Fails from Server Box
    ... If you are on WKSTN1 and you pick up a package from SVR1 and press execute, ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... >I should have specified in my question that in re-creating the text> connection, I did point in to a file local to the SQL Server. ... When I click on the>>> Destination tab, there is an execute button. ...
    (microsoft.public.sqlserver.dts)
  • Nested packages not firing events when executed via .NET interop
    ... This works fine on individual packages, but when I execute a package ... void PackageEvents.OnError(string EventSource, int ErrorCode, ...
    (microsoft.public.sqlserver.dts)
Loading