Microsoft SQL server 6.5 to 2005

Hi Fellas,
I would really appreciate if you could help me out with the following two questions?
1) Can 2005 server files be converted to 6.5? and how?
2) How easy it to upgrade from 6.5 to 2005? and how?
I would be really grateful by your help
NickNot so easy task to do as you have to compare each and every aspect of the database to ensure they work in compatibility of SQL 2005.

Refer to http://sqlserver-qa.net/blogs/tools/archive/2007/04/12/set-a-stage-for-smooth-upgrades-of-your-sql-server-environment.aspx & http://sqlserver-qa.net/blogs/tools/pages/easy-way-to-upgrade-from-previous-version-of-sql-server.aspx in this case.|||Thanks a lot, i appreciate.|||Maverick

I should imagine it would depend on the size & complexity of the 6.5 DB

For a simple DB I would probably just script out the Schema then, run script & right click - import the data on the 2005 box then - suck it & see fixing any issues (IF there are any) in testing.

Or you could spend your life reading up on the possible failures & effects that may occur as Satya suggests

GWsql

Microsoft SQL Express 2005 Installation Failure

I can get SQL SERVER 2005 to install it goes through the extracting files then gives me an error message that says "SQL Server Setup unexpectedly failed. for more information, review the setup summery log file " . I don't think i have any beta versons of Visual Studio or SQL I do have Accouting Express with has something with SQL I don't know if that will stop my installation. I really need SQL to work for my business.

Please Help ME!!!

---

Heres a copy of my log file:[SQLSetup0017_DSTRETCH_Core]

Microsoft SQL Server 2005 Setup beginning at Wed Apr 18 19:28:35 2007
Process ID : 5244
c:\84d9dbbedcbb7eee6c8eeabf58\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/18 19:28:35
Complete: LoadResourcesAction at: 2007/3/18 19:28:35, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35
Loaded DLL:c:\84d9dbbedcbb7eee6c8eeabf58\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/3/18 19:28:35
Complete: ValidateWinNTAction at: 2007/3/18 19:28:35, returned true
Running: ValidateMinOSAction at: 2007/3/18 19:28:35
Complete: ValidateMinOSAction at: 2007/3/18 19:28:35, returned true
Running: PerformSCCAction at: 2007/3/18 19:28:35
Complete: PerformSCCAction at: 2007/3/18 19:28:35, returned true
Running: ActivateLoggingAction at: 2007/3/18 19:28:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
02E7CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Can you search through your SQL install log directory for the text string "value 3" and post the 10 or so lines above that? It may give a more descriptive error message.

Thanks,
Sam Lester (MSFT)

|||

Ah, I think it may be this issue. Can you read through this post and see if it applies to your situation.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1117117&SiteID=1

Thanks,
Sam

|||I can't find "value 3" and the artical that you linked to did not apply to my problem.

Microsoft SQL Express 2005 Installation Failure

I can get SQL SERVER 2005 to install it goes through the extracting files then gives me an error message that says "SQL Server Setup unexpectedly failed. for more information, review the setup summery log file " . I don't think i have any beta versons of Visual Studio or SQL I do have Accouting Express with has something with SQL I don't know if that will stop my installation. I really need SQL to work for my business.

Please Help ME!!!

---

Heres a copy of my log file:[SQLSetup0017_DSTRETCH_Core]

Microsoft SQL Server 2005 Setup beginning at Wed Apr 18 19:28:35 2007
Process ID : 5244
c:\84d9dbbedcbb7eee6c8eeabf58\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/18 19:28:35
Complete: LoadResourcesAction at: 2007/3/18 19:28:35, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35
Loaded DLL:c:\84d9dbbedcbb7eee6c8eeabf58\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/3/18 19:28:35
Complete: ValidateWinNTAction at: 2007/3/18 19:28:35, returned true
Running: ValidateMinOSAction at: 2007/3/18 19:28:35
Complete: ValidateMinOSAction at: 2007/3/18 19:28:35, returned true
Running: PerformSCCAction at: 2007/3/18 19:28:35
Complete: PerformSCCAction at: 2007/3/18 19:28:35, returned true
Running: ActivateLoggingAction at: 2007/3/18 19:28:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
02E7CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Can you search through your SQL install log directory for the text string "value 3" and post the 10 or so lines above that? It may give a more descriptive error message.

Thanks,
Sam Lester (MSFT)

