philcart

Forum Replies Created

Viewing 15 posts - 2,281 through 2,295 (of 2,486 total)

RE: Down Load text file from FTP thro' DTS

Take a look at the following articles, they'll give you a start.
http://www.sqldts.com/default.aspx?6,102,231,0,1
http://www.sqldts.com/default.aspx?6,103,246,0,0
http://www.sqldts.com/default.aspx?6,101,200,0,1
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
Edited by - phillcart...

April 1, 2003 at 9:52 pm

#452789
RE: So what is developer security best practice?

I don't think there is any real "best practice" as such.
A setup that has worked is giving Developers/Project Teams their own SQL Servers and sa rights to those servers. If...

March 31, 2003 at 10:32 pm

#452664
RE: Identity Increment Recycles?

SQL will not recycle IDENTITY values.
There was an article somewhere that did all the math to work out how long it would be before each datatype ran out of identity...

March 31, 2003 at 5:15 pm

#452655
RE: Syntax Help Needed
You can't put the INSERTS and DELETES inside a CASE statement.
Is there a link between tblRCStudentGrades and the other tables? If so you could do it this way,
```
 
```
March 31, 2003 at 5:03 pm

#452654

RE: Set Global Variables in DTS package fail

I couldn't find anything about 'dispatch' either, that was why I resorted to deleting the variable and recreating it.

Generally it appeared when I was assigning a value to a variable...

March 26, 2003 at 3:52 pm

#452266

RE: Unable to use BETWEEN with date value!

quote:
The problem is when I run a simple query on the table like
SELECT * from table
WHERE when_dt ='03/03/2003'

March 26, 2003 at 3:48 pm

#452264

RE: stored procedure parameters

Do it like this,

Create Procedure test

@start int,

@end int = NULL

Begin

if @end is Null

@end = @start

Remainder of sp ...

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface...

March 26, 2003 at 3:32 pm

#452258

RE: Set Global Variables in DTS package fail

Check the Global Variable definition. A couple of times I've had variables with the datatype set to dispatch with the value set to <not displayable>. The only way I was...

March 25, 2003 at 7:43 pm

#452140

RE: edit server network library configuration

Not to sure about MSDE.

The EXE's for the connection utilities are usually stored in c:\winnt\system32. Look for something called svrconfg.exe, or srvconfg.exe

Failing that, you can always edit the registry. Look...

March 24, 2003 at 8:05 pm

#451990

RE: DTS Step doesn't execute

What sort of "macro" are you running? Maybe it can be changed to write out status messages?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

March 24, 2003 at 3:46 pm

#451985

RE: To Run An MS Access Macro From SQL

Don't know if this helps any, but maybe you could execute it by creating a Access object and referring to the macro via that object.

Here's and example of creating an...

March 21, 2003 at 12:07 am

#451661

RE: Run-time error 75

Ok then, so for the best of both worlds, how about,



OPTION EXPLICIT

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

' Visual Basic ActiveX Script

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

Function Main()

< ... snip ... >

sFileName = sPath & ReturnMonth(sNow) &...

March 20, 2003 at 6:25 pm

#451645