Viewing 15 posts - 31 through 45 (of 45 total)
Thanks Jack,
I have read the referenced article in MSDN and successfully configured to pass the Parent pkg variables to the Child pkg.
The straight link is : http://msdn.microsoft.com/en-us/library/ms345179(SQL.90).aspx
Thanks,
[font="Comic Sans MS"]Vampire[/font]
April 8, 2009 at 3:50 am
@tnolan
Below is the output of the query:
Sorry that i couldn't post the query results as a grid, but i did my best to ensure its readability.
account_idservertypeservernameportusernamecredential_iduse_default_credentialsenable_sslflagslast_mod_datetime
4SMTPSmtp.Gmail.Com587XXX@Gmail.com655430104/8/2009 10:47
I have disabled...
April 8, 2009 at 3:43 am
I disabled the firewall and restarted SQL Agent also..but of no use.
The ping results of Smtp.Gmail.Com is pasted below:
ping Smtp.Gmail.Com
Pinging gmail-smtp-msa.l.google.com [209.85.147.109] with 32 bytes of data:
Request timed...
April 8, 2009 at 12:46 am
Hello @sayfrend,
I used those instructions and configured Gmail...however, when i tried sending a test mail,it failed.
Below is the DBMail log entry:
Message:
The mail could not be sent to the...
April 7, 2009 at 1:17 am
Thanks for your tip..it worked. Am now able to login. However,I have my SQL Browser running earlier too...
I earlier used this command to connect to DAC as Admin..but...
March 24, 2009 at 2:58 am
Brian,
I guess I dig grave for my own SQL Server :crying:
I have executed this trigger on a SQL Instance .\Inst1 and now it is not allowing me to connect from...
March 24, 2009 at 1:19 am
Thanks for the post Brian.
However, I am stuck with few issues. Hope you could throw some light on them and clarify .
1. I executed the Step to insert <local machine<...
March 20, 2009 at 5:24 am
January 15, 2009 at 4:36 am
[font="Comic Sans MS"]Good Work Satyanarayana..
Its working fine and easy to use. However, it would have been even good if you had provided with sample Servers.txt file, because you havent mentioned...
January 5, 2009 at 6:55 am
Thanks for the post as i hav been searching for a solution of similar kind.
However, I am left with a doubt after reading this post...
As...
September 7, 2008 at 5:45 am
Thanks for Clarifying us Carl,
I have verified and found that if the Sproc is already constructed with an INSERT INTO stmt then our attempt to Insert the records into a...
August 1, 2008 at 6:38 am
Thanks Christhopher .
I came to this conclusion after I struggled to capture an Output from a System Sproc into a table for my analysis. Consider the below code,
[font="Comic Sans MS"]
CREATE...
August 1, 2008 at 4:32 am
[font="Comic Sans MS"]@Vladan:
I guess we can't Insert the records returned by a SProc Into a table . Sql Server doesn't allow us to capture the rows returned by a Sproc...
July 31, 2008 at 9:19 am
[font="Comic Sans MS"]Thanks for the solution , this post really helped me as I too faced with the same problem.
Recently i moved the System Databases from their default location and...
April 14, 2008 at 5:01 am
Hi all,
Can some one give me solution for my problem...
Problem:
I have few SQL servers.. I need to design a DTS package that connects to all these servers and fetch the...
February 5, 2008 at 8:17 am
Viewing 15 posts - 31 through 45 (of 45 total)