|||

Ah, I think it may be this issue. Can you read through this post and see if it applies to your situation.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1117117&SiteID=1

Thanks,
Sam

|||I can't find "value 3" and the artical that you linked to did not apply to my problem.

Microsoft JET Databse Engine Error Message

Hi,
When I try to import DBF files into the SQL Server,
I got the following error messages for some files.

Error Source: Microsoft JET Databse Engine
Error Destination: External table is not in the expected
format
Context: Error calling OpenRowset on the provider.

Does anyone know about this error?

I found that only files that have *.FPT (memo) files didn't work
and other files were imported successfully/

I installed sql server service pack and I checked that
the machine has the latest JET Database engine (4.0).

I'm using Microsoft SQL Server 2000 Standard Edition
w/ Service Pack 2 & Microsoft FoxPro 2.6.

Thank you in advance.

- Hyung -Did anyone ever answer this?sql

Microsoft Access Database Synchronizer (ADS) RTW Help

Someone please help, Ive downloaded and instsalled Microsoft Access Database Synchronizer (ADS) RTW onto my desktop and the files have installed to C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\Sync\Access. Ive got a device running windows CE 5.0 connected to the desktop via USB. Ive installed all the necessary CAB files onto the device but how do I get the ADS working? What do I have to do with the files installed? I am fairly new to this so can someone please help me. Isnt there supose to be an option in the start menu to run the wizard, i don't seem to be getting this?

Thanks in advance

Sami

You should read the readme.doc in the C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\sync\Access folder. Specifically from page 11 and on it is explained how to get started with the sample wizard.

|||

I have looked at this readme doc but the first step says:

Click Start, Programs, and then click Access Database Synchronization Sample Wizard

But this is not in my programs list, why is that? I have installed the msi file and was expecting the program to appear in the start menu automatically as it says in the readme, but it is not. Any ideas?|||

You must do these thing first on your Windows Mobile device (as stated):

First, you should install .NET Compact Framework 2.0 and device cab files on the device for the Access Database Synchronization Sample Wizard.

The device cab file is in your Program Files\Microsoft SQL Server Compact Edition\v3.1\Sync\Access folder, ot is called:

sqlce.access.sample.PPC.wce5.armv4i.CAB

Install .NET Compact Framework 2.0 and copy the sqlce.access.sample.PPC.wce5.armv4i.CAB file to your Windows Mobile device (or emulator) and install it. Then it will appear under Start, Programs as stated in the readme.doc

|||

I installed .NET Compact Framework 2.0 and device cab files. When I try to install the cab file sqlce.access.sample.PPC.wce5.armv4i.CAB on the device i get the following error:

The file "\My Documents\sqlce.access.sample.PPc.wce5.armv4i.CAB is not a valid Windows CE Setup file.

What could be the problem for this?

|||

Your device must be Windows Mobile 5, is that the case?

|||

The device is running Windows CE 5.0 not Window Mobile 5. I thought that the software was Windows CE compatible? Is this incorrect?

|||Yes, Windows CE is supported, but the sample application only runs under Windows Mobile 5.0. Try it in the emualtor to explore the capabilities (and limitations) of the "product".

Microsoft Access Database Synchronizer (ADS) RTW Help

Someone please help, Ive downloaded and instsalled Microsoft Access Database Synchronizer (ADS) RTW onto my desktop and the files have installed to C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\Sync\Access. Ive got a device running windows CE 5.0 connected to the desktop via USB. Ive installed all the necessary CAB files onto the device but how do I get the ADS working? What do I have to do with the files installed? I am fairly new to this so can someone please help me. Isnt there supose to be an option in the start menu to run the wizard, i don't seem to be getting this?

Thanks in advance

Sami

You should read the readme.doc in the C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\sync\Access folder. Specifically from page 11 and on it is explained how to get started with the sample wizard.

|||

I have looked at this readme doc but the first step says:

Click Start, Programs, and then click Access Database Synchronization Sample Wizard

But this is not in my programs list, why is that? I have installed the msi file and was expecting the program to appear in the start menu automatically as it says in the readme, but it is not. Any ideas?|||

You must do these thing first on your Windows Mobile device (as stated):

First, you should install .NET Compact Framework 2.0 and device cab files on the device for the Access Database Synchronization Sample Wizard.

The device cab file is in your Program Files\Microsoft SQL Server Compact Edition\v3.1\Sync\Access folder, ot is called:

