Viewing 15 posts - 46 through 60 (of 180 total)
Thanks for the response! Pity the underlying KB isn't in place - I get '
if I try to click through
November 10, 2006 at 7:29 am
Have you had any feedback further on this? I've run into this, trying to use sp_send_dbmail for the first time. SP2 went CTP on 6 November - I wonder how...
November 10, 2006 at 6:58 am
Glad to hear that solved your problem. As I recall, it was one of the first suggestions I made, as it also helped me a lot! Cheers
October 27, 2006 at 10:30 am
Well, you've certainly tried a lot of variations!
Can I recommend you try and get the SQL Job to run as a CommandLine step, and set up that text file output...
October 11, 2006 at 9:17 am
Not sure if you saw all the references to this kind of problems when you searched for help of this problem.
There are a few possible issues, and things you...
October 10, 2006 at 7:23 am
comment 1
---quote----
XML As A Solution
T-SQL has native support for manipulating XML in SQL 2000, but with the release of SQL 2005, XML support is even better. T-SQL arrives with additional...
October 6, 2006 at 6:24 am
What you need to be looking at here, is Package Configurations. If you right-click the control flow pane, the 2nd or 3rd option is Package Configurations - that launches a...
September 25, 2006 at 3:11 am
but have you looked at SP_SEND_DBMAIL (SQl2005)?
I've looked over the BOL, and it would appear you can run via SQL authentication. There are some things you can only do with...
September 22, 2006 at 4:39 am
Would it not be possible to orchestrate everything in a top-level SP, which could possible then be invoked by a sp_send_dbmail call, which could be run from SQL Server Agent,...
September 22, 2006 at 3:55 am
A little more clarity please.
from what I've read:
You have a temp table that contains some data. (Please provide sample of structure of table, and data.)
You need to process the data...
September 21, 2006 at 10:31 am
try changing your SQLCode to:
INSERT INTO dbo.Dim_Audit_Pkg_Execution
(Pkg_Name)
Values (?)
September 21, 2006 at 4:52 am
that's right. MSDB houses all your maintenance plans, etc. Also, if you configured your model DB in SQL2000 to specifiy deploy certain SP's etc. you may want to make sure...
September 21, 2006 at 3:25 am
iirc, DTS packages are stored in the MSDB database. Since that is a system database, I suspect you did not 'attach' that database to SQL2K5.
September 20, 2006 at 10:37 am
Silly question, but: what is the SQL task you are executing? Is it an SP? Do you have permissions to execute the SP, or insert into the table?
September 18, 2006 at 11:07 am
Did you actually add the Log in BIDS when designing the package? If not, then right-click on the control flow pane, and configure from there...
September 18, 2006 at 8:07 am
Viewing 15 posts - 46 through 60 (of 180 total)