Error read data from Sybase with SSIS 2005

Hi to All,
I am in process of transfering data from Sybase to Sql Server using
Microsoft Visual Studio 2005
have taken a Data Flow Task in Control Flow tab
In Data flow tab, I have taken one Ole DB Source
I am using Sybase Adaptive Server Anywhere Provider 9.0
In Ole Db Source Editor ,
For OLe Db Connection Manager, I choose Sybase Connection
For Data access mode, I choose Table or View
For Name of the table or the view, I choose a table by name Table1( it
lists all the tables from Sybase database)
When i click on preview button or Columns link, I get the following
Error
________________________________
TITLE: Microsoft Visual Studio
--
Error at Data Flow Task [OLE DB Source [215]]: An OLE DB error has
occurred. Error code: 0x80040E21.
Error at Data Flow Task [OLE DB Source [215]]: Unable to retrieve
column information from the data source. Make sure your target table in
the database is available.
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC020204A
(Microsoft.SqlServer.DTSPipelineWrap)
___________________________________
I've tried to install "ODBC .NET Data Provider"
but it wasn't tested with Sybase and it doesn't work.
Could anyone help me please?
Thanks
SalmecFirst, make sure that you can connect to the Sybase system by setting up a
linked server in SQL 2005 (take SSIS out of the picture). If that fails,
check www.connectionstrings.com to see if you're missing something in the
connection string. I assume you have the sybase client installed on the SSIS
box? It would need to be the same if SQL Server were on a different server.
If you can make that connection and make a simple query of the table, beware
of implicit data type conversions. I've had problems doing just this sort of
thing with Sybase when it came to the "money" datatype. You'd think that
since Sybase and SQL Server have a money type that it would work fine. Um,
no. So if you can get it to work as a linked server, try eliminating fields
(especially those that have some uncommon data type).
Hope that helps a bit.
"Sal" <salmec@.gmail.com> wrote in message
news:1152175894.975209.80120@.m73g2000cwd.googlegroups.com...
> Hi to All,
> I am in process of transfering data from Sybase to Sql Server using
> Microsoft Visual Studio 2005
> have taken a Data Flow Task in Control Flow tab
> In Data flow tab, I have taken one Ole DB Source
> I am using Sybase Adaptive Server Anywhere Provider 9.0
> In Ole Db Source Editor ,
> For OLe Db Connection Manager, I choose Sybase Connection
> For Data access mode, I choose Table or View
> For Name of the table or the view, I choose a table by name Table1( it
> lists all the tables from Sybase database)
> When i click on preview button or Columns link, I get the following
> Error
> ________________________________
> TITLE: Microsoft Visual Studio
> --
> Error at Data Flow Task [OLE DB Source [215]]: An OLE DB error has
> occurred. Error code: 0x80040E21.
> Error at Data Flow Task [OLE DB Source [215]]: Unable to retrieve
> column information from the data source. Make sure your target table in
> the database is available.
>
> --
> ADDITIONAL INFORMATION:
> Exception from HRESULT: 0xC020204A
> (Microsoft.SqlServer.DTSPipelineWrap)
> ___________________________________
> I've tried to install "ODBC .NET Data Provider"
> but it wasn't tested with Sybase and it doesn't work.
> Could anyone help me please?
> Thanks
> Salmec
>|||Hi James,
thanks for your interesting...
i resolved the problem:
i choose the "SSIS import and export Wizard" procedure (project menu)
At th first step - choose a Data Source - I choose ".Net Framework Data
Provider for Odbc"
As destination i've a SQL Native Client
I write a query to select the column tha i would like to import;
I choose the destination table
and after click Finish button
This procedure create a new package that import and convert the data.
and it works
Thanks to all
Sal

Error read data from Sybase with SSIS 2005

