Friday, May 24, 2013

[SQL Server] SQL Server 2008 Upgrade Advisor failure...

[SQL Server] SQL Server 2008 Upgrade Advisor failure...

SQL Server 2008 Upgrade Advisor failure...

Posted: 24 May 2013 06:45 AM PDT

Hello,We're running SQL Server 2008 upgrade advisor against a SQL Server 2000 instance. When asked to identify which components to analyze, I enter the server name and click 'Detect'. The software identifies SQL Server and Data Transformation Services components. When I review the database server, I queried the MSDB database along with searching for any .dts files. Nothing - I'm not seeing any reference to Data Transformation Services. Is this a false positive? BTW - when running the advisor regardless of my findings, I get an error message that "DTS Client is not installed on this machine. DTS upgrade advisor requires access to the DTS object model to report on DTS packages".Any thoughts, comments, URLs would be appreciated - thank you.

Selecting Multiple Substrings from a Field

Posted: 24 May 2013 05:45 AM PDT

Hello, I posted something similar on another site but haven't work this out yet so I figure I give it a try here.I'm trying to create a SQL query that selects pieces of a field, combines them and displays them in a new column for each row. Here is a shorten example of what is in one unedited field:[quote]<Name>Example1</Name><Type>String</Type><Nullable>False</Nullable><AllowBlank>False</AllowBlank><Prompt>Start Date (DD-MMM-YYYY)</Prompt> <PromptUser>True</PromptUser> </Parameter> <Parameter> <Name>Example2</Name> <Type>String</Type> <Nullable>False</Nullable> <AllowBlank>False</AllowBlank><Prompt>Case (Enter Case Number, % for all, OR %AL% for Alberta)</Prompt> <PromptUser>True</PromptUser> <DefaultValues> <Value>%al%</Value> </DefaultValues> <Values> <Value>%al%</Value> </Values> </Parameter> <Parameter>[/quote]When the code is done the new field in the column using the above data should look like this[quote]Name: Example1Prompt: Start Date (DD-MMM-YYYY)Name: Example2Prompt: Case (Enter Case Number, % for all, OR %AL% for Alberta)Value: %al%[/quote]In other words I want to remove the names, prompts, and value contained in the field for each record. I have tried to do this in different ways, by using substrings and charindex which fails due to the field having more than one character as shown above (2 <name>). And I have tried though nexted replacing but that failed as well since I don't know what could be between each set of tags (<><>).if I can use REPLACE to replace the unknown length string between or along with the two known tags for example replacing ### between <Type>###</Type> where ### represents any number of unkown characters then i can solve this problem with the jumbo replace statements.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog