Viewing 15 posts - 38,326 through 38,340 (of 39,466 total)
January 12, 2002 at 8:45 am
January 12, 2002 at 8:44 am
January 11, 2002 at 9:49 pm
January 11, 2002 at 9:48 pm
You're we;come, but I'm confused. If you are using SQLAgent to page you, are you specifying alerts or something else? Many times when SQLAgnet pages you, you are running xp_sendmail...
January 11, 2002 at 4:30 pm
January 11, 2002 at 4:30 pm
January 11, 2002 at 4:28 pm
For tackling the programming, I'd suggest reading lots of articles and practicing what is written. Modify it for your environment. Build yourself some tools, even if you throw them away,...
January 11, 2002 at 2:52 pm
You can setup the FTP task and use the dyanmic properties task to change the files that will be picked up. I am not sure you can automate this if...
January 11, 2002 at 2:49 pm
I would think ODBC, but I am not familiar with everything you are asking. You can setup a linked server and allow access through SQL Server, but I am not...
January 11, 2002 at 2:44 pm
January 11, 2002 at 2:38 pm
I agree with Brian. If you cannot be sure this will not hang something, I wouldn't do it.
One thing you could test is executing it with the NT scheduler on...
January 11, 2002 at 2:37 pm
Can you predict the filename? If so, you can use the dynamic properties task to change it.
Steve Jones
January 11, 2002 at 2:34 pm
January 11, 2002 at 2:33 pm
Ahh, I just saw it. In this line:
strFileSource.Move(strDestination)
strFileSource is a string variable, not an object. The syntax is object.move( source, destination).
So you would change to objFSO.Move( strFileSource, strDest).
Steve Jones
January 11, 2002 at 9:53 am
Viewing 15 posts - 38,326 through 38,340 (of 39,466 total)