Solved

Error executing Sql Server Information Service

Posted on 2011-03-14
12
702 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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

747 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

10 Experts available now in Live!

Get 1:1 Help Now