January 26, 2009 at 2:05 pm
[font="Comic Sans MS"]Please some very , i need help, i have a trouble because i need now where is the last run my DTS into my system , but , i run from Batch not from JOBS , so where is the information to last run sucessfull??
Because into sysdtspackageslog i not have nothing , i need , output the infotmation , please help me ¡¡¡¡¡¡¡[/font]
January 26, 2009 at 2:36 pm
Just a hint: Posting in really big letters just makes your post harder to read. It doesn't actually make anyone answer faster.
When you say you ran it from a batch, do you mean from a command-line?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 26, 2009 at 3:04 pm
yes , i send my DTS from aplication or but command line , i need now where is the information to last run form my DTS i see the sysdtspakageslog , but no´t have information a but this , and need now where is this information , and need the information from Transact-SQL please help me i need seen this information from my BSA urgent, tnks for help.
Regards
January 26, 2009 at 3:11 pm
I don't think it directly creates a log entry or anything like that when you do that.
Do you have a trace or anything running on your server that might have a history of the commands?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 26, 2009 at 3:39 pm
No, in fact what it interests to me it is knowledge where the information keeps from these DTS, when they are executed by batch, this is for making the decision from as to migrate and as no
:unsure:
🙁
:sick:
January 26, 2009 at 3:44 pm
that exist a form to remove to the information from when run for the last time this DTS, that one is what in fact I need, this is for making the decision from as to migrate or as no?
🙁
:sick:
January 26, 2009 at 5:11 pm
A DTS package will only log execution messages in sysdtspackagelog if you've enabled logging in the package itself. If there's no data in sysdtspackage log, it's probably because you didn't check that option in the package properties.
I don't know of any other way to see when a package ran unless the package does something that would be logged in the SQL Server log.
Greg
January 26, 2009 at 5:33 pm
THAT IS NO THAT THERE IS ANOTHER WAY TO CONSULT COMPLETES TIME THAT I AM USED THIS DTS, IN IF THAT IS THE DATA THAT I NEED, SINCE ON THE BASIS OF THIS THE DECISION WAS TAKEN TO MIGRATE OR NOT THIS DTS
PLEASE HELP , IS URGENT , I REALY HAVE TROUBLES.
TNKS FOR THE COOPERATION
January 26, 2009 at 11:55 pm
clperez271172 (1/26/2009)
PLEASE HELP , IS URGENT , I REALY HAVE TROUBLES.
Please don't shout (type in all caps). It's not going to make someone help you faster. If I may suggest, go back and edit your first post and make the font readable (standard size) and edit the above one and fix the caps. Right now you're not helping people help you.
While you're at it, can you explain the background and the exact problem in more detail. I'm not sure what you actually need.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 7:03 am
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 27, 2009 at 7:15 am
GSquared (1/27/2009)
I don't think the data he needs exists in that case, but I could be wrong.
I don't think so either. If it was run through SQL agent, in any way (OS command to batch file), then the job history can be used. If it's a batch file that someone logs onto the server and kicks off, then there won't be any history unless the package has been set to log it.
I'm not an expert on DTS, and I haven't used it in a while, but I don't recall it having an automatic execution log.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 9:35 am
I thought you could configure flat file logs, but I'm not sure how "queryable" they would be with OPENQUERY.
January 27, 2009 at 9:47 am
Steve Jones - Editor (1/27/2009)
I thought you could configure flat file logs, but I'm not sure how "queryable" they would be with OPENQUERY.
I'm pretty sure that logs can be configured, but I don't think they're done by default.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2009 at 10:01 am
I need to be able to consult the information of completes time that I execute the DTS and where it is kept this information, since in the tables of the system this information does not exist, with this I talk about to that it reviews syspackagelogs and other referring tables to the DTS for that reason is that I request aid to know how where to obtain this data, that this keeps in some place, but not where :sick:
January 27, 2009 at 10:07 am
Please somebody, I need aid, 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? Because in sysdtspackageslog not to have anything, I need, to make leave the information, ayúdeme please
Viewing 15 posts - 1 through 15 (of 66 total)
You must be logged in to reply to this topic. Login to reply