Hi to All,
I am in process of transfering data from Sybase to Sql Server using
Microsoft Visual Studio 2005
have taken a Data Flow Task in Control Flow tab
In Data flow tab, I have taken one Ole DB Source
I am using Sybase Adaptive Server Anywhere Provider 9.0
In Ole Db Source Editor ,
For OLe Db Connection Manager, I choose Sybase Connection
For Data access mode, I choose Table or View
For Name of the table or the view, I choose a table by name Table1( it
lists all the tables from Sybase database)
When i click on preview button or Columns link, I get the following
Error
________________________________
TITLE: Microsoft Visual Studio
--
Error at Data Flow Task [OLE DB Source [215]]: An OLE DB error has
occurred. Error code: 0x80040E21.
Error at Data Flow Task [OLE DB Source [215]]: Unable to retrieve
column information from the data source. Make sure your target table in
the database is available.
--
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC020204A
(Microsoft.SqlServer.DTSPipelineWrap)
___________________________________
I've tried to install "ODBC .NET Data Provider"
but it wasn't tested with Sybase :( and it doesn't work.
Could anyone help me please?
Thanks
SalmecFirst, make sure that you can connect to the Sybase system by setting up a
linked server in SQL 2005 (take SSIS out of the picture). If that fails,
check www.connectionstrings.com to see if you're missing something in the
connection string. I assume you have the sybase client installed on the SSIS
box? It would need to be the same if SQL Server were on a different server.
If you can make that connection and make a simple query of the table, beware
of implicit data type conversions. I've had problems doing just this sort of
thing with Sybase when it came to the "money" datatype. You'd think that
since Sybase and SQL Server have a money type that it would work fine. Um,
no. So if you can get it to work as a linked server, try eliminating fields
(especially those that have some uncommon data type).
Hope that helps a bit.
"Sal" <salmec@.gmail.com> wrote in message
news:1152175894.975209.80120@.m73g2000cwd.googlegroups.com...
> Hi to All,
> I am in process of transfering data from Sybase to Sql Server using
> Microsoft Visual Studio 2005
> have taken a Data Flow Task in Control Flow tab
> In Data flow tab, I have taken one Ole DB Source
> I am using Sybase Adaptive Server Anywhere Provider 9.0
> In Ole Db Source Editor ,
> For OLe Db Connection Manager, I choose Sybase Connection
> For Data access mode, I choose Table or View
> For Name of the table or the view, I choose a table by name Table1( it
> lists all the tables from Sybase database)
> When i click on preview button or Columns link, I get the following
> Error
> ________________________________
> TITLE: Microsoft Visual Studio
> --
> Error at Data Flow Task [OLE DB Source [215]]: An OLE DB error has
> occurred. Error code: 0x80040E21.
> Error at Data Flow Task [OLE DB Source [215]]: Unable to retrieve
> column information from the data source. Make sure your target table in
> the database is available.
>
> --
> ADDITIONAL INFORMATION:
> Exception from HRESULT: 0xC020204A
> (Microsoft.SqlServer.DTSPipelineWrap)
> ___________________________________
> I've tried to install "ODBC .NET Data Provider"
> but it wasn't tested with Sybase :( and it doesn't work.
> Could anyone help me please?
> Thanks
> Salmec
>|||Hi James,
thanks for your interesting...
i resolved the problem:
i choose the "SSIS import and export Wizard" procedure (project menu)
At th first step - choose a Data Source - I choose ".Net Framework Data
Provider for Odbc"
As destination i've a SQL Native Client
I write a query to select the column tha i would like to import;
I choose the destination table
and after click Finish button
This procedure create a new package that import and convert the data.
and it works
Thanks to all
Salsql

Error opening VSA from Script component and Script Task

TITLE: Microsoft Visual Studio

Cannot show Visual Studio for Applications editor.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.DataFlowUI.SR&EvtID=CouldNotShowVsaIDE&LinkId=20476

ADDITIONAL INFORMATION:

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa)

A project with the name 'ScriptComponent_972bfcb1f5ae462081f39130ba1d36b2' already exists.

