debugging the ole db destination?

I have an OLE DB destination which should insert data into a table named in an SSIS variable. When I run the package, I don't get any errors and I have a data viewer which shows that the data is reaching the OLE DB destination. However, the data isn't being inserted into the destination table.

Can someone suggest how I should go about debugging this?

Thanks in advance.

Hi Duane,

you might try SQL Server Profiler and monitor OLEDB and T-SQL events

--
SvenC

|||

SvenC wrote:

Hi Duane,

you might try SQL Server Profiler and monitor OLEDB and T-SQL events

--
SvenC

Thanks for your reply. I figured out what I was doing incorrectly. I was using the refresh function in SQL Server Management Studio. However, it wasn't working. I'm not sure if it's a bug or a problem with my installation.