[dba-SQLServer] Scheduling DTSX packages in SQL Server 2005

Eric Barro ebarro at verizon.net
Tue Jun 12 10:48:53 CDT 2007


Check show details to see why it's failing. You're just skimming the surface
when you view job history. 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
Elizabeth.J.Doering at wellsfargo.com
Sent: Tuesday, June 12, 2007 8:33 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Scheduling DTSX packages in SQL Server 2005

Dear List,

I have created a perfectly nice dtsx package which moves data from a table
in one database on a server (running SQL Server 2000) to an identical table
on another server running SQL Server 2005. When I save the package to my
desktop and double click on it, it runs perfectly.  

Because it's from 2000 to 2005, I don't have the option to do this in 2000.


When I schedule that package to run every hour, it fails.  On the hour and
when I randomly click on it and "Start Job at Step".  I have done everything
I can think of to make the nasty thing run, but all it reports in History is
"The job failed.  The Job was invoked by User AD-ENT\elizabeth.j.doering.
The last step to run was step 1 (Step1)."
This is beginning to feel rather personal here, like the server gods have it
in for User AD-ENT\elizabeth.j.doering, i.e, me.  

I've done everything I can think of, but that was a short list, mostly
involving rescheduling the package.  I've also torn my hair and jumped up
and down, but those don't seem to help either.  Ideas, anyone?


Thanks, 


Liz 


Liz Doering
elizabeth.j.doering at wellsfargo.com
612.667.2447


This message may contain confidential and/or privileged information. If you
are not the addressee or authorized to receive this for the addressee, you
must not use, copy, disclose, or take any action based on this message or
any information herein. If you have received this message in error, please
advise the sender immediately by reply e-mail and delete this message. Thank
you for your cooperation.

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.472 / Virus Database: 269.8.14/845 - Release Date: 6/12/2007
6:39 AM
 




More information about the dba-SQLServer mailing list