October 25, 2012 at 11:06 am
Hi to all.
I have a problem with a SSIS in SQL SERVER 2008 R2.
I wrote a SSIS that contains a Data Flow that reads via LINKED SERVER a OpenEdge Progress DB and write records to a table of SQL SERVER 2008 R2.
I encontered this error - 1071607685
I did a research to understand what error is , reading this link http://msdn.microsoft.com/en-us/library/ms345164.aspx
In that link , MSDN says that is 'DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE
' No status is available.
This Error description is not very useful...
What can i do ???
I put a flow to redirect rows with error but i did not notice anytihing of very strange...about that data rows....it seems all okay...
I put also a Data Viewer TO ANALYZE records that i redirect in a table that contains only errors...
Any suggest ???
Has anyone encountered the same error ???
Regards in Advance to anyone that can help me...
Ciao Mauro,.
October 25, 2012 at 11:27 am
If you can, you would be better off creating a direct connector to the source db rather than using a linked server. If you have to stay with the linked server approach you might try using an OPENQUERY.
One other thing to consider is to run all columns through a Data Conversion to specifically define the types. Sometimes with disparate systems the types do not always exactly line up and values that look fine can cause intermittent issues.
October 25, 2012 at 1:15 pm
Hi Many thanks for kind reply.
I tried to use a direct connection but with OPEND EDGE ODBC I was not able.
So i tried with LINKED SERVER.
I am considering to buy DATADIRECT ODBC or better try test evalustion version before.
I will do waht you advice me ..i never use object DATA CONVERSION COLUMN i will try to understand ho wo to do it..
I will inform you about my tests.
Thanks.
Ciao Mauro.
October 25, 2012 at 1:34 pm
Ciao.
I add also that i am usign linked server and OPENQUERY.
This table is enough big and the query is not so simple...she joins 4-5 tables....
Open Edge 10.2.b has an ODBC driver, but when i try to create a SSIS and a new connction manager, i encontered an error of MISMATCH between driver ODBC and application SSIS.
i WILL try to install 32 bit and 64 bit version of it and also the evaluation version of DATADIRECT ODBC versions (Many people say better and good performances).
But i do not know the cost of it and so,,,
I will try to use your suggest (DATA CONVERSION)
I did other SSIS with LINKED SERVER (maximum 4).
I am interested to create SSIS with DB SOURCE via ODBC because i ha ve my SSIS that use flat file.
If iwas quiet with ODBC SSIS, i will do better my work, programming only on SQL SERVER 2008 R2 64 bit version Server, and no programming also to PROGRESS ERP to produce flat file to load.
NONE help me about to consider how to connect directly OPEN EDGE DB.
My scenario:
Windows Server 2008 64 bit
Sql server 2008 r2 64 bit
DRIVER ODBC Opend EDGE 10.2.B 32 bit but 64 bit version it does not work...
So waht can i do ...
Try another DATADIRECT ODBC...but i do not know if my company want to buy them...
Sorry for long explanation, Many thanks if you know anyone with my problems...i am here.
Ciao again.
October 26, 2012 at 7:52 am
Ciao.
I did tests about what you told me...
I installed a Driver ODBC trial version of 15days instead of working with LINKED SERVER object.
I choose DATADIRECT driver.
But i still have problems with error numer -1071607685
This erro code is STATUS NOT AVAILABLE so can i do ???
I am hopeless 🙂
Performance with driver odbc connected directly are better but still remain problems with this error.
I put object Data Conversion in my DTSX and redirect rows.
Redirect rows seem okay...also ERROR COLUMN is 0....
Any idea , if it is possible ???
Thanks a lot for your help.
Ciao.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply