Problem with installing SQL2KASP3 in SP3a

In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
fine, but
when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
occurred during
the move data process:-145.
Any help would be appreciated.
Do you actually have Analysis Services installed and running?
If not, you shouldn't be installing SQL2KASP3, which is meant only for
Analysis Services.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Daniel Callahan" <djcallahan@.cox.net> wrote in message
news:u9$kFfxIEHA.3248@.TK2MSFTNGP12.phx.gbl...
> In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
> fine, but
> when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
> occurred during
> the move data process:-145.
> Any help would be appreciated.
>
>
|||Daniel,
As a followup to what Aaron mentioned, see
PRB: Analysis Services 2000 Service Pack 3 Setup Is Not Successful Because
the RootDir Value Is Missing
http://support.microsoft.com/?id=814462
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Daniel Callahan" <djcallahan@.cox.net> wrote in message
news:u9$kFfxIEHA.3248@.TK2MSFTNGP12.phx.gbl...
> In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
> fine, but
> when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
> occurred during
> the move data process:-145.
> Any help would be appreciated.
>
>

Problem with installing SQL2KASP3 in SP3a

In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
fine, but
when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
occurred during
the move data process:-145.
Any help would be appreciated.Do you actually have Analysis Services installed and running?
If not, you shouldn't be installing SQL2KASP3, which is meant only for
Analysis Services.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Daniel Callahan" <djcallahan@.cox.net> wrote in message
news:u9$kFfxIEHA.3248@.TK2MSFTNGP12.phx.gbl...
> In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
> fine, but
> when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
> occurred during
> the move data process:-145.
> Any help would be appreciated.
>
>|||Daniel,
As a followup to what Aaron mentioned, see
PRB: Analysis Services 2000 Service Pack 3 Setup Is Not Successful Because
the RootDir Value Is Missing
http://support.microsoft.com/?id=814462
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Daniel Callahan" <djcallahan@.cox.net> wrote in message
news:u9$kFfxIEHA.3248@.TK2MSFTNGP12.phx.gbl...
> In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
> fine, but
> when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
> occurred during
> the move data process:-145.
> Any help would be appreciated.
>
>sql

Problem with installing SQL2KASP3 in SP3a

In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
fine, but
when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
occurred during
the move data process:-145.
Any help would be appreciated.Do you actually have Analysis Services installed and running?
If not, you shouldn't be installing SQL2KASP3, which is meant only for
Analysis Services.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Daniel Callahan" <djcallahan@.cox.net> wrote in message
news:u9$kFfxIEHA.3248@.TK2MSFTNGP12.phx.gbl...
> In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
> fine, but
> when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
> occurred during
> the move data process:-145.
> Any help would be appreciated.
>
>|||Daniel,
As a followup to what Aaron mentioned, see
PRB: Analysis Services 2000 Service Pack 3 Setup Is Not Successful Because
the RootDir Value Is Missing
http://support.microsoft.com/?id=814462
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Daniel Callahan" <djcallahan@.cox.net> wrote in message
news:u9$kFfxIEHA.3248@.TK2MSFTNGP12.phx.gbl...
> In SQL Server Service Manager, I stopped the server, Installed SQL2KSP3
> fine, but
> when installing SQL2KASP3 in SP3a it gets to 99% and says SEVERE:An Error
> occurred during
> the move data process:-145.
> Any help would be appreciated.
>
>

Problem with getting up to date MSDE version using Service Pack 3a

