ASCII

Technical Article

RE: DTS Scheduled Job Failed

  • Reply

1. Error Message is "Failed (7/17/2003) 4:35:58 AM)". In View History: The job failed. The Job was invoked by User 323S\SQLADM. The last step to run was step 1 (Import DB2 EMP_DATA). Note, step 1 is the ONLY step. "Import DB2 EMP_DATA" is the name of the DTS package. 2. SQLAgent is using Win2K AD […]

You rated this post out of 5. Change rating

2003-07-17

Technical Article

RE: Stored procedure using dynamic query

  • Reply

Boy, you guys are brave! I NEVER use dynamic SQL EVER in ANY Production system. It does come in handy for 1-off utilities that I write and use myself. For Queries that return the same result set and the predicate varies (the WHERE Clause) I use a stored procedure that accepts all of the search […]

You rated this post out of 5. Change rating

2003-06-03

Blogs

Simple Talks Episode 7

By

The season 1, seventh episode of Simple Talks is out. Check it out, with...

A New Word: the McFly effect

By

the McFly Effect – n. the phenomenon of observing your parents interact with people...

Key mappings in Visual Studio Code

By

At a recent conference I was asked how I executed code during my presentation....

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers