Urgent HELP ME¡¡¡¡¡¡ Some one
-
clperez271172 (1/27/2009)
, I have a hardship because now I need to know where is the last functional execution of my DTS in my system, but, this I execute myself via batch and not by JOBS, so where it is the information of completes execution?As I said, I don't think it is written anywhere unless there's some custom logging done inside the DTS package. I'm sorry if that's not the answer you want.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
The first thing you have to do is to open up your DTS packages and look at its properties. Go to the "Logging" tab to see what logging option(s) was set up. if logging was set up then that tab should tell you where the information is kept. If logging was not set up then there's a good chance the information you're looking for is not available.
Alvin Ramard
Memphis PASS Chapter[/url]All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
-
Gail's right. DTS does not log by default, either to SQL Server or to a file. Logging must be enabled in the package.
He's trying to figure out when a DTS package was last run, so he can figure out a migration/upgrade path for it. He has no logging, and it's not being run through SQL Agent, and no server trace. I don't think the data he needs exists in that case, but I could be wrong.
clperez271172, if the above is true, you will not be able to see when the package last executed. You should do the following to enable logging:
1. Open the package in DTS Designer
2. Right-click in open space and click on the "Logging" tab
3. Check "Log package execution to SQL Server" and specify the server where the package resides
4. Click OK
5. Save the package and exit
The next time the package executes it will log to msdb.dbo.sysdtspackagelog. You can either query the table or right-click on the package in Enterprise Manager and select "Package Logs..."
Greg
-
but as I obtain data of the previous executions cuendo this option was not qualified and it says the BSA to me that if there is a way to remove this infomacion, but I have looked for by several means and not with himself nothing, for that reason I request aid
Please help me¡¡¡¡¡
-
How, exactly, did you execute the DTS package?
With DTSRUN command? Please provide the command (without security parameters, of course).
-
exec master..xp_cmdshell 'type d:\datasql\mssql8\logDTSCentralizado.txt'
THIS IS THE LINE OF TRANSACT-SQL .
BUT WHERE IS THE LOG FROM ERROR OR FROM SUCCESSFULL RUN AND NEED YOU HELP FROM THE LAST RUN , TNKS
-
Did you open the DTS package and look at the Logging tab? If you did not do that then I do not know why anybody should waste their time trying to help you.
Alvin Ramard
Memphis PASS Chapter[/url]All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
-
People are trying to help you, unfortunately you don't seem to help them. You have been asked questions, and given some suggestions, yet I have yet to see any responses to those.
-
Hi...!
I need to know the last time a DTS package was executed, but this DTS do not
belong to any Job. This DTS is always executed manually, by an external
application .... never by a SQL Server Job.
I have SQL Server 2000
i having trouble understanding some of the answers there, add a post to clarify.
please
Tnks everyone for cooperation
-
Please post the contents of logDTSCentralizado.txt
-
following up on Alvin's question, which is important...what happens when you go to the spot below...what do you see?
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
He is executing a .txt file
When you create a DTS package, you can either save it to the Server, save it to a Visual Basic File (.bas) or a Structured Storage File (.dts)
These can be executed from the command line, but since he is executing a .txt file, I suspect it has other command-line statements that execute something (a .dts file? a DTSRUN stmt?).
Who knows. That's why I want to the the contents of the .txt file.
He may not even know what package is being executed, or on what server.
-
THE PROBLEM IS NOT THAT FILE YOU EXECUTE, THE QUESTION IS WHERE IT KEEPS COMPLETES EXECUTION, IF IT BEAMS BY APPLICATION OR LINE OF COMMANDO, I HAVE REVIEWED THE LOG OF SYSDTSPACKAGESLOG AND THERE I DO NOT HAVE ANYTHING, AND IN THE SYSJOBS I DO NOT HAVE THIS INFORMATION IS WHY EITHER I WANT TO KNOW WHERE THIS KEEPS.
SO THAT THE TEXT FILE IS REQUIRED?
IT BELIEVES IN MY IS NO DOUBT THAT IT IS POSSIBLE TO BE RUN BY LINE OF COMMANDO, THE QUESTION IS THAT SQL SERVER WHERE IT KEEPS I DO NOT COMPLETE DATA OF THIS EXECUTION, AND THAT SINCE IT COMMENTS I HAVE REVIEWED THE TABLES OF THE SYSTEM
-
clperez271172 (1/28/2009)
THE PROBLEM IS NOT THAT FILE YOU EXECUTE, THE QUESTION IS WHERE IT KEEPS COMPLETES EXECUTION, IF IT BEAMS BY APPLICATION OR LINE OF COMMANDO, I HAVE REVIEWED THE LOG OF SYSDTSPACKAGESLOG AND THERE I DO NOT HAVE ANYTHING, AND IN THE SYSJOBS I DO NOT HAVE THIS INFORMATION IS WHY EITHER I WANT TO KNOW WHERE THIS KEEPS.SO THAT THE TEXT FILE IS REQUIRED?
IT BELIEVES IN MY IS NO DOUBT THAT IT IS POSSIBLE TO BE RUN BY LINE OF COMMANDO, THE QUESTION IS THAT SQL SERVER WHERE IT KEEPS I DO NOT COMPLETE DATA OF THIS EXECUTION, AND THAT SINCE IT COMMENTS I HAVE REVIEWED THE TABLES OF THE SYSTEM
I'm sorry, but there is no need to yell at us. We are trying to help you, but you aren't helping us to do that. We don't have access to your systems, so we can't look at things directly, that is why we are asking you questions. Try answering the questions, and you may be surprised that you may start getting answers to your questions.
-
This is getting old.
clperez, can you open the DTS package in DTS Designer?
Greg
Viewing 15 posts - 16 through 30 (of 66 total)
You must be logged in to reply to this topic. Login to reply