BUTTONS:

OK

This happened immediately AFTER installing Visual Studio 2005. SQL Serve Workstation tools were already installed. I am running Windows XP SP2.

Anyway have any words of wisdon as to what the problem may be or how to investigate fix it?

Thanks

Jamie

Ignore this. Rebooting has solved it!!!

-Jamie

|||

Jamie,

I've got similar message which is persistent. I cannot open any script task anymore

Error message "Cannot show the editor for this task. Specified cast is not valid (Microsoft.VisualBasic.Vsa.DT)" pops up.

I even retried re-installing VS 2005. Did not resolved the issue.

Any idea?

Gulden

|||

Try to upgrade your machine with the cumulative hotfix package (build 2153) for SQL Server 2005.

Regards,
Yitzhak

|||

Yitzak,

Thank you for your answer.

I am getting "This machine does not have a product that matches this installation package"

on the first one in x86 group.

Do you have any idea?

This is my only chance.

I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.

Gulden

|||

Even betterjust exit out of VS2005 and go back in. That solved it for me.

Jeff

|||

In my case they had pushed DLLs in 600 people's banded machines in my company including vbscript.dll etc. by mistake. They resolved it by re-registering them

Gulden

|||

You need to install SP1 for MS SQL Server 2005 as a prerequisite before you will be able to upgrade your machine with the cumulative hotfix package (build 2153) for SQL Server 2005. SO it is a 2 steps process.

Regards,
Yitzhak

Error opening VSA from Script component and Script Task

TITLE: Microsoft Visual Studio

Cannot show Visual Studio for Applications editor.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.DataFlowUI.SR&EvtID=CouldNotShowVsaIDE&LinkId=20476

ADDITIONAL INFORMATION:

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa)

A project with the name 'ScriptComponent_972bfcb1f5ae462081f39130ba1d36b2' already exists.

BUTTONS:

OK

This happened immediately AFTER installing Visual Studio 2005. SQL Serve Workstation tools were already installed. I am running Windows XP SP2.

Anyway have any words of wisdon as to what the problem may be or how to investigate fix it?

Thanks

Jamie

Ignore this. Rebooting has solved it!!!

-Jamie

|||

Jamie,

I've got similar message which is persistent. I cannot open any script task anymore

Error message "Cannot show the editor for this task. Specified cast is not valid (Microsoft.VisualBasic.Vsa.DT)" pops up.

I even retried re-installing VS 2005. Did not resolved the issue.

Any idea?

Gulden

|||

Try to upgrade your machine with the cumulative hotfix package (build 2153) for SQL Server 2005.

Regards,
Yitzhak

|||

Yitzak,

Thank you for your answer.

I am getting "This machine does not have a product that matches this installation package"

on the first one in x86 group.

Do you have any idea?

This is my only chance.

I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.

Gulden

|||

Even betterjust exit out of VS2005 and go back in. That solved it for me.

Jeff

|||

In my case they had pushed DLLs in 600 people's banded machines in my company including vbscript.dll etc. by mistake. They resolved it by re-registering them

Gulden

|||

You need to install SP1 for MS SQL Server 2005 as a prerequisite before you will be able to upgrade your machine with the cumulative hotfix package (build 2153) for SQL Server 2005. SO it is a 2 steps process.

Regards,
Yitzhak

Error opening VSA from Script component and Script Task

TITLE: Microsoft Visual Studio

Cannot show Visual Studio for Applications editor.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.DataFlowUI.SR&EvtID=CouldNotShowVsaIDE&LinkId=20476

ADDITIONAL INFORMATION:

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa)

A project with the name 'ScriptComponent_972bfcb1f5ae462081f39130ba1d36b2' already exists.

BUTTONS:

OK

This happened immediately AFTER installing Visual Studio 2005. SQL Serve Workstation tools were already installed. I am running Windows XP SP2.

Anyway have any words of wisdon as to what the problem may be or how to investigate fix it?

