Solved

Error executing Sql Server Information Service

Posted on 2011-03-14
12
727 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

 

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
 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

697 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