April 6, 2009 at 10:07 am
Hi,
I run several package from BIDS 2008 that retrieve data from Foxpro, Oracle,... to add to a SQL server 2008...It works fine.
I use a ODBC driver to retrieve data from a BASIS db...same kind of work.. sample package with a source and a destination (SQL Server 2008).
When I run/debug it, around the middle of the process (boxes are yellow), I have a MS Visual C++ Debug Library window with a Debug Assertion Failed. on the program DtsDebugHost.exe for file dbgheap.c
I choose Ignore and it continue and everything is fine. Try to run it from MS SQL server Integration service (MSDB). same thing.
Relate to memory....
For one table, I have the message if I click Preview... Ignore and I a the preview results. For another table, I don't have it in the Preview...
I'm also forced to use a 'Select .. from Table' in the ADO.NET source because when try over Table View.... it never display tables...
Someone has a idea how to resolve it ?
thanks
Al
April 7, 2009 at 10:28 pm
Al, I suspect the error lies in the ODBC library you're using to access the data. In a recent project I was retrieving data from an old system and had to use the vendor-supplied ODBC driver, and had to create a very interesting .NET script to work around the quirkiness of the driver. It could be worth your time to contact the vendor to see if a new or patched driver is available.
hth,
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
April 8, 2009 at 7:19 am
Hi Tim,
From everything I read. you are probably right... and I wonder if it could be related too to the way the ODBC works and manage the information coming in and out.
Right now, the data is on another server...
I did a test and was able to copy a demo DB on the server where SSIS is and was very successful to run a package without any error using the same ODBC driver...
Retreiving data by Excel is possible but Excel crash after we close the spreadsheet. With the demo DB locally, the Excel is working fine... I tried also with Import-Export tools.. and I have the problem.
Must say that the server were SSIS is a a virtual machine with Windows 2008, SQL2008 and VS BI 2008... Do you think the virtual machine (VPC) can make a difference too ?
Al
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply