Error Output for SQL Server Destination

I'm in the process of running some tests to determine which method is faster...

I created a data flow task OleDB Source -> Data Conversion -> OleDb Destination. Error outputs from the OleDB destination is sent to a flat file destination. This works great.

I'm importing millons of rows and found that using SQL Server Destination (local) is much faster than the OleDB Destination. However, I have not figured out how to output errors to a flat file destination like I did when using the OleDB destination.

Is there any way to trap errors in a flat file when using a SQL Server Destination?

Thanks!

NLC

OK..I found the answer to my problem. Books online indicates that SQL Server destination does not support an error output. I guess I'll have to use OleDB destination instead.

NLC

error on insert...

I'm getting an error on the insert... I recently when to switch over from the @.param.Oledb type and am now using the ? for the values... Well I switched my updates and now am working on the inserts, but I am getting the error from this statement. I tried taking off the VALUES portion, but that didn't work either...

queryString = "INSERT INTO [griff30_24_stats] ([W_Rec], [Opponent], [L_Rec], [points], [done]) VALUES(?, ?, ?, ?,)"

Dim cmd as new OleDbCommand(queryString,dbConnection)

cmd.Parameters.Add("W_Rec",OleDbType.VarChar).Value = "Y"

'''It looks like you have 5 columns but only 4 question marks. Add afinal question mark (?) after that last comma and that should help.
|||

Thats a copy paste error. I have 5 "?'s" in the code, but I was going wild with the backspace. I still don't see why it's giving me the error is there a different style??

|||Can you show us a little more of the code as well as the exact error message?|||

Man, it was a little syntax error, I was missing a '(apostrophe in a statement). The little things I look over.

ERROR ON CLIENT

Hi I am working with SQL server 2000
all the clients work perfect but in one client I have the following error:
SQL Server OLEDB provider support error
X Unable to load SQL Server OLEDB provider resource DLL. The application
cannot continue
and asking me for OK
after many OK my application starts and works perfect.
Any ideas?
Hi
Have you run the MDAC component checked and made sure that the versions of
MDAC are consistent?
http://www.microsoft.com/downloads/r...splayLang= en
John
"pOWER lINE" wrote:

> Hi I am working with SQL server 2000
> all the clients work perfect but in one client I have the following error:
> SQL Server OLEDB provider support error
> X Unable to load SQL Server OLEDB provider resource DLL. The application
> cannot continue
> and asking me for OK
> after many OK my application starts and works perfect.
> Any ideas?
>
>

ERROR ON CLIENT

Hi I am working with SQL server 2000
all the clients work perfect but in one client I have the following error:
SQL Server OLEDB provider support error
X Unable to load SQL Server OLEDB provider resource DLL. The application
cannot continue
and asking me for OK
after many OK my application starts and works perfect.
Any ideas?Hi
Have you run the MDAC component checked and made sure that the versions of
MDAC are consistent?
http://www.microsoft.com/downloads/...La
ng=en
John
"pOWER lINE" wrote:

> Hi I am working with SQL server 2000
> all the clients work perfect but in one client I have the following error:
> SQL Server OLEDB provider support error
> X Unable to load SQL Server OLEDB provider resource DLL. The application
> cannot continue
> and asking me for OK
> after many OK my application starts and works perfect.
> Any ideas?
>
>

ERROR ON CLIENT

Hi I am working with SQL server 2000
all the clients work perfect but in one client I have the following error:
SQL Server OLEDB provider support error
X Unable to load SQL Server OLEDB provider resource DLL. The application
cannot continue
and asking me for OK
after many OK my application starts and works perfect.
Any ideas?Hi
Have you run the MDAC component checked and made sure that the versions of
MDAC are consistent?
http://www.microsoft.com/downloads/results.aspx?productID=&freetext=mdac&DisplayLang=en
John
"pOWER lINE" wrote:
> Hi I am working with SQL server 2000
> all the clients work perfect but in one client I have the following error:
> SQL Server OLEDB provider support error
> X Unable to load SQL Server OLEDB provider resource DLL. The application
> cannot continue
> and asking me for OK
> after many OK my application starts and works perfect.
> Any ideas?
>
>