Hi,

Is there a way you can have the primary key output from the system that produces the error file? This would essentially solve your problem. If the answer...

Hi Phil,

Sorry I missed it. I'll check that out

Thanks!

Strick

Phil Parkin (8/10/2010)

---

Here[/url] is a nice article, though probably not applicable to your scenario. Worth a read anyway.

Code reuse in SSIS is not as easy as it could be. To...

GilaMonster (6/28/2010)

---

stricknyn (6/28/2010)

---

Ran the check table with repair and still got...

GilaMonster (6/28/2010)

---

Doesn't sound like corruption, sounds like blocking.

If you query the table then, in another query window query sys.dm_exec_sessions. Find the row that refers to the query that you're running...

Hi thanks for your response. Unfortunately this didn't work. Ran the check table with repair and still got the same error message.. Also ran check db with...

Hi thanks for your response.

Yes, I want to save time and also utilize the server's resources since they are available. Sounds like I may have to go the third...

Hi guys,

Well I feel silly. I knew all columns in Sript component has a IsNull property, but I always assumed it was a readonly (Get) property. As it...

Dan.Humphries (6/9/2010)

---

Sorry update was a poor choice of word. what I meant to ask more is to clarify that when the record is clean and outputed to SQL any...

Dan.Humphries (6/9/2010)

---

If CleanRecord then

Row.DirectRowToCleanOutput() 'This works fine

Else

Row.DirectRowToErrorOutput()

Row.PAIDDATE = #11/6/1984#

Row.DirectRowToScrubOutput()

End if

So PAIDDATE gets updated Even if Row.DirectRowToCleanOutput() is updated? I assum the paiddate is some other value before this trasform is...

Hello,

Are you feeding any arguments from your SSIS package Execute Process task? It's also possible that the arguments you're feeding may by incorrect or may not match the arguments...

Reason why I asked my earlier question was because sometimes programmers forget to return the status code of 0 or 1 from their VB or C# programs when they are...

Gotcha, thanks.

Strick

Hello,

The process that you're executing. Is it a VB or C# program?

Strick

Hi,

Actually found that they have a Advantage .NET Data Provider which looks to be more efficient at reading the data than the older odbc technology. It works really well...