Solved

Error executing Sql Server Information Service

Posted on 2011-03-14
12
706 Views
Last Modified: 2012-05-11
There are 2 servers:
Server A: Database Pervasive 32 bit vers. 9.5
Server B: Database Sql 2008 64 bit
I want to copy records from one table in Pervasive db in another table structured in the same mode in server B.
From Sql server Business Intelligence Development Studio I've created a Integration Service project. In control flow there are 2 objects:
1. Sql task that empty the destination table
2. Execute package task that call the package created from the sql tool "import/export data (32 bit)"
In debugging properties of the project the property Run64BitRuntime is set to False.
When I run the project it execute all fine but at the end an error message box advise that SSID debug host has stopped working (details: AppCrash DtsDebugHost.exe).
Someone have any suggestion?


Thank you.
0
Comment
Question by:fantamen
  • 8
  • 4
12 Comments
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35137244
Your 32 bit package should be runned by 32 bit BIDS tool, the same is with dtexec.
http://msdn.microsoft.com/en-us/library/ms138023.aspx
http://msdn.microsoft.com/en-us/library/ms141766%28v=SQL.100%29.aspx
0
 

Author Comment

by:fantamen
ID: 35140538
TOday I've tested your suggestion but it failed.
I've disinstalled SQL Server 2008 64 bit and installed the 32 bit version. The package execute the transfer from table in db A to table in db B correctly but at the end appear the message "SSIS debug host has stopped working".
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35140676
It wasn't up to Server engine, it was about BIDS or dtexec only  - as stated in links I've posted.
0
 

Author Comment

by:fantamen
ID: 35140816
I don't know what to do. In this link http://social.msdn.microsoft.com/Forums/is/sqlintegrationservices/thread/ba859afa-7869-4bbd-83a3-018446f2021b I've read about a similar problem. It seems something about string fileds.
0
 

Author Comment

by:fantamen
ID: 35140890
The import data package is created from the wizard and then is added to the solution in BIDS. If I run the package during the wizard there wasn't errors. I've disinstalled all sql applications and re-installed, BIDS included. Probably con be a problem with Pervasive provider ?1?
0
 

Author Comment

by:fantamen
ID: 35147428
I recently tried with a text file as origin instead of a Pervasive table. I've transfered data from Pervasive data to text file. In this condition the package was esecuted and at the end of process no error. The idea of bad Pervasive provider can be right.... What do you think?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35147430
Can you show the output for BIDS debugger?
0
 

Author Comment

by:fantamen
ID: 35147658
This is the output:
SSIS package "SSIS_Tabelcm.dtsx" starting.
Information: 0x4004300A at Data Flow Task 1, SSIS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task 1, SSIS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task 1, SSIS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Data Flow Task 1, SSIS.Pipeline: Execute phase is beginning.
Information: 0x402090DF at Data Flow Task 1, Destination - Asa_Tabelcm [28]: The final commit for the data insertion in "component "Destination - Asa_Tabelcm" (28)" has started.
Information: 0x402090E0 at Data Flow Task 1, Destination - Asa_Tabelcm [28]: The final commit for the data insertion  in "component "Destination - Asa_Tabelcm" (28)" has ended.
Information: 0x40043008 at Data Flow Task 1, SSIS.Pipeline: Post Execute phase is beginning.
SSIS package "SSIS_Tabelcm.dtsx" finished: Canceled.

The task was executed and data transferred but at the end the error was displayed...
0
 

Author Comment

by:fantamen
ID: 35147686
It seems that something don't work well during "Post execute phase"...
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35148039
Have you tried to execute this package using DTEXEC utility? I've read somewhere that if problematic package is called from another package by using Execute Package task error handler of that package will catch errors of that problematic one.
Maybe that will help?
0
 

Accepted Solution

by:
fantamen earned 0 total points
ID: 35148534
I've tried with bad result.
I've decided to link Pervasive database to sql and to use a stored procedure to copy data from database A to database B.

Thank you for your patience
0
 

Author Closing Comment

by:fantamen
ID: 37074957
I've solved myself
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now