I concur w/ Andoi about the Web Assistant Wizard - give it a try (in EM, wizards under Management). Without knowing any html, the wizard will walk you thru...

I finally got back to this project and made some modifications: added cents and added hyphens where approriate.

 CREATE FUNCTION fn$_to_Dollars

(@Cash float)

 

RETURNS varchar(100)

AS

BEGIN

-- a5xo3z1...

Excellent!

Thank you.

Bill.

Edited by - billnye101 on 08/14/2003 3:23:26 PM

In case you ever do need to open a web page from DTS using ActiveX task:

Set WshShell = CreateObject("WScript.Shell")

strRunfile = "http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=14639 &FORUM_ID=19&CAT_ID=3&Forum_Title=Data+Transformation+Services+%28DTS%29&Topic_Title=Open+an+ASP+Page+from+a+DTS"

WshShell.Run strRunfile

Set WshShell = nothing

Of course, maybe if...

Yes, you can truncate log in EM:

Right click the database name, select "All Tasks", then "Shrink Database". Click the "Files" button and select the log file name. ...

If you have SS2k SP3, you may need to get the hotfix from MS.

See MS Knowledge Base Article 814113.

(Note: there is no charge for the tech support call, if this...

Problem solved after reading ghicks1's post re:MS Knowledge Base Article 814113.

Downloaded/installed the fix and now it works.

Sounds like you have delimiters embedded in your data or maybe text going into number fields, etc. I periodically receive some third party data that includes quotes, commas, and...

If security is not so much of an issue, you can put the dtsrun command line into a .bat file and schedule that with the Windows scheduler. (I think...

Here's how I run a DTS pkg from an Access event:

Open Notepad and type in the DTSRun command line, i.e.

dtsrun.exe /S SrvrName\SrvrInstance /E /N DTS_pkg_Name

Then save as, for example, c:\DTS.bat.

Finally...

See BOL - SendMailTask object, then click on example.

I haven't tried it yet. Your post got me thinking about this, so I started looking for a way. It's...

Yes, you'd think there'd be a simple function, but I didn't see one either.

However, you could use a DTS transformation task such as this:

'********************************************

' Visual Basic Transformation Script

'********************************************

Function Main()

If...

About a month ago I started receiving 3624 errors. I finally discovered that I had a bad sectors on my hard drive by running chkdsk. After replacing the...

I ran across something that made me think of your corruption issue. From SQL Server 2000 System Administration - Microsoft Press:

(paraphrased to shorten) "Beware of write caching disk...

I ran across something that made me think of your corruption issue. From SQL Server 2000 System Administration - Microsoft Press:

(paraphrased to shorten) "Beware of write caching disk...