I am unable to migrate any DTS packages, from a SQL Server 2000 package, from a structured storage file, or from a DTS package imported into SQL2005 (Developer Edition, 32 bit). Running the Package Migration Wizard, every time I get to the List Package screen, i get the error below. I haven't found any other mention of this so far. Anyone else seen this error or have suggestions?
View 20 RepliesIn Visual Studion I invoke the wizard, indicate the source for the DTS packages and pick a folder for the migrated package but I don't get a list of my source packages. Instead, I get the error message, 'index out of range, must be non negative, parameter name index(mscorlib)'.
Has anyone ever gotten this error. What does it mean and how can I fix it?
Thanks in advance,
Hi,
I use the DTS 2000 Migration Wizard to migrate one of the DTS 2000 packages to SSIS. The migration failed with the following error message:
LogID=17
#Time=6:31 PM
#Level=DTSMW_LOGLEVEL_ERR
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: Failed to save package file "C:Documents and SettingsfuMy DocumentsVisual Studio 2005ProjectsKORTONKORTONProcessCubesMF.dtsx" with error 0x80070002 "The system cannot find the file specified.".
---> System.Runtime.InteropServices.COMException (0xC001100E): Failed to save package file "C:Documents and SettingsfuMy DocumentsVisual Studio 2005ProjectsKORTONKORTONProcessCubesMF.dtsx" with error 0x80070002 "The system cannot find the file specified.".
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToXML(String FileName, IDTSPersist90 pPersistObj, IDTSEvents90 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events)
at Microsoft.SqlServer.Dts.MigrationWizard.DTS9HelperUtility.DTS9Helper.SaveToXML(Package pkg, String sFileLocation)
at Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework.StartMigration(PackageInfo pInfo)
Looking at the call stack, it looks like COM wrapper fails on SaveToXML. Can someone tell me how I should workaround this problem?
Thanks,
Bobby Fu
I'm using SQL Server 2005 Enterprise x64 and when attempting to migrate a DTS from our SQL Server 2000 Standard x86 server I received the following error message:
DTS Migration Wizard Error
Could not load file or assembly 'Microsoft.SqlServer.Exec80PackageTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of it's dependencies. The system cannot find the file specified.
Click Abort to stop the migration of the current package.
Click Retry to retry the operation.
Click Skip to skip the migration of the current task and continue to the next task.
From the error message, it would appear something did not install or register correctly. Any idea on what is missing and how I can fix it?
Hi
When I try to run the ITW to increase performance I get this error in the event viewer. Earlier I have used the ITW with success but now I dont get any more index recommendations, just this error. Do you know what it means :
"The description for Event ID ( 4 ) in Source ( ITW ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event:
Error in Parsing Event:
execute sp_Sys'.
I've been migrating SQL 2000 DTS packages into SQL 2005 using the Migrate DTS 2000 Package wizard in Visual Studio 2005. All packages migrate fine except one which throws out the following error:
exception of type 'Microsoft.SQLServer.DTS.MigrationWizard.HelperUtility.DTSMWException was thrown
No other supporting information is given to help diagnose the problem. Has anyone else come across this error before? Looking at past threads, I've checked the DTS package for leading or trailing spaces which might cause an issue and there are none.
Thanks.
Hi. I've created a number of packages in SSIS which just make temp tables out of views. I did them with the "Optimize for many tables" and "Run in transaction" boxes checked.
Now I'm trying to port them over to another database on another server. I'm first going through the Package Configuration Wizard. When I try to finish the wizard I get a error with the following message:
quote:===================================
Could not complete wizard actions. (Microsoft Visual Studio)
===================================
Could not generate the configuration file. (Microsoft.DataTransformationServices.Wizards)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Wizards.ConfigurationWizardPages.ConfigurationWizardSR&EvtID=CouldNotGenerateConfigurationFile&LinkId=20476
------------------------------
Program Location:
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.OnFinish(CancelEventArgs e)
===================================
Failure exporting configuration file.
(ENRLMNT_UniqueRecords_temp)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Package.ExportConfigurationFile(String str)
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
I don't know how to resolve it. Anyone?
One way to deal with this particular issue would be just to recreate the SSIS package on the other server. The issue with this is I want to be positive which view I'm making a copy of and I'm not currently. Since the Import/Export has the transaction setting checked, I can't seem to determine what the source was. Help?
I am attempting to create an XML Configuration file and I am recieving the following error once I click finish in the wizard:
Could not complete wizard actions.
Additional Information:
Could not generate the configuration file. (Microsoft.Data.TransformationServices.Wizard)
Technical Details:
===================================
Could not complete wizard actions. (Microsoft Visual Studio)
===================================
Could not generate the configuration file. (Microsoft.DataTransformationServices.Wizards)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Wizards.ConfigurationWizardPages.ConfigurationWizardSR&EvtID=CouldNotGenerateConfigurationFile&LinkId=20476
------------------------------
Program Location:
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.OnFinish(CancelEventArgs e)
===================================
Failure exporting configuration file.
(eFreedomAS)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Package.ExportConfigurationFile(String str)
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
Name:
eFreedomAS2
Type:
Configuration File
New configuration file will be created.
File name:
C:abc.xml
Properties:
Package.Variables[User::SourcePath].Properties[Value]
Package.Variables[User::SourcePath].Properties[Name]
Package.Variables[User::Packages].Properties[Value]
Package.Variables[User::Packages].Properties[Name]
Package.Variables[User::PackageDefNumber].Properties[Value]
Package.Variables[User::PackageDefNumber].Properties[Name]
Package.Variables[User::Directory].Properties[Value]
Package.Variables[User::Directory].Properties[Name]
Package.Variables[User::DestinationPath].Properties[Value]
Package.Variables[User::DestinationPath].Properties[Name]
Package.Connections[ViewHelpTopicDef].Properties[Name]
Package.Connections[ViewHelpTopicDef].Properties[ConnectionString]
Package.Connections[ViewDef].Properties[Name]
Package.Connections[ViewDef].Properties[ConnectionString]
Package.Connections[ValidationTestDef].Properties[Name]
Package.Connections[ValidationTestDef].Properties[ConnectionString]
Package.Connections[ValidationRulePackageDef].Properties[Name]
Package.Connections[ValidationRulePackageDef].Properties[ConnectionString]
Package.Connections[ValidationRuleFileDef].Properties[Name]
Package.Connections[ValidationRuleFileDef].Properties[ConnectionString]
Package.Connections[ValidationRuleDef].Properties[Name]
Package.Connections[ValidationRuleDef].Properties[ConnectionString]
Package.Connections[ValidationMessageFileDef].Properties[Name]
Package.Connections[ValidationMessageFileDef].Properties[ConnectionString]
Package.Connections[ValidationMessageDef].Properties[Name]
Package.Connections[ValidationMessageDef].Properties[ConnectionString]
Package.Connections[ValidationIdentifierDependency].Properties[Name]
Package.Connections[ValidationIdentifierDependency].Properties[ConnectionString]
Package.Connections[ValidationCalcGraphEdge].Properties[Name]
Package.Connections[ValidationCalcGraphEdge].Properties[ConnectionString]
Package.Connections[UserGroupFeatureDef].Properties[Name]
Package.Connections[UserGroupFeatureDef].Properties[ConnectionString]
Package.Connections[UserGroupFeature].Properties[Name]
Package.Connections[UserGroupFeature].Properties[ConnectionString]
Package.Connections[UserGroupDef].Properties[Name]
Package.Connections[UserGroupDef].Properties[ConnectionString]
Package.Connections[UserGroup].Properties[Name]
Package.Connections[UserGroup].Properties[ConnectionString]
Package.Connections[TableDef].Properties[Name]
Package.Connections[TableDef].Properties[ConnectionString]
Package.Connections[Source].Properties[UserName]
Package.Connections[Source].Properties[ServerName]
Package.Connections[Source].Properties[Password]
Package.Connections[Source].Properties[Name]
Package.Connections[Source].Properties[InitialCatalog]
Package.Connections[Source].Properties[ConnectionString]
Package.Connections[SelectListItemDef].Properties[Name]
Package.Connections[SelectListItemDef].Properties[ConnectionString]
Package.Connections[SelectListDef].Properties[Name]
Package.Connections[SelectListDef].Properties[ConnectionString]
Package.Connections[ScriptAssemblyDef].Properties[Name]
Package.Connections[ScriptAssemblyDef].Properties[ConnectionString]
Package.Connections[PrintedPageFormulaScriptDef].Properties[Name]
Package.Connections[PrintedPageFormulaScriptDef].Properties[ConnectionString]
Package.Connections[PageDef].Properties[Name]
Package.Connections[PageDef].Properties[ConnectionString]
Package.Connections[PageCalcPathSubPath].Properties[Name]
Package.Connections[PageCalcPathSubPath].Properties[ConnectionString]
Package.Connections[PageCalcPath].Properties[Name]
Package.Connections[PageCalcPath].Properties[ConnectionString]
Package.Connections[PackageLinkDef].Properties[Name]
Package.Connections[PackageLinkDef].Properties[ConnectionString]
Package.Connections[PackageImportTypeDef].Properties[Name]
Package.Connections[PackageImportTypeDef].Properties[ConnectionString]
Package.Connections[PackageIdentifierGroupDef].Properties[Name]
Package.Connections[PackageIdentifierGroupDef].Properties[ConnectionString]
Package.Connections[PackageIdentifierDef].Properties[Name]
Package.Connections[PackageIdentifierDef].Properties[ConnectionString]
Package.Connections[PackageExportTypeDef].Properties[Name]
Package.Connections[PackageExportTypeDef].Properties[ConnectionString]
Package.Connections[PackageDef].Properties[Name]
Package.Connections[PackageDef].Properties[ConnectionString]
Package.Connections[PackageDataItemTextDef].Properties[Name]
Package.Connections[PackageDataItemTextDef].Properties[ConnectionString]
Package.Connections[OnlinePagePrintedPageDef].Properties[Name]
Package.Connections[OnlinePagePrintedPageDef].Properties[ConnectionString]
Package.Connections[OnlinePageDefDependency].Properties[Name]
Package.Connections[OnlinePageDefDependency].Properties[ConnectionString]
Package.Connections[OnlinePageDef].Properties[Name]
Package.Connections[OnlinePageDef].Properties[ConnectionString]
Package.Connections[MaterialityToleranceDef].Properties[Name]
Package.Connections[MaterialityToleranceDef].Properties[ConnectionString]
Package.Connections[LineDef].Properties[Name]
Package.Connections[LineDef].Properties[ConnectionString]
Package.Connections[ImportTypeDef].Properties[Name]
Package.Connections[ImportTypeDef].Properties[ConnectionString]
Package.Connections[ImportDef].Properties[Name]
Package.Connections[ImportDef].Properties[ConnectionString]
Package.Connections[IdentifierStateDef].Properties[Name]
Package.Connections[IdentifierStateDef].Properties[ConnectionString]
Package.Connections[IdentifierRelatedDef].Properties[Name]
Package.Connections[IdentifierRelatedDef].Properties[ConnectionString]
Package.Connections[IdentifierPrintReferenceDef].Properties[Name]
Package.Connections[IdentifierPrintReferenceDef].Properties[ConnectionString]
Package.Connections[IdentifierGroupUserGroupFeatureDef].Properties[Name]
Package.Connections[IdentifierGroupUserGroupFeatureDef].Properties[ConnectionString]
Package.Connections[IdentifierGroupUserGroupFeature].Properties[Name]
Package.Connections[IdentifierGroupUserGroupFeature].Properties[ConnectionString]
Package.Connections[IdentifierGroupIdentifierDef].Properties[Name]
Package.Connections[IdentifierGroupIdentifierDef].Properties[ConnectionString]
Package.Connections[IdentifierGroupIdentifier].Properties[Name]
Package.Connections[IdentifierGroupIdentifier].Properties[ConnectionString]
Package.Connections[IdentifierGroupDef].Properties[Name]
Package.Connections[IdentifierGroupDef].Properties[ConnectionString]
Package.Connections[IdentifierGroup].Properties[Name]
Package.Connections[IdentifierGroup].Properties[ConnectionString]
Package.Connections[IdentifierDef].Properties[Name]
Package.Connections[IdentifierDef].Properties[ConnectionString]
Package.Connections[IdentifierDataItemTextDef].Properties[Name]
Package.Connections[IdentifierDataItemTextDef].Properties[ConnectionString]
Package.Connections[FormulaScriptDef].Properties[Name]
Package.Connections[FormulaScriptDef].Properties[ConnectionString]
Package.Connections[FormulaDef].Properties[Name]
Package.Connections[FormulaDef].Properties[ConnectionString]
Package.Connections[FeatureGroupFeatureDef].Properties[Name]
Package.Connections[FeatureGroupFeatureDef].Properties[ConnectionString]
Package.Connections[FeatureGroupDef].Properties[Name]
Package.Connections[FeatureGroupDef].Properties[ConnectionString]
Package.Connections[FeatureDef].Properties[Name]
Package.Connections[FeatureDef].Properties[ConnectionString]
Package.Connections[ExportTypeRelatedDef].Properties[Name]
Package.Connections[ExportTypeRelatedDef].Properties[ConnectionString]
Package.Connections[ExportTypeFormulaScriptDef].Properties[Name]
Package.Connections[ExportTypeFormulaScriptDef].Properties[ConnectionString]
Package.Connections[ExportTypeExportDef].Properties[Name]
Package.Connections[ExportTypeExportDef].Properties[ConnectionString]
Package.Connections[ExportTypeDef].Properties[Name]
Package.Connections[ExportTypeDef].Properties[ConnectionString]
Package.Connections[ExportTypeBlobTypeDef].Properties[Name]
Package.Connections[ExportTypeBlobTypeDef].Properties[ConnectionString]
Package.Connections[ExportFormulaScriptDef].Properties[Name]
Package.Connections[ExportFormulaScriptDef].Properties[ConnectionString]
Package.Connections[ExportDef].Properties[Name]
Package.Connections[ExportDef].Properties[ConnectionString]
Package.Connections[ColumnHeaderDef].Properties[Name]
Package.Connections[ColumnHeaderDef].Properties[ConnectionString]
Package.Connections[ColumnDef].Properties[Name]
Package.Connections[ColumnDef].Properties[ConnectionString]
Package.Connections[CellTypeFileTypeDef].Properties[Name]
Package.Connections[CellTypeFileTypeDef].Properties[ConnectionString]
Package.Connections[CellTypeDef].Properties[Name]
Package.Connections[CellTypeDef].Properties[ConnectionString]
Package.Connections[CellRangeDef].Properties[Name]
Package.Connections[CellRangeDef].Properties[ConnectionString]
Package.Connections[CellRangeCellDef].Properties[Name]
Package.Connections[CellRangeCellDef].Properties[ConnectionString]
Package.Connections[CellOverrideDef].Properties[Name]
Package.Connections[CellOverrideDef].Properties[ConnectionString]
Package.Connections[CellDef].Properties[Name]
Package.Connections[CellDef].Properties[ConnectionString]
Package.Connections[CategoryDef].Properties[Name]
Package.Connections[CategoryDef].Properties[ConnectionString]
Package.Connections[CalcPathSubPath].Properties[Name]
Package.Connections[CalcPathSubPath].Properties[ConnectionString]
Package.Connections[CalcPath].Properties[Name]
Package.Connections[CalcPath].Properties[ConnectionString]
Package.Connections[CalcGraphEdge].Properties[Name]
Package.Connections[CalcGraphEdge].Properties[ConnectionString]
Package.Connections[AreaDef].Properties[Name]
Package.Connections[AreaDef].Properties[ConnectionString]
Hi,
I am using the SQL Package Installation Wizard to deploy my SSIS packages on to a 64-bit SQL Server and I am getting this error, Library not registered. I am also getting the same error when I tried to import a SSIS package from a 32-bit SQL Server. I was able to save my SSIS packages to the 64-bit SQL Server one by one from Visual Studio. My server is run Windows 2003 Enterprise x64 with SP1, and SQL 2005 Enterprise x64 with SP1 and hotfixes. 64-bit .Net Framework is also registered on the machine.
This is the error from the installation log file:
Exception details: Microsoft.SqlServer.Dts.Runtime.DtsTaskException: Library not registered.
---> System.Runtime.InteropServices.COMException (0x8002801D): Library not registered.
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage90 Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, String ServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)
Thanks in Advance.
Keep getting this error when positioning to the last page of a report.
Using Server 2003...SqlRpt Svcs 2000 sp2
Detail error msg:
Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help
Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
Anyone have any suggestions? Any way to find out what collection is blowing?...or where parameter name: index comes from?
I am trying to
copy a database from our company's external SQL
Server(production) to our local SQL
Server(development). The Copy Database wizard fails on the step
"Execute SQL Server Agent Job".
Following is the error in the log file.. Please advise
InnerException-->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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I applied the DTS Migraiton Wizard to a DTS package and it worked fine with one BIG exception. The DTS package imports a fixed-width record, length about 1500 bytes, with 60+ "parse" lines (one per field). The migrated SSIS package did not preserve any of the parse structure. That's alot of error prone worke to recreate and we have another 3 DTS packages based on the same parsing. Any suggestions on how to preserve the parsing structure in SSIS?
TIA,
barkingdog
From SQL Server Management Studio I right click on Management/Legacy/DTS and select Migration Wizard and enter a SQL Server Source and Destination. A list of DTS packages from the source server is displayed and I select one of the DTS packages and give the destination a unique name. The wizard runs and says it's successful. I can't find the new SSIS version of the DTS package with the new name that I've given it, however. Where does it put the new migrated copy of the DTS package.
Thanks,
John
I ran the upgrade advisor on a SQL Server 2000 DTS package and received the following:
Upgrade Function: Replace functionality of complex Data Transformation task encapsulated in Execute DTS 2000 Package task after package migration
Message: The SQL Server 2005 Integration Services (SSIS) Package Migration Wizard does not migrate complex Data Transformation tasks in SQL Server 2000 Data Transformation Services (DTS) packages. The migrated package will contain encapsulated DTS functionality that must eventually be removed or redesigned.
When I run the Migration Wizard, it runs successfully, with no encapsulated DTS fuctionality that I can see. As far as I can tell from comparing the two, it looks like it migrated successfully without any help from me! I'm not familiar with the business logic of the DTS package, so am worried that I'm missing something.
Is it possible for the Upgrade advisor to be wrong?
Are there any advanced or random screens that I can check for something that might not have migrated correctly?
Thanks for any insight that you can provide!
Jessica
Thanks to Sean for helping me find the migrated packages. I'd like to edit one of the connections on a bunch of packages that I migrated. I see in the Run Package there are configuration options that would allow me to mofify the connection string at that point in time, but I would like to modify the package so it has the new connection string. I was thinking I could access it in BI Dev studio, but I'm not sure how to get to it. I suppose I could migrate to a file and then edit the file prior to importing, but I'm curious if there's a way I can modify the packages that show up under Integration Services/Stored Packages/MSDB.
Thanks,
John
Hi,
It appears that the migration wizard is not installed with the developer edition of SQL 2005. I have installed another version of SQL 2005 and have run through the migration wizard.
With what editions of SQL Server the migartion wizard comes as a default ?
Thanks,
Vaishu
i am trying to use the DTS migration wizard in sql server 2005 to migrate some of the DTS packages that i have on sql server 2000.
After entering the source and destination server i get the following error:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)
Does anyone know the reson behind this?
Thanks for any help.
I have several DTS packages to migrate and would like to script the migration process rather than interactively migrating one DTS package at a time.
Can this be scripted and if so how?
I am trying to import data from SQL 2000 to SQL 2005
The Data schemas are the same in both (tables, relationships, key and triggers).
Using the wizard I am trying to import data from SQL 2000 to SQL 2005. The issue I face is to manage the Idenity columns. I do not want the identity values from the SQL 2000 DB which may be at say 5000, instead I want to use the identity values from the SQL 2005 database which will problably start at 1
Is there a way to do this, should I use a custom query instead of a direct table dump. If using a custom query do I need to just specify a Select query or does it have to be a specific "INSERT INTO Table ..." type query
If I do import the data directly with Identity "ON" how can I advance the identity column value to current +1 on the SQL 2005 table.
Thanks
javahar
Hi,
I wanted to use the Index Tuning Wizard to monitor the performance of a stored procedure but the option is greyed out. Is there a way to turn this functionality on, or does this indicate that this option is not installed ?
Thanks,
Jeff
hi all,
jusr read about index tuning wizard in BOL.. not sure about it enuff.. can anybody explain in what scenario we should use this wizard/
~~~Focus on problem, not solution~~~
HiI tried running ITW against one of our databases, and it came up with anumber of suggestions, but also filled the Application Log with messageslike:-The description for Event ID ( 4 ) in Source ( ITW ) could not be found. Itcontains the following insertion string(s):Error in Parsing Event:declare @P1 nvarchar(1)declare @P2 nvarchar(1)declare @P3 nvarchar(1)declare @P4 nvarchar(1)EXEC "dbo"."sp_get_RAO_indexW2K2" @P1 , @P2 , @P3 , @P4 .Does anyone know if this is serious (or indeed what it means at all)?There were no apparent errors in the ITW run.Chloe Crowder
View 1 Replies View RelatedStarting with a SQL Server 2000 database, my company built a new server with SQL Server 2005 and restored the SS2000 database from backups. We're now seeing some extreme issues where queries that took 30 seconds now take 3 minutes. Would this make you suspect index issues? Any recommendations on diagnosing and fixing this would be appreciated.
View 4 Replies View RelatedHow to migrate FULL TEXT indexes from SQL SERVER 2000 to 2005? Is it okay if I migrate the MSDB DB? Do i need to create the physical folders manually?
------------------------
I think, therefore I am - Rene Descartes
Hi, I want to count the total number of rows in the table "members" and display this result in a ListBox. When I try to run this procedure I get an error message reading "Index out of range exception". What could this mean?
BTW, I know that the logic doesn´t make sense. I want to show the number of rows but I try to show a field name. Does anyone have solution, please? I would appreciate the help.
string connectionString2 = ConfigurationManager.ConnectionStrings["ServetteConnectionString"].ConnectionString; //CREATE CONNECTIONSTRING
string sQuery2 = "select count(*) from members"; //GET NUMBER OF ROWS
OleDbConnection oOleDbConnection2 = new OleDbConnection(connectionString2); oOleDbConnection2.Open(); //CREATE CONNECTION
OleDbCommand command2 = new OleDbCommand(sQuery2, oOleDbConnection2); CREATE COMMAND
OleDbDataReader reader2 = command2.ExecuteReader(); CREATE READER
while (reader2.Read())
{
ListBox1.Items.Add new ListItem(reader2["firstName"].ToString())); //THIS LINE RESULTS IN "INDEX OUT OF RANGE EXCEPTION" (STRANGE CODE LOGIC TOO)
}
observed below error in sqlserver2012.index was out of range. Must be non-negative and less than the size of the collection.
View 2 Replies View RelatedI get this error when exporting to Excel from the designer or from the Report Manager:
"Exception: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index"
One solution is:
(1) One Detail Cell in my table contained a number like #.#########. Aparently this freaks out Excel. I converted it to a string like this:
=Convert.ToString(Format((ReportItems!ValueOne.Value / ReportItems!ValueTwo.Value), "#.#########")) This sometimes works but makes the export have text fields and numbers under 0 show just .01 instead of 0.01 for example.
(2) Apparently disabling the Document Map Labels has the same effect and cures the problem - HOW DO YOU DO THIS?????? There is a label property for text boxes - but these are not populated.
Reading the internet..says that the SP2 for SQL server should slolve it. It hasnt.
please help..
Thanks
David
I've tried many times to get the index tuning wizard to work...It never seems to find any 'parseable queries' in my workload file. I believe that I'm running the profiler correctly.
When I submit a simple sql file as a workload file, I get a 'server error creating table or index analysis...' back.
Any suggestions or hints?
Thanks,
Steve
I am running a Desktop SQL 7.0 database on Windows 95. I produced a trace file using the Profiler and am trying to run the Index Tuning Wizard on the trace file. I always get an error message "Error analyzing workload (60).". I cannot find anything in Books Online or the Microsoft web site.
Thanks for any help.
Hi,I am having problems getting anything useful out of the index tuningwizard.I have created a table and inserted data into it. When i run the indextuning wizard i expect 2 indexes to be recommended so the book says(Index011 with a key on the uniqueid column and a non clustered indexnamed table02 with a key on the col03 and LongCol02)Instead i get nothing being recommended.What am i doing wrong????Please helpMaryamif exists (select name from dbo.sysobjects where name ='table01' andtype ='u')drop table table01create table table01(uniqueid int identity, longcol02 char(300)DEFAULT 'THIS IS THE DEfault column',col03 char(1))godeclare @counter intset @counter =1while @counter<=1000begininsert table01 (col03) values('a')insert table01 (col03) values('b')insert table01 (col03) values('c')insert table01 (col03) values('d')insert table01 (col03) values('e')insert table01 (col03) values('f')set @counter=@counter+1end
View 3 Replies View RelatedI receive this error during rendering when I have two cells merged together:
Error Snippet
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
When I "Split Cells" on the offending cells, it starts to work. This report renders without error when run on the RS server. This error only occurs when running the report locally on the "Preview" tab in the report designer.
I have closed the IDE and deleted the *.data files and restarted with the same results. Is there anyway to get more information about the error to help debug the problem?
Thanks!
~Jon
My SSIS package is running very slow taking so much time to execute, One task is taking 2hr for inserting 100k records, i have disabled unused index still it is taking time.I am rebuilding/Refreshing indexes and stats once in month if i try to execute on daily basis will it improve my SSIS Package performance?
View 2 Replies View RelatedI'm Using a CLR for creating a trigger on database tables,
This is my Exception :
A .NET Framework error occurred during execution of user defined routine or aggregate 'AvailableFlightTrgg': System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index System.ArgumentOutOfRangeException: at System.Collections.ArrayList.get_Item(Int32 index) at Triggers.AvailableFlightTrgg() . A .NET Framework error occurred during execution of user defined routine or aggregate 'AvailableFlightInsert': System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution of user defined routine or aggregate 'AvailableFlightTrgg': System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index System.ArgumentOutOfRangeException: at System.Collections.ArrayList.get_Item(Int32 index) at Triggers.AvailableFlightTrgg() . INSERT [SamaCRSHistory].[dbo].[AvailableFlight] VALUES ('283','50','23','4','2','6','15','1','5','4','5/25/2008 8:30:00 AM','5/25/2008 7:00:00 AM','6/26/2008 12:00:00 AM','5','AR2580','125','0','False','False','1','Flight created on 5/25/2008 00:00:00','1', 'I', GETDATE()); INSEA .NET Framework error occurred during execution of user defined routine or aggregate 'AvailableFlightTrgg': System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index System.ArgumentOutOfRangeException: at System.Collections.ArrayList.get_Item(Int32 index) at Triggers.AvailableFlightTrgg() . A .NET Framework error occurred during execution of user defined routine or aggregate 'AvailableFlightInsert': System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution of user defined routine or aggregate 'AvailableFlightTrgg': System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index System.ArgumentOutOfRangeException: at System.Collections.ArrayList.get_Item(Int32 index) at Triggers.AvailableFlightTrgg() . INSERT [SamaCRSHistory].[dbo].[AvailableFlight] VALUES ('283','50','23','4','2','6','15','1','5','4','5/25/2008 8:30:00 AM','5/25/2008 7:00:00 AM','6/26/2008 12:00:00 AM','5','AR2580','125','0','False','False','1','Flight created on 5/25/2008 00:00:00','1', 'I', GETDATE()); INSERT [SamaCRS].[dbo].[AvailableFlightSubClass] VALUES ('283','7','125','125','0','0','Flight created on 5/25/2008 00:00:00','1'); INSERT [SamaCRS].[dbo].[AvailableFlightSubClass] VALUES ('283','4','25','25','20','20','Flight created on 5/25/2008 00:00:00','1'); The statement has been terminated. System.Data.SqlClient.SqlException: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages) at Microsoft.SqlServer.Server.SmiEventSink_Default.DispatchMessages(Boolean ignoreNonFatalMessages) at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteToPipe(SmiContext pipeContext) at Microsoft.SqlServer.Server.SqlPipe.ExecuteAndSend(SqlCommand command) at StoredProcedures.AvailableFlightInsert(Decimal AvailableFlightTimeTableID, Decimal Availabl... INSERT [SamaCRSHistory].[dbo].[AvailableFlight] VALUES ('283','50','23','4','2','6','15','1','5','4','5/25/2008 8:30:00 AM','5/25/2008 7:00:00 AM','6/26/2008 12:00:00 AM','5','AR2580','125','0','False','False','1','Flight created on 5/25/2008 00:00:00','1', 'I', GETDATE()); INSERT [SamaCRS].[dbo].[AvailableFlightSubClass] VALUES ('283','7','125','125','0','0','Flight created on 5/25/2008 00:00:00','1'); INSERT [SamaCRS].[dbo].[AvailableFlightSubClass] VALUES ('283','4','25','25','20','20','Flight created on 5/25/2008 00:00:00','1');RT [SamaCRS].[dbo].[AvailableFlightSubClass] VALUES ('283','7','125','125','0','0','Flight created on 5/25/2008 00:00:00','1'); INSERT [SamaCRS].[dbo].[AvailableFlightSubClass] VALUES ('283','4','25','25','20','20','Flight created on 5/25/2008 00:00:00','1'); The statement has been terminated. System.Data.SqlClient.SqlException: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages) at Microsoft.SqlServer.Server.SmiEventSink_Default.DispatchMessages(Boolean ignoreNonFatalMessages) at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteToPipe(SmiContext pipeContext) at Microsoft.SqlServer.Server.SqlPipe.ExecuteAndSend(SqlCommand command) at StoredProcedures.AvailableFlightInsert(Decimal AvailableFlightTimeTableID, Decimal Availabl... INSERT [SamaCRSHistory].[dbo].[AvailableFlight] VALUES ('283','50','23','4','2','6','15','1','5','4','5/25/2008 8:30:00 AM','5/25/2008 7:00:00 AM','6/26/2008 12:00:00 AM','5','AR2580','125','0','False','False','1','Flight created on 5/25/2008 00:00:00','1', 'I', GETDATE()); INSERT [SamaCRS].[dbo].[AvailableFlightSubClass] VALUES ('283','7','125','125','0','0','Flight created on 5/25/2008 00:00:00','1'); INSERT [SamaCRS].[dbo].[AvailableFlightSubClass] VALUES ('283','4','25','25','20','20','Flight created on 5/25/2008 00:00:00','1');
This is my Code :case TriggerAction.Insert:using (SqlConnection connection = new SqlConnection(@"context connection=true"))
{
connection.Open();command = new SqlCommand(@"SELECT * FROM INSERTED;", connection);
dr = command.ExecuteReader();
dr.Read();AvailableFlightID = (Decimal)dr[0];
AvailableFlightTimeTableID = (Decimal)dr[1];AvailableFlightAirlineID = (Decimal)dr[2];
AvailableFlightRoutingID = (Decimal)dr[3];AvailableFlightAPTerminalIDOrg = (Decimal)dr[4];
AvailableFlightAPTerminalIDDest = (Decimal)dr[5];AvailableFlightAirCraftID = (Decimal)dr[6];
AvailableFlightFlightStatusID = (Decimal)dr[7];AvailableFlightCateringID = (Decimal)dr[8];
AvailableFlightPayLoadTableID = (Decimal)dr[9];AvailableFlightArrTime = (DateTime)dr[10];
AvailableFlightDeptTime = (DateTime)dr[11];AvailableFlightDate = (DateTime)dr[12];
AvailableFlightDayName = (int)dr[13];AvailableFlightFlightNo = (String)dr[14];
AvailableFlightCapacity = (int)dr[15];AvailableFlightFreeBaggage = (int)dr[16];
AvailableFlightHaveChild = (bool)dr[17];AvailableFlightHaveParrent = (bool)dr[18];
AvailableFlightCommissionPercent = (int)dr[19];AvailableFlightRemark = (String)dr[20];AvailableFlightUserID = (Decimal)dr[21];
dr.Close();f (AvailableFlightID != 0)
{command = new SqlCommand(@"INSERT [SamaCRSHistory].[dbo].[AvailableFlight] VALUES ('" + AvailableFlightID + @"','" + AvailableFlightTimeTableID + @"','" + AvailableFlightAirlineID + @"','" + AvailableFlightRoutingID + @"','" + AvailableFlightAPTerminalIDOrg + @"','" + AvailableFlightAPTerminalIDDest + @"','" + AvailableFlightAirCraftID + @"','" + AvailableFlightFlightStatusID + @"','" + AvailableFlightCateringID + @"','" + AvailableFlightPayLoadTableID + @"','" + AvailableFlightArrTime + @"','" + AvailableFlightDeptTime + @"','" + AvailableFlightDate + @"','" + AvailableFlightDayName + @"','" + AvailableFlightFlightNo + @"','" + AvailableFlightCapacity + @"','" + AvailableFlightFreeBaggage + @"','" + AvailableFlightHaveChild + @"','" + AvailableFlightHaveParrent + @"','" + AvailableFlightCommissionPercent + @"','" + AvailableFlightRemark + @"','" + AvailableFlightUserID + @"', '" + "I" + @"', " + "GETDATE()" + @");", connection);
pipe.Send(command.CommandText);
command.ExecuteNonQuery();command = new SqlCommand(@"SELECT TimeTableSubClassSubClassID , TimeTableSubClassMaxCapacity, TimeTableSubClassWaitListCapacity FROM [SamaCRS].[dbo].[TimeTableSubClass] Where TimeTableSubClassTimeTableID = '" + AvailableFlightTimeTableID + "'", connection);
dr = command.ExecuteReader();
System.Collections.ArrayList SubClassIDList = new System.Collections.ArrayList();
System.Collections.ArrayList SubClassCapacityList = new System.Collections.ArrayList();System.Collections.ArrayList SubClassWaitListCapacityList = new System.Collections.ArrayList();while (dr.Read())
{
SubClassIDList.Add(dr["TimeTableSubClassSubClassID"]);SubClassCapacityList.Add(dr["TimeTableSubClassMaxCapacity"]);SubClassWaitListCapacityList.Add(dr["TimeTableSubClassWaitListCapacity"]);
}
dr.Close();
SubClassIDList.TrimToSize();
SubClassCapacityList.TrimToSize();
SubClassWaitListCapacityList.TrimToSize();int CountID = SubClassIDList.Count;for (int i = 0; i <= CountID; i++)
{
command = new SqlCommand(@"INSERT [SamaCRS].[dbo].[AvailableFlightSubClass] VALUES ('" + AvailableFlightID + @"','" +SubClassIDList[i] + @"','" +
SubClassCapacityList[i] + @"','" + SubClassCapacityList[i] + @"','" +
SubClassWaitListCapacityList[i] + @"','" + SubClassWaitListCapacityList[i] + @"','" +
AvailableFlightRemark + @"','" + AvailableFlightUserID + @"');", connection);
pipe.Send(command.CommandText);
command.ExecuteNonQuery();
}
////----------------------------------------
}
}
break;
this Code doesnt Work , but before writing this one I used the Code Below and It was working perfectly,
Previous Working Code :
//Initialize all TimeTable Classes for Created Flightcommand = new SqlCommand(@"SELECT TimeTableSubClassSubClassID FROM [SamaCRS].[dbo].[TimeTableSubClass] Where TimeTableSubClassTimeTableID = '" + AvailableFlightTimeTableID + "'", connection);
dr = command.ExecuteReader();
System.Collections.ArrayList SubClassIDList = new System.Collections.ArrayList();while (dr.Read())
{
SubClassIDList.Add(dr.GetValue(0));
}
dr.Close();
SubClassIDList.TrimToSize();foreach (object AvailableFlightSubClassID in SubClassIDList)
{command = new SqlCommand(@"INSERT [SamaCRS].[dbo].[AvailableFlightSubClass] VALUES ('" + AvailableFlightID + @"','" + AvailableFlightSubClassID + @"','" + AvailableFlightCapacity + @"','" + AvailableFlightCapacity + @"','" + 0 + @"','" + 0 + @"','" + AvailableFlightRemark + @"','" + AvailableFlightUserID + @"');", connection);
pipe.Send(command.CommandText);
command.ExecuteNonQuery();
}
Can ANy one Help me with this Exception , I have Checked The Tables for Number of Columns , its not from Column numbers ,I Think iys from For() Loop????????