Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Error executing Sql Server Information Service

Posted on 2011-03-14
12
Medium Priority
?
780 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
Technology Partners: 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!

 

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
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
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

596 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