I'm trying to use the below command to execute for generating the log file for SSIS package.
DTExec /FILE "C:Documents and SettingsCP0808My DocumentsTest.dtsx" /logger "DTS.LogProviderTextFile;c:log.txt"
But it got the error as below. Please advise.
Started: 10:03:20 AM
Error: 2006-10-06 10:03:21.15
Code: 0xC001000E
Source: Test
Description: The connection "c:log.txt" is not found. This error is thrown b
y Connections collection when the specific connection element is not found.
End Error
Error: 2006-10-06 10:03:21.18
Code: 0xC001000E
Source: Test
Description: The connection "c:log.txt" is not found. This error is thrown b
y Connections collection when the specific connection element is not found.
End Error
Error: 2006-10-06 10:03:21.21
Code: 0xC02020EA
Source: Test Log provider "{1AEAB490-1124-4A84-981F-7C1FDD80A721}"
Description: The connection manager "c:log.txt" is not found. A component fa
iled to find the connection manager in the Connections collection.
End Error
Error: 2006-10-10 09:57:21.07 Code: 0xC001000E Source: Test Description: The connection "log.txt" is not found. This error is thrown by C onnections collection when the specific connection element is not found. End Error Error: 2006-10-10 09:57:21.10 Code: 0xC001000E Source: Test Description: The connection "log.txt" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error Warning: 2006-10-10 09:57:21.14 Code: 0x8001F02F Source: Test Description: Cannot resolve a package path to an object in the package ".Connections[log.txt].Properties[ConnectionString]". Verify that the package path is valid. End Warning Warning: 2006-10-10 09:57:21.17 Code: 0x80012017 Source: Test Description: The package path referenced an object that cannot be found: "package.Connections[log.txt].Properties[ConnectionString]". This occurs when an attempt is made to resolve a package path to an object that cannot be found. End Warning DTExec: Could not set package.Connections[log.txt].Properties[ConnectionString] value to c:log.txt.
I'm using the following command to schedule an export data job. Now I would like to know how to use the option "/logger" getting a log file for verification.
I am testing a set of SSIS packages, In order to test my SSIS packages for errors I have two negative test cases
1) I didn't provide checkpoint file for the checkpoint enabled package.
2) I provide a wrong configuration file
Even though I am using a script task in my "on error" event of my SSIS package. It is not executed. (Perhaps because the package doesn't even execute).
My problem is that SSIS itself puts just a simple one liner in windows event log "Package Failure Error". It does not provide which package failed, why it failed etc. Therefore the admin who gets the ticket to resolve the issue has no clue of what is going wrong and where!
Since my custom logger doesn't even run, I don't know how can I put more details into the windows event log.
Hi everyone In my SqlServer Management Studio Express, on start up it shows the server type option, but greyed.So that value is fixed to database engine. ( I'm trying to work on an SqlServer Compact Edition database through the SSMStudiothat's why I'm trying to get this to change.)Besides, after I connect i go to the Object Explorer, expand the server node, and go to Replication.When i expand replication, i get the "Local Subscription" option, but nothng for Publication.( I want to work on Merge Replication, that's why I desparately need Publication to work)Am i missing something here? I did not install SqlServer separately, I only have what comes bundled with the Visual Studio 2005 Setup.
So I started a new job recently and have noticed a few strange configurations. Typically I would never mess with min memory per query option and index create memory option configuration because i just haven't seen any need to. My typical thought is that if it isn't broke... They have been modified on every single server in my environment.
From Books Online: • This option is an advanced option and should be changed only by an experienced database administrator or certified SQL Server technician. • The index create memory option is self-configuring and usually works without requiring adjustment. However, if you experience difficulties creating indexes, consider increasing the value of this option from its run value.
I have a table name “StringResources� which contains resources for different cultures. Right now, whenever admin adds any new resource, it immediately available to end user. Now the new requirement came up. We want admin to add resource first and when he is ready with all the resources for particular culture then only the resources should be available to end user. Important: StringResource table has SQLCacheDependecy set. So any change for particular culture will invalidate the cache. This how the select statement looks.SELECT dbo.StringResources.resourceType, dbo.StringResources.cultureCode, dbo.StringResources.resourceKey, dbo.StringResources.resourceValue FROM dbo.StringResources WHERE dbo.StringResources.cultureCode=@cultureCode Which would be the best option below: 1> Add new Boolean column “Published� and show only resources which are published to end user. Advantage: No need of extra table. Disadvantage: This will invalidate the cache every time resource is added even if it’s not published. Other option 2> Add new temporary table with same structure. When admin add new resource, add it to this temp table and when publish move resources to String Resources table. Advantage: Admin will have separate working space. It will invalidate cache only when resources are published. Disadvantage: Need extra table.
How can I get an All option into the cascading prompt? I want to view data for all states in USA. I find I can't proceed to load report unless I have filled in a value for all prompts. Any help?
I have a small doubt. If we enable AWE option we can have advantage of available physical memory.we can have more memory by using max server memory property. then why this AWE option comes in to picture.
I read bol but iam not able to understand what exactly happens.
Could any one tell me why this AWE option if we have max server memory property.
Hi, What is equivalent to OPTION (RECOMPILE) in SQl Server 2000. Create table #Employee ( EmpId int IDENTITY,EmpName varchar(30) ) insert into #Employee(EmpName ) select EmpName from AllEmployees OPTION (RECOMPILE)
I have a vacation request app I'm designing, and it has a VacationData Table with TotalVac, UsedVac, VacLeft, VacationCarriedOver, and VacCompleted. I need to take the VacLeft and divide by 2 and place that data in the following two spots, one in the VCO and add it to the TotalVac, which is pulled from another table w/hire date and other info. I only need to run this on Jan 1 of every year, any suggestions?
I am trying to alter a table that has an identity field to make the column have the not for replication option. I just can't seem to get the syntax down for the alter table command. PLEASE HELP. I know it can't be that hard!!!
70-229 certification exam measures your ability to design and implement database solutions by using Microsoft SQL Server 2000 Enterprise Edition. Candidates for this exam work in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition. Candidates have at least one year of experience implementing relational databases. I don't have experience on database. Haven't experience on SQL server administration. Suggest me good one resources in low price. What are best option available in market?
First off, I apologize for not knowing what I'm talking about and being long winded. I'm trying to determine if SQL Server Express is an option for a client of mine. Their needs are beginning to go beyond what I'm comfortable with in Access, so I'm looking into the option of upgrading to a SQL Server Express back-end with a VB front-end.
Access doesn't require any setup beyond "File, new", so I know nothing about the background work required to get a database running on a platform like SQL Server.
My first concern is what kind of network admin rights do I need to install & use SSE..
It's unlikely that her IT group will just hand us the keys to any of their servers, so all we really have available is what we can put on her network drives. Am I right in assuming that using a SQL Server database would involve more network privileges than just dropping a file on the network and pointing my front end app at it?
With that said, I think I remember seeing something on one of the MSDN pages about setting up a database to run off of a CD-Rom. Could I somehow use this capability to get what I need?
I would like to add a couple more fields that the users can query by, more options how would I add in the same stored proecedure, First Name, Date, and IR#?? so they can have the ability to run it by one field or two fields or all the above?? how would I incorporate those in the stored procedure??
CREATE PROCEDURE [SearchByDateExcls] (@StartDate datetime, @EndDate datetime) AS SELECT [IR Number], Date, Inspector, Violation, [Violation Type], Loss, [Loss Type] FROM dbo.Revised_MainTable GROUP BY [IR Number], Date, Inspector, Violation, [Violation Type], Loss, [Loss Type] HAVING (Date BETWEEN @StartDate AND @EndDate)
is this correct
CREATE PROCEDURE [SearchByDateExcls] (@StartDateServed datetime, @EndDateServed datetime, @Enter_LastName nvarchar(25), @Enter_Duration nvarchar(10)) AS SELECT IR#, [Date Served], [Reason For Exclusion], Duration, [First Name], [Last Name] FROM [dbo].[Extended Exclusions] GROUP BY IR#, [Date Served], [Reason For Exclusion] , Duration, [First Name], [Last Name] HAVING (Date BETWEEN @StartDateServed AND @EndDateServed, Enter_LastName, @Enter_Duration)
I was sreading about NOLOCK that it could prevent deadlocks but could return data which is not committed yet. 1) Should we use NOLOCK with select statements 2) If the transaction isolation level is set appropriately (e.g. Serializable)in the component (for e.g COM+ component) but NOLOCK is specified in the select then would it return uncommitted data. I mean if the transaction is controlled at hihger level then what will be the Pros and Cons of using NOLOCK.
I am selecting few records from a particular table and however I need to run the same query using UNION.But its taking long to execute the query.If I run the query as 2 parts then it works fine but if I put in UNION to both queries then I have problem.Can anyone help?
eg:
Select '' as name,'' as userid,'' as firstname from table1 where user like 'A%'(works fine)
Select name,userid,firstname from table1 where user like 'A%'(also works fine)
but if I user
Select '' as name,'' as userid,'' as firstname from table1 where user like 'A%' UNION Select name,userid,firstname from table1 where user like 'A%'
Hi Everyone,I tried to bcp in the data file to a table in sqlserver 2000.The data file has got few blanks in certain columns.My requirement is all those blanks has to be converted null while bcpin the data.1. I have tried giving the option -k - Didn't work2. I have tried creating a format file with prefix length 2 i.e as thecolumn is character.3. Initially it was giving string data truncation error due to theservice pack3. Then I updated the service pack 3 also.Pls someone help me out as this is very critical.Thanks,Ganesh
I need to check if any user in the database is assigned any permissionWITH GRANT OPTION. Please let me know how do I check this. Also let meknow if assigning rights WITH GRANT OPTION is possible from enterprisemanager.Thanks in advanceKamal
I am not a company programmer but I do like to write programs for myself. I am currently looking at writing a Database program to track my DVD's, CD's Tapes and the likes (as well as quite a bit of other data). While discussing this with others it was suggested that I use MSDE (since it's free) and that way I could learn more about SQL databases at the same time.
When I connected to the MS website to download MSDE I found that it will not be supported with Vista. Since I am planning on getting a new PC which will most likley come with Vista I am now wondering what would be the best way to develop my database.
1. Should I use Access (Since it will only be accessed across my home network)?
2. Is there a version of SQL (that does not require a License fee) for Home use?
I am trying to load data from sql server to sybase. SQL Server is our source databse and I want to do this task in unix server using isql and bcp options.
I want to limit the changes on source tables and also I cannot use DTS or SSIS since we dont own SQL server.
Does any have any idea how to use query option in bcp. It is not direct table load. I need to run select statements with Joins in it.
Any ideas on how to script run and save results in to file and then bcp in to our sybase server.
I am not suposed to craete any views on source db. So just need to run sql statements and take the results to text file.
What can be the implications of enabling CLR option; especially in a shared hosting environment? What are security considerations? And what should a database administrator be aware of?
Pointers to relevant information will be highly appreciated.
i want to setup my database to new server machine. i have backup as well as copy of database files (data & log), but i lost my master database from existing server.
so i have 2 ways of having my database
1. restore from backup
2. attach the data files.
which one is best option, when we start afresh on new machine with new master database.
How do I set the FOR_XML_NULL_TREATMENT-Option of my database?? I don't find any hint in google that shows me how to set it... at least I know that it exists.
Hi there,I'm looking for advices from people with more experience using SQL Server. I have a situation where from my perspective i have 3 ways to accomplish my task, but i dont know which way would be more efficient and performant.Here's the deal, i have a table which holds millions of records. This table will eventually receives between 30-40 insertion a second. So it's pretty busy. To display the data correctly in reports over the web, i need to manipulate the data in such a way that certain transaction are modified and others are completly eliminated depending on a set of preferences choosen at the moment of the request for the report. Obviously i dont see any ways to do this with just one SQL query, so my choices are the following:1. Create a second table, which would hold the manipulated data. Create a trigger and on each insertion manipulate the data and modify the second table.2. Create a stored procedure, from the stored procedure i query my records, create a temp table, manipulate my data and return it to the user3. Simply fetch the data, return it to the IIS server and process it there before returning the result to the client.The manipulation process consists of querying about 1000 to 2000 records, eliminating duplicate results (or similar results within a chosen range) by comparing them to the last one, and to indicate for each record how many other records were similar. In other words, it's a basic loop and i compare each record to the last one to see if it changed.Personally i think choice #2 would be better, but i could be wrong. I'd like to hear your comments and suggestions.Thanks,
I had a DTS task running which was doing an insert (over 17.5 million rows) in a database for which the auto shrink option was enabled.
After a few hours I noticed that the insert was blocking the autoshrink.
Since I didn't want to kill my insert, I tried to kill the autoshrink from the query analyzer, but when trying to do so I got the message that only user processes can be killed.
Does anyone have similar experiences? Should you consider enabling the autoshrink option or is this just trouble?