sqlce.access.sample.PPC.wce5.armv4i.CAB

Install .NET Compact Framework 2.0 and copy the sqlce.access.sample.PPC.wce5.armv4i.CAB file to your Windows Mobile device (or emulator) and install it. Then it will appear under Start, Programs as stated in the readme.doc

|||

I installed .NET Compact Framework 2.0 and device cab files. When I try to install the cab file sqlce.access.sample.PPC.wce5.armv4i.CAB on the device i get the following error:

The file "\My Documents\sqlce.access.sample.PPc.wce5.armv4i.CAB is not a valid Windows CE Setup file.

What could be the problem for this?

|||

Your device must be Windows Mobile 5, is that the case?

|||

The device is running Windows CE 5.0 not Window Mobile 5. I thought that the software was Windows CE compatible? Is this incorrect?

|||Yes, Windows CE is supported, but the sample application only runs under Windows Mobile 5.0. Try it in the emualtor to explore the capabilities (and limitations) of the "product".

mgmnt studio express won't shrink .ldf files

I'm attempting to truncate/shrink a db (mdf & ldf) to be able to zip it and email it. From Object Explorer I select the db->tasks->shrink->files->filetype->log->release unused spage or reorganize->shrink file to (0mb). This action does not change the size of the .ldf file. Shrinking the mdf works just like SQL 2000 - as expected. Why don't the actions taken do what they imply for the .ldf file? If this is not what the selections mean, what do they mean?

thanks, jack

If you want the LDF to skrink to 0mb then you need to truncate the log because SQL Server in shrink mode reserves what was active log now called virtual log before releasing space to the OS. You can run DBCC Shrinkfile and see what error you get because 2005 now logs the error in the error log. Run a search for DBCC Shrinkfile and Truncate log in the BOL. Hope this helps.

|||Caddre, your response led me to information that explains the 'reality' of dealing with the logfile. In my case since I 'want' an empty db to distribute,I found that I could just detach the db, then delete the .ldf file. When I re-attach a 'new' empty log file is created. -- thanks, jack

Merging, and loading dynamic flat file.

I have number of csv files in a folder, all of them with same columns, need to be merged into one table and imported to sql server.

-The first row of the csv file is a header.
-The csv files are updated everyday
-The destination table is replace by new table with new info in the csv.
-The new csv files can be created and old csv files may no longer exist, but we are only interested in information contain in current csv files in the folder.
-I need SSIS to combine all the csv files in the folder and merge into one table.
-Other issue is that the field names may change in csv, so can the SSIS package recognize the change in field name and made necessary change in destination table as well.

Any insight on this issues will be greatly appreciated?

Put simply this is not a scenario that SSIS supports. The key problem is the dynamic nature of the file structure, which SSIS has no run-time support for. The target scenarios for SSIS revolve around unattended/automated data transfer, and any kind of dynamic format is just never going to work well with SSIS.

What use would a new table be that the system has never seen before? For you, you obviously then interpret this, but unless you tell SSIS to do that up front, it would never make sense for it.

MERGING Variable in FOR LOOP COntainer

Hi All,

Seems like a simple task, but been a struggle.

Simply trying to move a group of files from one folder to another folder and renaming the files with the monthyear in the middle of the filename..

I'm using a FOR Loop container and works find. The added complexity is I'm trying to rename the files the same tine and putting the Month Year into the file name.

I guess the struggle is how to get the file name out so I can manipulate it.

I tried creating variable(V_SOURCE) which stores the file path and create another variable(V_FILENAME) to hold the filename. I believe on the expression page of the FOR LOOP editor if I select the the file name and extension radio button, it should put the file name in the V_FILENAME variable.

In my file task trying to join the two variables together in another variable, keep saying my path is wrong with the file task kicks off.

here's the syntaxt

@.[User::V_SourcePath] + @.[User::V_FILE_NAME]

JUst to follow up if someone can help me with syntaxt for the merge and if they have a better approach

to moving and renaming the files

|||

I haven't checked myself, but do you need to have a \ between the folder and file, or is it included?

You can check the value of your variables by setting a breakpoint and typing the variable into the watch window.

|||THanks is helping out getting a picture of what's going on|||

Dan Cleary wrote:

JUst to follow up if someone can help me with syntaxt for the merge and if they have a better approach

to moving and renaming the files

I have done that using the File System task. I just posted an example in my blog:

