analytics

Technical Article

DTS error executing from Stored Procedure

  • Topic

When I call my DTS package from a stored procedure by: exec master.dbo.xp_cmdshell 'dtsrun /S ntserver5 /U username /P password /N "New Package"' I get the following error: Error string: The Microsoft Jet database engine could not find the object 'jungtran2'. Make sure the object exists and that you spell its name and the path […]

2005-05-24

5 reads

Technical Article

RE: Odd logs

  • Reply

Really bad. It means that once everybody is out of the database it closes itself. Which doesn't seem really bad, but if you have 200 of those on the same server and you open the database list in EM, you won't even be able to enter one of them because they will constantly open/close. It […]

2005-05-20

Technical Article

RE: urgent please

  • Reply

Can you post the table definition, some sample data. And what you are trying to accomlish col1, col2, col3 1,2,3 >>move to tableV 1,2,4 delete if 4,6,9 >>move to tableY

2005-04-28

Technical Article

RE: Update with insert of zero

  • Reply

How about something like this:select CASE PATINDEX( '%[a-Z]%', col1)  WHEN 0 THEN      stuff('000',4-len(col1),len(col1),col1)  ELSE   stuff('000',4-PATINDEX( '%[a-Z]%', col1)+1,len(col1),col1)  END from test1Where test1 is the table in question and col1 is the column you are working on. 

You rated this post out of 5. Change rating

2004-10-06

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

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