My server was setup to use another Domain account.  If yours is already setup to use the Local System Account you would not be expiriencing the same problem I was...

I too had this problem once before.  Eventually after working with MS support for 3 weeks and having them change the SQLRun01.MSI for me I was able to get an...

This is somewhat of a Hack of an answer, but if the problem is NULLs in the last Field, How about in your select statement, Adding and extra column that...

My initial question would be why do you need TblBalance?  When you need to show the balance in your application why not calculate it on the fly?  SELECT SUM(dramt) -...

I think if you look hard enough you can find this in the registry...

try HKLM\Software\Microsoft\Windows\CurrentVersion\Installer\UserDate\S-1-5-18\Products\

One of these should be the install for your service pack.  Look in the InstallProperties\InstallDate Key. ...

Dan, I think what you need is a ActiveX Script Task added in the workflow before your DTS transformation.  Use can use a vbCrLf as a line feed or vbFormFeed...

I have to agree with the comments ont he price of the conference.  Being a DBA on the east coast and trying to figure a way to get my employer...

I suppose you could make the change in the services applet and follwo these instructions how to fix the security issues that crop up when you do that...

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811

Did you restart the SQL service?  The changes won't take affect until you do.

when you changed domains, did you change the Use that the SQL Service runs as?  If so it may not have the correct rights...  There are soem specific ones needed...

Also with CFEXECUTE I beleive your error is being caused by not specifying the entire path to your executable...

instead of

<cfexecute name="dtsrun"

arguments ="/s SQL01 /U ColdFusionUser /P ColdFusionUser's Password /N mypackagename">

</cfexecute>

TRY

<cfexecute...

Earlier in this thread people were talkign about account permissions to the file/network location you are trying to use in your DTS task...

Excerpted from BOL...

When xp_cmdshell is invoked by a...

Also, you said you're calling this from a CF script and that's why you need to use a Sproc...

Why not use CFExecute instead of xp_Cmdshell? http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/Tags-pt126.htm

It should get you...

And you can do a simple select from one of your tables from a CF webpage like this...

<cfquery name="myqry" datasource="whatever" etc...>

      Select Col1 from Table1

</cfquery>

<cfoutput query="myqry">

      #col1#<br>

</cfoutput>

Or will it...

Every Time I've looked SA just hasn't made sense.  Even when they overhauled it in 02-03 it still didn't make sense.  They kept telling us to sell it with WinXP...