Load Dts2000 Fails
Jun 11, 2007
Sometime ago i had to edit a dts package in ssis. To do that i've instaled the sql2005 dts. It worked fine at the time. But now i'm trying to open a dts in ssis after installing sp2 and it doesn't work. Every time i try to open a dts package i got the following error.
Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio)
------------------------------
Program Location:
at DTS.CDTSLegacyDesignerClass.ShowDesigner()
at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.GeneralView.btnEdit_Click(Object sender, EventArgs args)
I dont understand why this is happening. Just one thing i use to have windows server 2003 now i've xp sp2. I donīt know if this can be important but.
Thanks in advance.
View 9 Replies
ADVERTISEMENT
Nov 2, 2006
Hi everyone,
Right now we are trying to replace all stored procedures by SSIS logic.
One of the stored procedures does the following,
1. For Every record in PSTREELEAF find the Hierarchy FROM
PSTREENODE and store them in local valriables.
First the stored procedure pulls all the data from the PSTREELEAF table based on join condition into local variables using cursor. Then for every record in the cursor it finds the corresponding records from PSTREENODE table. This is just a part of the stored procedure.
can anyone tell me how can i do this in SSIS? and also tell me which task would be a perfect replacement for CURSORS in SSIS?
Thanks,
Praveen
View 2 Replies
View Related
Apr 7, 2007
Just tried upgrading to SP2. All went well except for Client Components. Here's what I think is the relevant serction from sqlrun_tools.msp.log:
MSI (s) (80:04) [11:25:22:989]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIB24.tmp, Entrypoint: CommitTransaction
04/07/07 11:25:23 DDSet_Status: LANGID: 1033
04/07/07 11:25:23 DDSet_Entry: CommitTransaction started
04/07/07 11:25:23 DDSet_Status: LANGID: 1033
04/07/07 11:25:23 DDSet_Entry: CMsHelpObject constructor
04/07/07 11:25:23 DDSet_Status: LANGID: 1033
04/07/07 11:25:23 DDSet_Entry: CHelpCrypto constructor
04/07/07 11:25:23 DDSet_Exit: CHelpCrypto destructor
04/07/07 11:25:23 DDSet_Status: CommitTransaction()->IHxRegisterSession::CommitTransaction() returned 0.
04/07/07 11:25:23 DDSet_Status: CommitTransaction()->{FE7C8861-3195-4CA5-98EB-094652478192} was successfully committed.
04/07/07 11:25:23 DDSet_Exit: CMsHelpObject destructor
04/07/07 11:25:23 DDSet_Exit: CommitTransaction ended
MSI (s) (80:98) [11:25:23:083]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIB25.tmp, Entrypoint: Do_sqlAssemblyRegSvcsWOW
<Func Name='LaunchFunction'>
Function=Do_sqlAssemblyRegSvcs
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlAssemblyRegSvcs
PerfTime Start: Do_sqlAssemblyRegSvcs : Sat Apr 07 11:25:23 2007
<Func Name='Do_sqlAssemblyRegSvcs'>
Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog.
Error: 2147942402
Error message: The system cannot find the file specified.
Error descrition: Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the file specified.
Error Code: -2147024894
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlcasqlassembly.cpp
Compiler Timestamp: Wed Jun 14 16:27:11 2006
Function Name: Do_sqlAssemblyRegSvcs
Source Line Number: 155
MSI (s) (80!8C) [11:25:25:973]: Transforming table Error.
MSI (s) (80!8C) [11:25:25:973]: Transforming table Error.
MSI (s) (80!8C) [11:25:25:973]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: -2147024894
MSI (s) (80!8C) [11:25:26:067]: Transforming table Error.
MSI (s) (80!8C) [11:25:26:067]: Transforming table Error.
MSI (s) (80!8C) [11:25:26:067]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (80!8C) [11:25:26:067]: Product: Microsoft SQL Server 2005 Tools (64-bit) -- Error 29549. Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the file specified.
Error 29549. Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the file specified.
<EndFunc Name='LaunchFunction' Return='-2147024894' GetLastError='0'>
MSI (s) (80:70) [11:25:26:333]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=914840316,LangId=1033,Platform=589824,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (80:70) [11:25:26:333]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (80:70) [11:25:26:333]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005 Tools (64-bit))
MSI (s) (80:70) [11:25:26:333]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (80:70) [11:25:26:333]: Executing op: RegisterBackupFile(File=C:Config.Msi6d67d1.rbf)
Help?
View 9 Replies
View Related
May 9, 2007
Hey,
I seem somehow stuck in some Script Task problems in SSIS on a x64-environment which has SP2 installed already.
If I'm running the package in 32-bit mode, I'm continuously getting the following error
"Warning: Precompiled script failed to load. Attempting to recompile. For more information, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885)."
on one of the package's scripts --
the given links advises to install SP2... what a useless hint.
And if I switch the project to run in Run64BitRuntime=True , another script tasks complains
"ScriptTask_78888010d24c477ea7c8d69f4f5568a5 is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)
-- whatever that might mean...
Maybe I should add that the packages were running in 32-bit mode for the last 12 months now. Without any problems like that.
Those effects are occuring since we put SP2 onto the server...
Any comments on this topic? Similar experiences? Maybe yet some solutions too?
Regards, Frank
View 4 Replies
View Related
Jun 21, 2005
My first period using SSIS in a real-world application convinced me that there
View 4 Replies
View Related
Jul 14, 2000
Hi All,
I am trying to restore a DB from my production to Standby server..it gives me a mesage "Msg 3105, Level 16, State 1
Data on dump will not fit into current database. Need 6500 Mbyte database."
The production server DB size is 5000MB and I have increased the size of standby DB to 6500MB but still the same message...
HELP!!!!!
Thanks in Advance
View 1 Replies
View Related
Jul 26, 2007
Since applying July 2007 Microsoft patches it was noted that we were not able to open the editor for the Script Task component in an SSIS package. We received an error dialog with text similar to 'Engine failed with unknown error. (Microsoft.VisualBasic.Vsa.Dt).' All other solutions provided in the forum did not resolve our issue. It was noted somewhere else that the OLE32.dll seemed to have been affected. We reregistered this file using the command 'regsvr32.exe ole32.dll' and suddenly we were able to get into the editor. I don't know why this fixed the issue, but it did for us in our environment. Good luck!
View 3 Replies
View Related
Jul 17, 2007
Good day all,
I am having an interesting SSIS problem where the package fails to load with the following error message:
Code: 0xC0010018
Source: {BE86A659-AB44-403A-9C89-3524821879E0}
Description: Error loading value "" DTS:Name="SqlStatementSource">"Select dbo.fnGetLastOpenExtract('" + @[User::in_ExtractName] + "') as eh_ID"" from node "DTS: PropertyExpression".
This very same package runs on our test server, but fails to even load on UAT server.
SSIS packages are the same on both Test and UAT servers (I compared not just dates and sizes - they are literally the same: byte-to-byte)
DTExec version is 9.00.3042.00 on both servers.
HKLMSOFTWAREMicrosoftMicrosoft SQL Server90DTSSetupVersion = 9.2.3042.00 on both machines.
This started to happen when the UAT machine was upgraded to Service Pack 2 of SQL Server 2005. Please note that the UAT server only runs SSIS packages and does not have SQL 2005 database engine installed. There is, however, an older installation of SQL Server 2000 on UAT machine (I am not sure if Test machine has it - will check tomorrow).
Any help is greatly appreciated.
Thanks,
Alex
Here is the compete output from DTExec:
Code Snippet
D:AM5Jobs>"C:Program FilesMicrosoft SQL Server90DTSBinnDTExec.exe" /File "D:ExtractsGBG_ExtractSSISImport_ExtractStartComplete_03.dtsx" /Checkp OFF /Cons MT /Set Package.Variables[User::in_ExtractName].Properties[Value];SagittaMapping_Replication /Set Package.Variables[User::in_StartComplete].Properties[Value];Start
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 12:33:21 PM
Error: 2007-07-17 12:34:52.98
Code: 0xC0010018
Source: {BE86A659-AB44-403A-9C89-3524821879E0}
Description: Error loading value "<DTS:PropertyExpression xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:Name="SqlStatementSource">"Select dbo.fnGetLastOpenExtract('" + @[User::in_ExtractName] + "') as eh_ID"</DTS:PropertyExpression>" from node "DTS:PropertyExpression".
End Error
Error: 2007-07-17 12:34:52.98
Code: 0xC0010018
Source: {BE86A659-AB44-403A-9C89-3524821879E0}
Description: Error loading a task. The contact information for the task is "Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails.
End Error
Error: 2007-07-17 12:34:52.98
Code: 0xC0010021
Source:
Description: Element "{1c66489c-2a3f-4c8a-b9e7-0161875427a2}" does not exist in collection "Executables".
End Error
Error: 2007-07-17 12:34:52.98
Code: 0xC0010018
Source:
Description: Error loading value "<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" IDREF="{1c66489c-2a3f-4c8a-b9e7-0161875427a2}" DTS:IsFrom="-1"/>" from node "DTS:Executable".
End Error
Error: 2007-07-17 12:34:52.98
Code: 0xC0010018
Source:
Description: Error loading value "<DTS:PrecedenceConstraint xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Property DTS:Name="Value">0</DTS:Property><DTS:Property DTS:Name="EvalOp">2</DTS:Property><DTS:Property DTS:Name="LogicalAnd">-1</DTS:Property><DTS:Property DTS:Name="Expression"></" from node "DTS:PrecedenceConstraint".
End Error
Could not load package "D:ExtractsGBG_ExtractSSISImport_ExtractStartComplete_03.dtsx" because of error 0xC0010014.
Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.
Source:
Started: 12:33:21 PM
Finished: 12:34:53 PM
Elapsed: 91.938 seconds
View 7 Replies
View Related
Jan 2, 2007
Hi Guys,
I
have a flat file which is loaded into the database on a daily basis.
The file contains rows of strings which I load into a table,
specifically to a column of length 8000.
The string has a length of 690, but the format is like 'xxxxxx xx xx..'
and so on, where 'xxxx' represents data. So there are spaces, etc present in the middle.
Previously
I used SQL 2000 DTS to load the files in, and it was just a Column
Transformation with the Col001 from the text file loading straight to
my table column. After the load, if I select len(col) it gives me 750
for all rows.
Once I started to migrate this to SSIS, I
allocated the Control Flow Task and specified the flat file source and
the oledb destination, and gave the output column a type of String and
output column width of 8000. But when I run the data flow task it
copies only 181 or 231 characters out of the 750 required.
I feel it stops where it finds the SPACES and skips the rest.
I
specified row delimiters or CR, and LF. I checked the file under
UltraEdit and there were no special characters in the file that would
cause the problem.
Any suggestions how I can get it to load the full data?
Thanks
View 26 Replies
View Related
Aug 5, 2014
I have a simple SSIS package that reads a flat file and copies it into a SQL Server table.
When the flat fiel is on the C drive I have no problem runnign this package from SQL Server Agent, but as soon as I update the path to a network location the package only works when I run it manually, but fails when is executed via the SQL Server agent job.
The error says "cannot open the datafile", while the datafile location is valid.
Is this a kind of limitation of a SQL Server Agent that only local files are allowed to be processed?
View 4 Replies
View Related
Apr 7, 2006
I have developed an SSIS package that includes a Script Task on a 32-bit machine. The PrecompileScriptIntoBinaryCode property is set to True. After I build the package, the .dtsx file includes a <BinaryItem> element for that Task. Package runs fine on the dev machine, both in BIDS and as SQL Server Agent job.
When I deploy the package to a 64-bit server, it runs fine when I execute the package ad hoc from SQL Server Management Studio. However, when I schedule the package for execution as a SQL Server Agent job, the package fails with the message: "the script files failed to load."
I have reviewed posts on this error from late 2005, but the solutions don't work in this case. Specifically:
1. The Precompile property is already set to True.
2. I have already verified that the script was compiled.
Any further suggestions?
View 7 Replies
View Related
Apr 10, 2006
I have developed a SQL Server 2005 Integration Services (SSIS) package that includes a Script Task on a 32-bit machine. The PrecompileScriptIntoBinaryCode property is set to True. After I build the package, the .dtsx file includes a <BinaryItem> element for that Task. Package runs fine on the dev machine, both in BIDS and as SQL Server Agent job.
When I deploy the package to a 64-bit server, it runs fine when I execute the package ad hoc from SQL Server Management Studio. However, when I schedule the package for execution as a SQL Server Agent job, the package fails with the message: "the script files failed to load."
I have reviewed posts on this error from late 2005, but the solutions don't work in this case. Specifically:
1. The Precompile property is already set to True.
2. I have already verified that the script was compiled.
Any further suggestions?
View 1 Replies
View Related
Dec 14, 2007
Hi,
Here I will describe my problem.
1. We are loading large amount of data from database on background thread which is starting on Application_start event in global.aspx.cs file.The data is later cached for subsquent request to improve the performance.
2. Now when we put the application on web farm garden, it is not able to load the application.
3. We are sending the request the servers through Router kind of application.
4 This application is working fine on single server enviornment.
Please help us.
Ajay Kumar Dwivedi
View 1 Replies
View Related
Apr 27, 2007
I just have done the SSIS example in the tutorial document included when install SQL 2005 ENT. I have a problem that whenever I test to run, the service load all data from source with out noticing about the data (I mean it load all the data to the destination), I do it several time and it continue to load all without checking. That mean the data is dublicated when the schedule run???
I think there should be a paramete or something like that to help the engine just load the new data to the destination. Could you help please?
Thank
View 3 Replies
View Related
Jun 11, 2007
I did a small package with only one ODBC connection (Merant 3.70 32-Bit Progess). This package runs well in Visual Studio and fails when runs by SQL Server Agent.
Configuration:
SQL Server Agent on a 32Bit server.
The ODBC connection configuration in available on System DSN on this server.
The user of Server Agent have full access (Admin).
Connect Manager Provider: ".Net ProvidersOdbc Data Provider"
SQL Server version: 9.0.3042
Error Message:
Executed as user: TEKCON cadmin. ...ion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 16:50:33 Error: 2007-06-11 16:50:33.62 Code: 0xC0047062 Source: Data Flow Task DataReader Source [1] Description: System.Data.Odbc.OdbcException: ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented. ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented. ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcCon... The package execution fa... The step failed.
I created a .bat file with this instruction and It's run well:
dtexec /f "C:Program FilesMicrosoft SQL Server90DTSPackagesIntegration Services Project estcom.dtsx"
pause
Why it's not running with SQL Server Agent???
View 7 Replies
View Related
May 19, 2006
Hello,
I have a big problem and i'm not able to find any hint on the Network.
I have a window2000 pc, VS2005,II5 and SQLServer 2005(dev edition)
I created an SSIS Package (query to DB and the result is loaded into an Excel file) that works fine.
I imported the dtsx file inside my "Stored Packages".
I would like to load and run the package programmatically on a Remote Scenario using the web services.
I created a solution with web service and web page that invoke the web service.
When my code execute:
Microsoft.SqlServer.Dts.Runtime.Application.LoadFromDtsServer(packagePath, ".", Nothing)
I got the Error:
Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.
The error message doesn't help so much and there is nothing on the www to give me and advice....
Is it a SSIS problem???
Thank you for any help!!
Marina B.
View 10 Replies
View Related
May 8, 2008
We are trying to install the Standard Edition of SQL Server 2005. We already have SQL Express installed. Standard won't install and Express won't uninstall.
We have tried every suggestion we can find and some we made up. When we try to install Standard, we get to the bit where you choose what you want to install and the only thing available is workstation components.
There are so many cases of this on the Internat that I can't believe MS have not solved the issue. And I am stunned that they want to charge us more money to talk to us about how to fix something we just paid them an arm and a leg for!
What do I need to tell you to get some idea of where to go next with this?
View 11 Replies
View Related
Mar 7, 2007
Hi there.
I have an assembly, call it A1, that I've deployed to a SQL Server 2005 database. I can use the managed stored procedures from A1 in SQL Server no problem.
In A1 there is a bit of code which uses the Assembly.Load() method, so load another assembly and use instances of class found in that external assembly. However, when I run the managed stored proc in A1 that uses Assembly.Load() I get the error:
Could not load file or assembly 'A1, Version=1.0.0.0, Culture=neutral,PublicKeyToken='????' or one of its dependencies. The system cannot find the file specified.
(note: for security I've changed some of the above line).
So I changed the Assembly.Load() to use
System.Data,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b77a5c561934e089
I re-built the project, re-deployed it and ran the code in SQL Server - it worked. I could create an instance of a System.Data.DataSet for example. So why can't I load my own custom assembly? My assembly does have a strong name and it's installed in the GAC. I wrote a console app to try and Assembly.Load() my custom assembly and that worked fine (it was also running on the same server as the SQL Server).
So it's defiantely the SQL Server that can't 'see' my customer assembly. What do I need to do this assembly so that SQL Server will allow me to Assembly.Load it, just as it can with System.Data?
Thanks
Jas.
View 1 Replies
View Related
Feb 26, 2004
New to SQL Server :(
load a txt file to SQL
there is a field, data type is numeric (13,6).
But in the file, it is like this: 9999999999999
How do I add the decimal points to make it: 9999999.999999????
Thanks a lot
View 1 Replies
View Related
Apr 24, 2008
I want read,validate based on the xsd and load
the xml files from a location.
Please suggest i am new to SSIS..
Thanks for your help in advance...
View 1 Replies
View Related
Sep 29, 2007
Hi,
Any way to read/load only the first row of a flat or excel file?
View 3 Replies
View Related
Nov 7, 2007
I would like to generate a unique ID ( int) everytime a ETL job run and insert that Id to a table called Audit..
how can i do this in a SSIS package?
View 4 Replies
View Related
Aug 31, 2007
Hi allHave you ever used [Web assistant Wizard] in Sql server to create a web page from a predefined [Select] statement or Stored procedure??when i want to do so and when i complete the Wizard i encounter with the following Error message :
---------------------------Microsoft SQL-DMO (ODBC SQLState: 42000)---------------------------Error 22272: Cannot load the DLL xpweb70.dll, or one of the DLLs it references. Reason: 126(error not found).---------------------------OK ---------------------------
Could anyone help me please?Kind Regards.
View 1 Replies
View Related
Feb 27, 2006
Hello,
How is load balancing working in SQL Server 2000. We want to have two different servers as a back end for our web based eCommerce application. Is this possible? While there be any modification requirement in the application?
View 4 Replies
View Related
Apr 12, 2001
Hello Folks,
Appreciate if somebody take out a moment and help me here. I'm having a production database backing up every night at 10:00PM. I've one more development server sitting side by and want this development server to load the production backup copy every night. But the problem what I'm encoutering is, When there are users connected to my development server, It wont get load saying "Database is in Use".
Therefore is there a command, I kill all users at one short and have a task which will load the database? If so, Please let me know how to do this.
Thank you very much
Steve
View 3 Replies
View Related
Jun 20, 2001
Hi!
We make complete data load once a week. Now we need to make additional steps to append data on daily basis. We have primary key on the table and it doesn't allow appending duplicate rows.
What steps should we create to append data?
Thank you,
Elena.
View 2 Replies
View Related
Nov 6, 2000
What is the meaning of Loadbalancing and how can I use this term to my advantage.
Q2. How would I know that I need to do load balancing and how can I set it up.
I have wrote load balancing in BOL and did not get any thing on it. can anyone refer me to where I can read more about it.
thanks
Ahmed
View 1 Replies
View Related
Dec 14, 1999
Hi All,
We have a Intranet Application which uses IIS / SQL Server 7.0, we are trying to support the application for 30,000 + users.
Since SQL Server can only support upto 32676 user connections (Theoretically), is it possible achieve this with clustering / dynamic load balancing. Does MSCS and SQL 7.0 support this. Any other ideas, 3rd party software etc?????
Any input will be of great help.
Thanks
NK
View 1 Replies
View Related
Mar 12, 2001
Hi Everyone,
I'm trying to load data from one server to another every night by creating a dts package and then scheduling the same at night for some reason its failing and i have no clue why is it happening here is the error what it gives me:
DTSRun: Loading... Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713 Error: -2147467259 (80004005); Provider Error: 11 (B) Error string: [DBMSSOCN]General network error. Check your network documentation. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.
Could any one tell me what's goin on and how to solve this i will be very greatful for you.
And another thing is when i created this package and ran at that time or any other time without scheduling them its working good with successful results.
Thanks in advance..
Murthy
View 1 Replies
View Related
Oct 23, 1999
Hi everobody!
When I run :
LOAD DATABASE db1
FROM DISK = 'c:mssqldatadb1_backup.dat'
go
I got error message:
Msg 3201, Level 16, State 1
Can't open dump device 'c:mssqldatadb1_backup.dat', device error or device off line. Please consult the SQL Server error log for more details.
How can I fix the problem?
Thank you.
Alona
View 1 Replies
View Related
Aug 21, 2003
Hi,
is it possible load csv file from web
located at www...
to db using dts ?.
Thank you
alex
View 1 Replies
View Related
Apr 9, 1999
Hi,
does anybody know how to restore transaction log dumps (several dumps in one dump device) with TSQL statements ?
I tried "Load transaction devicename"
this fires an error message which complains that i have to use right sequence.
How do i tell the load command which sequence it shall use ?
You can use "load headeronly" command which gives you all entrys from the dumpdevice. How can i use this information ?
Thanks
Yorn
View 1 Replies
View Related
Nov 5, 2001
We have setup SQL Server 2000 with a VB application. I want to stress test the application / server by stimulating 400+ users. Is there any tool or utility available to do so?
Thanks in advance,
jfk
View 1 Replies
View Related
