• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 833
  • Last Modified:

Error executing Sql Server Information Service

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
fantamen
Asked:
fantamen
  • 8
  • 4
1 Solution
 
Daniel_PLDB Expert/ArchitectCommented:
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
 
fantamenAuthor Commented:
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
 
Daniel_PLDB Expert/ArchitectCommented:
It wasn't up to Server engine, it was about BIDS or dtexec only  - as stated in links I've posted.
0
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!

 
fantamenAuthor Commented:
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
 
fantamenAuthor Commented:
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
 
fantamenAuthor Commented:
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
 
Daniel_PLDB Expert/ArchitectCommented:
Can you show the output for BIDS debugger?
0
 
fantamenAuthor Commented:
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
 
fantamenAuthor Commented:
It seems that something don't work well during "Post execute phase"...
0
 
Daniel_PLDB Expert/ArchitectCommented:
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
 
fantamenAuthor Commented:
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
 
fantamenAuthor Commented:
I've solved myself
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 8
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now