I removed (as far as I can tell) all versions of MSDE from my
computer. This was confirmed when I examined the installed programs on
the 'Add or remove programs' screen
If I then use the files from my SP3a disk (installed on my D drive) to
apparently successfully install a new default instance of MSDE and I
subsequently check the version I get the following details:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on
Windows NT 5.1 (Build 2600: Service Pack 1)
In other words I do not seem to have the up to date Service Pack 3
version installed.
My questions are:
1. Is this message misleading or does it mean that I have failed to
install the SP3a package for some reason?
2. I am using SELECT @.@.Version to get the version details- is this
appropriate?
3. Is there any other way I can check whether I have SP3a properly
installed?
(The command line instruction I am using is
setup SAPWD=Abc/def/ghk1 SECURITYMODE=SQL
I have tried to update it further using the command line
setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=sa
UPGRADEPWD=Abc/def/ghk1 DISABLENETWORKPROTOCOLS=1
This also seems to work to the extent that a screen is opened up and
it finishes properly. But again when the same version details are
obtained, no sign of it being upgraded to SP3a
Best wishes, John Morgan
hi John
"John Morgan" <jfm@.XXwoodlander.co.uk> ha scritto nel messaggio
news:lti6s0lcurtnlu681ph9s454i54omut69d@.4ax.com
> I removed (as far as I can tell) all versions of MSDE from my
> computer. This was confirmed when I examined the installed programs on
> the 'Add or remove programs' screen
> If I then use the files from my SP3a disk (installed on my D drive) to
> apparently successfully install a new default instance of MSDE and I
> subsequently check the version I get the following details:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on
> Windows NT 5.1 (Build 2600: Service Pack 1)
> In other words I do not seem to have the up to date Service Pack 3
> version installed.
> My questions are:
> 1. Is this message misleading or does it mean that I have failed to
> install the SP3a package for some reason?
>
the message is correct, but you are failing in reading it..
it says
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
and 8.00.760 is service pack 3 and/or 3a build, so you are in order with
that... then it says

> Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on
> Windows NT 5.1 (Build 2600: Service Pack 1)
and this is about your Operating System... you are running on WinXP sp1

> 2. I am using SELECT @.@.Version to get the version details- is this
> appropriate?
it is, but you have to read it correctly... unfortunately Books On Line is
not very clear about it's result..
you can verify all this by running
SET NOCOUNT ON
SELECT SERVERPROPERTY('ProductLevel') AS [Service Pack],
SERVERPROPERTY('ProductVersion') AS [Build]
that will output
Service Pack Build
-- --
SP3 8.00.760
as you can check again comparing software builds (ie at
http://www.aspfaq.com/show.asp?id=2160) , again, 8.00.760 is service pack 3

> 3. Is there any other way I can check whether I have SP3a properly
> installed?
you are in order with that... but you can go on further, to chek if you are
running service pack 3a, checking the registry key CSDVersion, value is
"8.00.760" for MSDE SP3 and "8.00.761" fro MSDE SP3a:
(HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\C urrentVersion , CSDVersion
key) or, more, look at the version number of the Net-Library file,
Ssnetlib.dll. If the version number of this file is 2000.80.760.0, you have
SP3; if the version number of this file is 2000.80.766.0, you have SP3a.
but you do not need it... the package you installed is updated at service
pack 3a level
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you Andrea for interpreting the version for me.
I verified it by running the SQL as well and you were right!
Much thanks , John Morgan
On Sat, 18 Dec 2004 00:40:45 +0100, "Andrea Montanari"
<andrea.sqlDMO@.virgilio.it> wrote:

>hi John
>"John Morgan" <jfm@.XXwoodlander.co.uk> ha scritto nel messaggio
>news:lti6s0lcurtnlu681ph9s454i54omut69d@.4ax.com
>the message is correct, but you are failing in reading it..
>it says
>and 8.00.760 is service pack 3 and/or 3a build, so you are in order with
>that... then it says
>and this is about your Operating System... you are running on WinXP sp1
>
>it is, but you have to read it correctly... unfortunately Books On Line is
>not very clear about it's result..
>you can verify all this by running
>SET NOCOUNT ON
>SELECT SERVERPROPERTY('ProductLevel') AS [Service Pack],
>SERVERPROPERTY('ProductVersion') AS [Build]
>that will output
>Service Pack Build
>-- --
>SP3 8.00.760
>as you can check again comparing software builds (ie at
>http://www.aspfaq.com/show.asp?id=2160) , again, 8.00.760 is service pack 3
>
>you are in order with that... but you can go on further, to chek if you are
>running service pack 3a, checking the registry key CSDVersion, value is
>"8.00.760" for MSDE SP3 and "8.00.761" fro MSDE SP3a:
>(HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\ CurrentVersion , CSDVersion
>key) or, more, look at the version number of the Net-Library file,
>Ssnetlib.dll. If the version number of this file is 2000.80.760.0, you have
>SP3; if the version number of this file is 2000.80.766.0, you have SP3a.
>but you do not need it... the package you installed is updated at service
>pack 3a level

Problem with FTS

I am trying to setup Full Text Search Service on my SQL 2000 Server Database
The problem I am having is that the "NEXT" button is not setting to enable when I select all IMAGE column to be populate
Why is it behaving like this ? am I missing something? I attach the Table structure & FTS Image link
Please help me
This is a sample image here


Why is theNEXT button disabled
http://80.42.24.114/you/callbackajax/1.gif
This is also my Table structure
http://80.42.24.114/you/callbackajax/2.gif

The text below is from the BOL(books online) about the extra column requirement to use Image column in Full Text index.
Run a search for Full Text image column in the BOL (bboks online) for more info. Hope this helps.
(Thus, when you set up full-text indexing on an image column in a table, you must create a separate column to hold information about the document. This type column can be of any character-based data type and contains the document file extension, such as doc for a Microsoft Word document. If the type column is NULL, the full-text service will assume the document is a text file.

In the Full-Text Indexing Wizard, if you select an image column for indexing, you must also specify a Binding column to hold the document type.

The sp_fulltext_column stored procedure also accepts an argument for the column to contain the document types.

The sp_help_fulltext_columns stored procedure also returns column name and column id of the document type column. )

Problem with event-based activation

I have an application that is set up using Service Broker to pass messages between services asynchronously. I am using event-based external activation and have successfully set up my event notification in SQL Server so if a message appears on any of my Service Broker queues, I'm getting the activation event from SQL Server sent to my activation service.

The problem that I am seeing is that every time I am posting a message onto a Service Broker queue, I am losing the event notification entry in the sys.event_notifications view and I'm not receiving my activation event notifications. When I execute the CREATE EVENT NOTIFICATION T-SQL statement to recreate the event notification, I'm getting the event notification immediately (since there are messages on the queues being monitored). The event notification appears to be registered until the next message is posted on the queue.

Any ideas on what I'm doing wrong?

Thanks,

Michael

Can you check ERRORLOG for any error messages when you see your event notifications being dropped?

Problem with Dependencies and the error "Cannot find the remote service"

Hello all.

We are a small taskforce currently working on a system of which utilizes the SQL notification service. For this we are using dependencies provided by SqlDependency. The dependency is set up as follows:

//Where dbo.MTable is the table and guid is the unique key of the records. We //want to listen to individual records and not the entire table

SqlCommand listenCommand = new SqlCommand( "SELECT ID FROM dbo.MTable WHERE ID = " + "@.guid", connection );

listenCommand.Parameters.AddWithValue( "@.guid", guid );

depend = new SqlDependency( listenCommand, null, 0 );

depend.OnChange += onChangeEventHandler;

If you’re not so bold as to look in the database server log, and you do not care about log growth of cataclysmic proportions which will inevitably crash the server, it will work fine. The problem is, as hinted above, that the server log is filled with error messages.

Error Code: 8490

Description: “Cannot find the remote service : because it does not exist.”

Here is an example of before mentioned messages:

The query notification dialog on conversation handle '{F53C37DE-E66A-DA11-90A1-00105AC00126}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8490</Code><Description>Cannot find the remote service &apos;SqlQueryNotificationService-cc3933a7-f97f-45b4-822f-f326f9f6e373&apos; because it does not exist.</Description></Error>'.

We have realized that listening on an entire table does not provoke this error. Furthermore, experiments have shown that the error only appears after we have shut down our system.

On shutdown, we call the following method:

SqlDependency.Stop( connection.ConnectionString );

This seems to stop the database from sending out notifications when we listen to an entire table, but not when we listen to individual records. Are we using the service in an incorrect manner or is there an error in the Stop method?

We have discovered a hotfix, but it is not exactly a beautiful solution:

SqlDependency.Start( connection.ConnectionString );

SqlCommand listenCommand = new SqlCommand( "SELECT * FROM MTable", connection );

depend = new SqlDependency( listenCommand );

SqlDependency.Stop( m_ConnectionString );

We have found that by ‘restarting’ the SqlDependency and giving it a new dependency where it listens to the entire table and THEN stopping it, the error does not appear. Our theory is that the new start and dependency overwrites the old ones.

I believe you have posted this issue to the wrong forum. SqlDependency is not a part of the Notification Services, despite the similar name. You might try a SQL 2005 forum instead.

Problem with debugging SSIS 2005 (32bit) component under Windows Vista ultimate

Hi,

I have a problem when i want to debug an ssis component under visual studio 2005.

I'm using sql 2005 with service pack 2 and i have already install patch for visual studio under vista.

When i put a breakpoint for exemple in the method "public override void PreExecute()" or in the other method. "public override void ProcessInput(int inputID, PipelineBuffer buffer)" and i execute the pgm.

however when i begin debugging,it's always skip breakpoint

However when i put a break point in the Validate method "public override DTSValidationStatus Validate()" it function.

When execute the the package it works fine.

I use this debug parametres :

Start external program :

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe

Command line arguments

/FILE "D:\Projects\Integration Services Project1\Integration Services Project1\TestXmlParserPipe.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI

I execute visual studio 2005 as Administrator

Please, can some one help me!

It must be some sort of those trivial problems. Are you sure the execution goes through those two methods? Try to check using some kind of checkpoint logging (i. e. MessageBox).

A few additional troubleshooting tips:

- Make sure you are building the debug version of your component.

- Check if the proper module gets loaded.

- Double-check the function signatures.

HTH.

|||

Hi,

thanks for your answer.

I'm sure, i'm was building the debug version.

I notice that if i put a messagebox in the script component and i run the package.

The message box appear, so i go to my ssis component code under visual studio2005 and then i put a breakpoint in

PreExecute() method (for example), after this i attached the process DtsDebugHost.exe (this process is visible in the process list only when the package ssis is running ). I came back to the message box i click ok and finally it work i can see the yellow line hilight the method.

What can i do to let de debugger work fine under vista ultimate? In my work, we have Windows XP professional and i don't have to use complicated procedure each time i want to debug my custom component.

so it will be so nice if some one know the solution for that.

Thanks in advance.

|||

Can you confirm one thing? Are you debugging your custom component using DTExec or BIDS?

Thanks,

Bob

|||

Hi,

I debug the my custom component using DTExec :

On Start action \start external program I use :

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe

I'm using the following command line arguments on start option:

/FILE "..\TestXmlParserPipe.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI

Please help with Windows Vista Ultimate ?

|||

Always start investigating debugging/breakpoints problems by checking if VS finds the symbols for your assembly. Go to Modules window, find your assembly, check if the symbols are loaded. If not, try to load the symbols manually.

Do you install a custom component (run gacutil /if ...) as part of VS post-build step?

What often happens is that if you don't do this, VS would build a new version of the component before starting debugging session; but the binary used by DTEXEC comes from GAC and it is different from the new version build by VS, so VS can't match the symbols and can't use the breakpoints.

Problem with debugging SSIS 2005 (32bit) component under Windows Vista ultimate

Hi,

I have a problem when i want to debug an ssis component under visual studio 2005.

I'm using sql 2005 with service pack 2 and i have already install patch for visual studio under vista.

When i put a breakpoint for exemple in the method "public override void PreExecute()" or in the other method. "public override void ProcessInput(int inputID, PipelineBuffer buffer)" and i execute the pgm.

however when i begin debugging,it's always skip breakpoint

However when i put a break point in the Validate method "public override DTSValidationStatus Validate()" it function.

When execute the the package it works fine.

I use this debug parametres :

Start external program :

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe

Command line arguments

/FILE "D:\Projects\Integration Services Project1\Integration Services Project1\TestXmlParserPipe.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI

I execute visual studio 2005 as Administrator

Please, can some one help me!

It must be some sort of those trivial problems. Are you sure the execution goes through those two methods? Try to check using some kind of checkpoint logging (i. e. MessageBox).

A few additional troubleshooting tips:

- Make sure you are building the debug version of your component.

- Check if the proper module gets loaded.

- Double-check the function signatures.

HTH.

|||

Hi,

thanks for your answer.

I'm sure, i'm was building the debug version.

I notice that if i put a messagebox in the script component and i run the package.

The message box appear, so i go to my ssis component code under visual studio2005 and then i put a breakpoint in

PreExecute() method (for example), after this i attached the process DtsDebugHost.exe (this process is visible in the process list only when the package ssis is running ). I came back to the message box i click ok and finally it work i can see the yellow line hilight the method.

What can i do to let de debugger work fine under vista ultimate? In my work, we have Windows XP professional and i don't have to use complicated procedure each time i want to debug my custom component.

so it will be so nice if some one know the solution for that.

Thanks in advance.

|||

Can you confirm one thing? Are you debugging your custom component using DTExec or BIDS?

Thanks,

Bob

|||

Hi,

I debug the my custom component using DTExec :

On Start action \start external program I use :

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe

I'm using the following command line arguments on start option:

/FILE "..\TestXmlParserPipe.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI

Please help with Windows Vista Ultimate ?

Problem with debugging SSIS 2005 (32bit) component under Windows Vista ultimate

Hi,

I have a problem when i want to debug an ssis component under visual studio 2005.

I'm using sql 2005 with service pack 2 and i have already install patch for visual studio under vista.

When i put a breakpoint for exemple in the method "public override void PreExecute()" or in the other method. "public override void ProcessInput(int inputID, PipelineBuffer buffer)" and i execute the pgm.

however when i begin debugging,it's always skip breakpoint

However when i put a break point in the Validate method "public override DTSValidationStatus Validate()" it function.

When execute the the package it works fine.

I use this debug parametres :

Start external program :

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe

Command line arguments

/FILE "D:\Projects\Integration Services Project1\Integration Services Project1\TestXmlParserPipe.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI

I execute visual studio 2005 as Administrator

Please, can some one help me!

It must be some sort of those trivial problems. Are you sure the execution goes through those two methods? Try to check using some kind of checkpoint logging (i. e. MessageBox).

A few additional troubleshooting tips:

- Make sure you are building the debug version of your component.

- Check if the proper module gets loaded.

- Double-check the function signatures.

HTH.

|||

Hi,

thanks for your answer.

I'm sure, i'm was building the debug version.

I notice that if i put a messagebox in the script component and i run the package.

The message box appear, so i go to my ssis component code under visual studio2005 and then i put a breakpoint in

PreExecute() method (for example), after this i attached the process DtsDebugHost.exe (this process is visible in the process list only when the package ssis is running ). I came back to the message box i click ok and finally it work i can see the yellow line hilight the method.

What can i do to let de debugger work fine under vista ultimate? In my work, we have Windows XP professional and i don't have to use complicated procedure each time i want to debug my custom component.

so it will be so nice if some one know the solution for that.

Thanks in advance.

|||

Can you confirm one thing? Are you debugging your custom component using DTExec or BIDS?

Thanks,

Bob

|||

Hi,

I debug the my custom component using DTExec :

On Start action \start external program I use :

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe

I'm using the following command line arguments on start option:

/FILE "..\TestXmlParserPipe.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI

Please help with Windows Vista Ultimate ?

|||

Always start investigating debugging/breakpoints problems by checking if VS finds the symbols for your assembly. Go to Modules window, find your assembly, check if the symbols are loaded. If not, try to load the symbols manually.

Do you install a custom component (run gacutil /if ...) as part of VS post-build step?

What often happens is that if you don't do this, VS would build a new version of the component before starting debugging session; but the binary used by DTEXEC comes from GAC and it is different from the new version build by VS, so VS can't match the symbols and can't use the breakpoints.

Problem with debugging SSIS 2005 (32bit) component under Windows Vista ultimate

Hi,

I have a problem when i want to debug an ssis component under visual studio 2005.

I'm using sql 2005 with service pack 2 and i have already install patch for visual studio under vista.

When i put a breakpoint for exemple in the method "public override void PreExecute()" or in the other method. "public override void ProcessInput(int inputID, PipelineBuffer buffer)" and i execute the pgm.

however when i begin debugging,it's always skip breakpoint

However when i put a break point in the Validate method "public override DTSValidationStatus Validate()" it function.

When execute the the package it works fine.

I use this debug parametres :

Start external program :

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe

Command line arguments

/FILE "D:\Projects\Integration Services Project1\Integration Services Project1\TestXmlParserPipe.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI

I execute visual studio 2005 as Administrator

Please, can some one help me!

It must be some sort of those trivial problems. Are you sure the execution goes through those two methods? Try to check using some kind of checkpoint logging (i. e. MessageBox).

A few additional troubleshooting tips:

- Make sure you are building the debug version of your component.

- Check if the proper module gets loaded.

- Double-check the function signatures.

HTH.

|||

Hi,

thanks for your answer.

I'm sure, i'm was building the debug version.

I notice that if i put a messagebox in the script component and i run the package.

The message box appear, so i go to my ssis component code under visual studio2005 and then i put a breakpoint in

PreExecute() method (for example), after this i attached the process DtsDebugHost.exe (this process is visible in the process list only when the package ssis is running ). I came back to the message box i click ok and finally it work i can see the yellow line hilight the method.

What can i do to let de debugger work fine under vista ultimate? In my work, we have Windows XP professional and i don't have to use complicated procedure each time i want to debug my custom component.

so it will be so nice if some one know the solution for that.

Thanks in advance.

|||

Can you confirm one thing? Are you debugging your custom component using DTExec or BIDS?

Thanks,

Bob

|||

Hi,

I debug the my custom component using DTExec :

On Start action \start external program I use :

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe

I'm using the following command line arguments on start option:

/FILE "..\TestXmlParserPipe.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI

Please help with Windows Vista Ultimate ?

|||

Always start investigating debugging/breakpoints problems by checking if VS finds the symbols for your assembly. Go to Modules window, find your assembly, check if the symbols are loaded. If not, try to load the symbols manually.

Do you install a custom component (run gacutil /if ...) as part of VS post-build step?

What often happens is that if you don't do this, VS would build a new version of the component before starting debugging session; but the binary used by DTEXEC comes from GAC and it is different from the new version build by VS, so VS can't match the symbols and can't use the breakpoints.