Thanks

Jamie

Ignore this. Rebooting has solved it!!!

-Jamie

|||

Jamie,

I've got similar message which is persistent. I cannot open any script task anymore

Error message "Cannot show the editor for this task. Specified cast is not valid (Microsoft.VisualBasic.Vsa.DT)" pops up.

I even retried re-installing VS 2005. Did not resolved the issue.

Any idea?

Gulden

|||

Try to upgrade your machine with the cumulative hotfix package (build 2153) for SQL Server 2005.

Regards,
Yitzhak

|||

Yitzak,

Thank you for your answer.

I am getting "This machine does not have a product that matches this installation package"

on the first one in x86 group.

Do you have any idea?

This is my only chance.

I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.

Gulden

|||

Even betterjust exit out of VS2005 and go back in. That solved it for me.

Jeff

|||

In my case they had pushed DLLs in 600 people's banded machines in my company including vbscript.dll etc. by mistake. They resolved it by re-registering them

Gulden

|||

You need to install SP1 for MS SQL Server 2005 as a prerequisite before you will be able to upgrade your machine with the cumulative hotfix package (build 2153) for SQL Server 2005. SO it is a 2 steps process.

Regards,
Yitzhak

Error Msg

How do I resolve the following error message and what does this mean?
c:\srsconv\visual studio
projects\china\china_reports\All_Official_Representatives_China.rdl The value
expression for the textbox â'ADDR_Org_Name_2â' contains an error: [BC30311]
Value of type
'Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Field' cannot
be converted to 'String'.What does the expression in textbox ADDR_Org_Name_2 contain?
"Terry" wrote:
> How do I resolve the following error message and what does this mean?
> c:\srsconv\visual studio
> projects\china\china_reports\All_Official_Representatives_China.rdl The value
> expression for the textbox â'ADDR_Org_Name_2â' contains an error: [BC30311]
> Value of type
> 'Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Field' cannot
> be converted to 'String'.
>|||The error was resolved. The error was due to implemented custom code.
Thank you for your speedy response.
However, do you know how I could setup a mailing list across 3 columns?
"Ben Sullins" wrote:
> What does the expression in textbox ADDR_Org_Name_2 contain?
> "Terry" wrote:
> > How do I resolve the following error message and what does this mean?
> >
> > c:\srsconv\visual studio
> > projects\china\china_reports\All_Official_Representatives_China.rdl The value
> > expression for the textbox â'ADDR_Org_Name_2â' contains an error: [BC30311]
> > Value of type
> > 'Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Field' cannot
> > be converted to 'String'.
> >|||Terry wrote: However, do you know how I could setup a mailing list across 3
columns?
From MSDN Reporting Services BOL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_layout_v1_4uwj.asp
You will need to render the using Print Preview, PDF, or TIFF to actually
see the multiple columns.
Also pay attention to the relationship between the PageWidth + Left / Right
Margins and the #Columns, ColumnWidth, and the Column Spacing:
PageWidth - Left Margin - Right Marging >= (#Columns * ColumnWidth) +
((#Columns -1) * Column Spacing).
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:DC8F187E-B492-4DDA-BB91-4BE8BB4658B9@.microsoft.com...
> The error was resolved. The error was due to implemented custom code.
> Thank you for your speedy response.
> However, do you know how I could setup a mailing list across 3 columns?
>
> "Ben Sullins" wrote:
>> What does the expression in textbox ADDR_Org_Name_2 contain?
>> "Terry" wrote:
>> > How do I resolve the following error message and what does this mean?
>> >
>> > c:\srsconv\visual studio
>> > projects\china\china_reports\All_Official_Representatives_China.rdl The
>> > value
>> > expression for the textbox 'ADDR_Org_Name_2' contains an error:
>> > [BC30311]
>> > Value of type
>> > 'Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Field'
>> > cannot
>> > be converted to 'String'.
>> >|||Thank you very much for your assistance.
I will try the solution provided and let you know its results.
Again, thanks!
"Bruce Johnson [MSFT]" wrote:
> Terry wrote: However, do you know how I could setup a mailing list across 3
> columns?
> From MSDN Reporting Services BOL:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_layout_v1_4uwj.asp
> You will need to render the using Print Preview, PDF, or TIFF to actually
> see the multiple columns.
> Also pay attention to the relationship between the PageWidth + Left / Right
> Margins and the #Columns, ColumnWidth, and the Column Spacing:
> PageWidth - Left Margin - Right Marging >= (#Columns * ColumnWidth) +
> ((#Columns -1) * Column Spacing).
>
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Terry" <Terry@.discussions.microsoft.com> wrote in message
> news:DC8F187E-B492-4DDA-BB91-4BE8BB4658B9@.microsoft.com...
> > The error was resolved. The error was due to implemented custom code.
> >
> > Thank you for your speedy response.
> >
> > However, do you know how I could setup a mailing list across 3 columns?
> >
> >
> > "Ben Sullins" wrote:
> >
> >> What does the expression in textbox ADDR_Org_Name_2 contain?
> >>
> >> "Terry" wrote:
> >>
> >> > How do I resolve the following error message and what does this mean?
> >> >
> >> > c:\srsconv\visual studio
> >> > projects\china\china_reports\All_Official_Representatives_China.rdl The
> >> > value
> >> > expression for the textbox 'ADDR_Org_Name_2' contains an error:
> >> > [BC30311]
> >> > Value of type
> >> > 'Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Field'
> >> > cannot
> >> > be converted to 'String'.
> >> >
>
>

Error message ID returned to the application

Hello,
I want to know whether I could get the Raiserror's message id in the front
end's application, (coded in Visual Basic or Delphi).
Thanks in advance
FrankFrank
Read up about sysmessages system table in the BOL
"Frank" <wangping@.lucent.com> wrote in message
news:%23VfqSgyPFHA.2252@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I want to know whether I could get the Raiserror's message id in the front
> end's application, (coded in Visual Basic or Delphi).
> Thanks in advance
> Frank
>|||Hi Frank
To add to Uri's reply also check out severity levels in BOL. Getting the
value of the error will depend on what the front end application is e.g. ADO
has the ADOErrors collection.
John
"Frank" wrote:

> Hello,
> I want to know whether I could get the Raiserror's message id in the front
> end's application, (coded in Visual Basic or Delphi).
> Thanks in advance
> Frank
>
>|||Dimant,
Thanks for your quick response.
Actually here is the scenario,
I am using Delphi to access the SQL Server, and in my Delphi code, I need to
deal with errors which could come from the SQL Server, and in my Delphi
code, there are exception handlers like the following,
Try
something dealing with the SQL Server and something wrong
Except on E.Exception
If pos('Communication Like Failure', E.message)>0 then
//It is the connection error and do my error handling for connection.
End
And in the above pos('Communication Like Failure', E.message), I judge
whether the connection is broken or not only depend on whether the E.message
includes the 'Communication Like Failure' word.
What I think could be more accurate is that if I could get the error number
of the 'Communication Like Failure', and judge by the number.
Hope I have expressed well.
Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:etUmtkyPFHA.3384@.TK2MSFTNGP10.phx.gbl...
> Frank
> Read up about sysmessages system table in the BOL
>
> "Frank" <wangping@.lucent.com> wrote in message
> news:%23VfqSgyPFHA.2252@.TK2MSFTNGP15.phx.gbl...
front
>|||Hi
If you are using TADOConnection you can check the errors collection in
that. The NativeError attribute of each item will give the SQL Server
error number.
John|||Thanks John,
That works.
Frank
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1113408160.705790.30670@.o13g2000cwo.googlegroups.com...
> Hi
> If you are using TADOConnection you can check the errors collection in
> that. The NativeError attribute of each item will give the SQL Server
> error number.
> John
>

Error message about SQL Server is displayed

I have a website that works OK on my local machine when I test it within Microsoft Visual Studio's debugging mode. However now that I have copied it over to a remote server it is failing with an error message of:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

As far as I'm aware I have never used SQL Server with my webpage. All connections to databases are to Oracle with connection strings and providers set up in the webconfig file. The website does however use a login control to recognise authorised users. Does this mean I've unknowingly been using SQL Server (to support the login control) and I therefore need to install this on the remote machine? Or is it something simpler? Wondered if anybody had seen this error message before?

Hi,

The website does however use a login control to recognize authorized users.

As you mentioned in your post, you are using login controls to recognize authorized users. In ASP.NET, such controls like logins, createuserwizard and etc are parts of .Net Membership provider mechanism.

In your local side, I think the SQLExpress has been shipped in your Visual Studio, so it can support the membership to work. But after you deployed your application to your server, the membership still tries to find the database to support. Unfortunately, the database does exist on your server, so the error occurs.

Thanks.

|||

Hi Nai-Dong, thanks for replying. I agree with your suggestion that the membership is tying and failing to read the database. The database MDF file is present and in the correct location. The permissions are set on this file as according to other forum posts I've read. I also installed SQLServer Express on the remote machine. I suspect that the membership is not picking up the SQLServerExpress install but I am not sure how to fix this. It's such a shame because the ASP.NET login controls and .Net membership provider are really neat and simple to use. Due to time restraints it's looking like I'm going to have to use my Oracle database to contain the login information and write code myself to enable authentication.

|||

Hi,

Well, i just want to provide you some materials on membership which maybe helpful to you when you are going to use Membership in your next project.

About Membership Providershttp://msdn2.microsoft.com/en-us/library/aa478949.aspx

Membership introductionhttp://msdn2.microsoft.com/en-us/library/yh26yfzy.aspx

Settings on using Membershiphttp://msdn2.microsoft.com/en-us/library/ms731049.aspx

Besides, you can export all the datatables with schemas in ASPNETDB into your Oracle database, and change the membership provider, you also can use membership with a Oracle back-end database.

Hope that helps. Thanks.

|||

Thanks Michael - greatly appreciated. I will certainly read through them. I like the idea of Oracle providing membership since I can connect to me Oracle db without any problems.

Error Message : Your SQL server installation is either corrupt or

Hi all,
I recently upgraded to visual studio 2005 professional from VB6 and sql
server 2000.
I got the latest updates and rebooted my machine and when it boots up i get
the following error message " Your SQL server installation is either corrupt
or has been tampered with (unknown package id). Please rerun setup.
OK - did that. The same error message reappeared. I have then removed visual
studio and sql server 2005 developer edition and sql server 2000 and then
rebooted mahcine. Same error message. Have reinstalled everything and the
same thing keeps reoccuring - DO i need to remove some registry entries or a
file of the machine so that this message dissapears.
TIA JustinOpen up your browser and visit the following site, it'll sove your issue
probably.
http://support.microsoft.com/default.aspx?scid=kb;en-us;290301
--
Ekrem Ã?nsoy
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Justin" <Justin@.discussions.microsoft.com> wrote in message
news:68E56E56-EFF1-4F14-B887-2EE0ED8F5B45@.microsoft.com...
> Hi all,
> I recently upgraded to visual studio 2005 professional from VB6 and sql
> server 2000.
> I got the latest updates and rebooted my machine and when it boots up i
> get
> the following error message " Your SQL server installation is either
> corrupt
> or has been tampered with (unknown package id). Please rerun setup.
> OK - did that. The same error message reappeared. I have then removed
> visual
> studio and sql server 2005 developer edition and sql server 2000 and then
> rebooted mahcine. Same error message. Have reinstalled everything and the
> same thing keeps reoccuring - DO i need to remove some registry entries or
> a
> file of the machine so that this message dissapears.
> TIA Justin