Viewing 15 posts - 61 through 75 (of 121 total)
There are no restraints I am aware of ... fields are money or character. Note: I get the Isnull error for all fields. Are you sure I can use this...
September 15, 2004 at 9:28 am
For all the ISNulls assigning non 0 I get the following error:
Wrong number of arguments or invalid property assignment: 'IsNull'
What do I do when I want to set the default...
September 15, 2004 at 9:18 am
Since I made this change I get 'Unspecified error' when running the package:
Question: How do I find the true meaning of unspecified error messages
Here is what I put in:
September 15, 2004 at 7:42 am
Can I do
IsNull(DTSSource("myCol"),"")
To default in a nothing with no problem
September 15, 2004 at 7:04 am
Thanks. The problem is that one value in the calculation was null ... I just did a check first. THANKS!!!! for the reply though : )
September 14, 2004 at 7:02 am
Line: oRecordset.open strSQL, oConnection
Error: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Connection 2 is a connection already setup ... it...
September 14, 2004 at 6:54 am
So the following is executed for every record processed...does it kill my performance with the connection being made for every record. Or do I pull the connection info out of...
September 13, 2004 at 10:58 am
Thanks. I'm too new to this to be insulted. Thanks for the reply. I think I'll try embedding this in my solution (In a fashion).
Dim oConn
Dim oRecordset
Dim strSQL
strSQL = "select...
September 9, 2004 at 1:20 pm
Error I get when opening a stored procedure in the debugger. Do I have an access issue?
ODBC: Msg 0, Level 19, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler: Process 59 generated...
August 23, 2004 at 1:03 pm
Also, when I tried to do a sp_dropserver @server='NAME' I got the error ... Server: Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 44 There are still...
July 12, 2004 at 12:26 pm
Viewing 15 posts - 61 through 75 (of 121 total)