http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html

I hope you find it helpful.

|||

Rafeal, looks like just what the docotor ordered, does the scope of the variable make a difference?

Having an issue when joining the SourcePath with the file name. The scope of those variables are at the package level not at For Loop.

I do appreciate your response

|||

Variable scope is not an issue here; if you need it, just define all the variables at the package level.

regards

|||

Rafeal your Blog was great and very useful. I uess my struggle is doing the syntaxt on the file name in the expression builder.

I'm trying to take a group of file that are currently named RPT_BANK_NAME_@.MONTHYEAR_BANKNAME.XLS and

convert it to RPT_BANK_NAME_03_2007_BANKNAME.XLS. I have the report named storec in the variable just not sure on the syntaxt to strip out the @.MONTHYEAR and replace with the month and the year.

Any suggestions?

I tried to do a substring but not recognizing that function in the eexpresion builder

|||

Dan,

I guess I don't understand what is the format of the original name of the file. What I don;t get is the @.MONTHYEAR part.

is 03_2007 the month and year of the package execution date? or are they part of the original file name?

|||

THe @.monthyear is confusing, it's just hardcoded in the report name.

SO what I'm attempting to do in my expresion is take the Variable which is storing the report name

RPT_BANK_NAME_MONTHYEAR_BANKNAME.XLS and replace the monthyear with the curent Month and date.

I tried this but the expresion keeps failing the validation checks. Pretty much what you had in your blog

@.[User::V_DestinationFolder] + SUBSTRING( @.[User::V_Invoice_File] , 1 , FINDSTRING( @.[User::V_Invoice_File],".",1) 1 ) + "-" + (DT_STR, 2, 1252) Month( @.[System::StartTime] )+ (DT_STR, 4, 1252) Year( @.[System::StartTime] )+ SUBSTRING( @.[User::V_Invoice_File] , FINDSTRING( @.[User::V_Invoice_File],".",1) , LEN( @.[User::V_Invoice_File] ) )

|||

You've got an extra 1 in the expression (see red below) After correction, and assuming V_DestinationFolder is c:\temp\, it gives c:\temp\RPT_BANK_NAME_@.MONTHYEAR_BANKNAME.-32007.XLS, which I don't think is exactly what you want.

@.[User::V_DestinationFolder] + SUBSTRING( @.[User::V_Invoice_File] , 1 , FINDSTRING( @.[User::V_Invoice_File],".",1) 1 ) + "-" + (DT_STR, 2, 1252) Month( @.[System::StartTime] )+ (DT_STR, 4, 1252) Year( @.[System::StartTime] )+ SUBSTRING( @.[User::V_Invoice_File] , FINDSTRING( @.[User::V_Invoice_File],".",1) , LEN( @.[User::V_Invoice_File] ) )

The one below returns c:\temp\RPT_BANK_NAME_3-2007_BANKNAME.XLS and uses the Replace function. However, I have not tested it in the context of Rafael's example, so you might need to make some modifications to get it to work for you.

@.[User::V_DestinationFolder] + REPLACE( @.[User::V_Invoice_File] ,"@.MONTHYEAR", ((DT_STR, 2, 1252) MONTH( GETDATE() )) + "-" + ((DT_STR, 4, 1252) YEAR( GETDATE() )) )

|||

John is spot on.

In your case, REPLACE is a better option since '@.MONTHYEAR' is a literal that is always part of the file name. The expression in my example adds the month and year at the end of the file name and before the file extension (.txt); so I used FINDSTRING.

BTW, notice the expressions we are given use @.system::startTime; which gives you the month and year of the package execution date; so make sure that meets your requirements.

|||

Guys, you've been a huge help! I'm doing a watch and looking at the V_DESTINATION_PATH and it shows the

following in the watch window

+ User::V_DestinationPath {E:\\Client Billing 2\\FTP_Incoming\\INVOICE\\RPT-234-3-2007-BILL234.xls} String

but when running the task getting a path error

[File System Task] Error: An error occurred with the following error message: "Could not find a part of the path.". , any idea?

|||Looks like your variable V_Destination_Folder contains too many slashes, perhaps.|||

When you view it in the watch window, it shows the escape characters, thus the doubled slashes. You can validate the value by using a script task with a MsgBox.

Dan, you might want to double-check that the folder and filename you are referencing exist. Also, check permissions to ensure you can write to that location.