| Author |
Topic |
|
max_fudz2001
Starting Member
8 Posts |
 Posted - 2007-12-12 : 02:52:57
|
| Hi everyone,i've scheduled a few packages of DTS and put a schedule for each of it. My problem is all the packages run not as schedule. For example, in the 1st and 2nd day the DTS run as schedule but when it come 3rd and 4th day it isn't. Then, it will run as schedule on the 5th day. That is the example of scenario. Anyway have any idea? Basic scenario:I want to make an auto-copy data between 2 databases in same SQL server using DTS. The DTS's packages will execute to copy from A database into B database in the specific time. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-12 : 03:34:21
|
What do the logs tell you?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
max_fudz2001
Starting Member
8 Posts |
Posted - 2007-12-12 : 04:33:55
|
| i've checked the packages log. it shows that all the succesful run has been log and i doesn't found any log for the unsuccessful activity. I'm checking the log at Local Packages > DTS Packages Log. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-12 : 04:48:11
|
I mean, is there an entry for every day?Do the log says the run was ok even when you think it is not?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
max_fudz2001
Starting Member
8 Posts |
Posted - 2007-12-12 : 09:04:15
|
| to make it clear, sorry to ask, which log u want me to refer to? there are 2 type of log. One for the activity itself and the other one for the packages (many activity in there..). For the activity, the log say ok overall. For the packages, some tell fail to process and others process success. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-12 : 23:28:14
|
| Did you enable logging in the package? |
|
|
|
max_fudz2001
Starting Member
8 Posts |
Posted - 2007-12-13 : 02:34:47
|
| yup. i've enable log. |
|
|
|
max_fudz2001
Starting Member
8 Posts |
Posted - 2007-12-17 : 20:28:24
|
| i've check the package log. The log state that the status is ok. however, the 'job' status to run the schedule job is fail to run. anybody, plzzz help me.. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-17 : 21:40:27
|
| Any message in job history? |
|
|
|
max_fudz2001
Starting Member
8 Posts |
Posted - 2007-12-17 : 22:24:41
|
| I've set the log. after dts run... below is the log tell me;DTSRun: Loading...Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-17 : 22:33:15
|
| Does the package access remote sql server? Is that server running? |
|
|
|
max_fudz2001
Starting Member
8 Posts |
Posted - 2007-12-18 : 02:38:25
|
| yup. actually the source and destination is on the same server but different db. i've checked the access detail such as password or etc... it's already there. The log from dts is like below:The job failed. The Job was invoked by Schedule 44 (max_test2). The last step to run was step 1 (Extract_DS001 2).the log i take from the management> SQL Server Agent>job |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-18 : 03:37:41
|
Are you building the servername dynamically in the job?Are you running the job at the same time some blocking operation occurs at the source database?Are you really REALLY sure the username AND password match?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
max_fudz2001
Starting Member
8 Posts |
Posted - 2007-12-18 : 03:54:58
|
| what do you mean by this 'building the servername dynamically in the job'??- i'm not sure what it is.. but i've use ip address in dts to determine it's destination and source.fyi, i've set the job with different time. exp: from 1 job to another... 2nd job will execute after 5 min 1st job done. yes i'm really sure the username and password. i'm using the same username and password that was set in dts. actually, it should be same, right?i'm really no idea about this matters. i've try many methods to trace the problem. until now, i don't really know where and what make it stop. Plzzz....help me. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-18 : 22:35:34
|
| Then there should have something in package log, if you really enabled it. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-19 : 06:24:29
|
| You haven't changed the IP Address? |
|
|
|
|
DTS do not run as scheduled...