Search results for query: *

I'm a SQL developer trying to get results returned in a column format rather then being returned in a row. There must be a property that changes the default from row to column, can anyone help me?

I have written a pkg to read a file from a directory on the DB server. I've created an ActiveX script to use FSO to determine if any files exist in the directory. When running the DTS pkg using the play button, the script will run ok however, when I use the dtsrun utility (within a Job) the pkg...

I am using a trigger to create a sequence number, the secondary field on a primary key. The trigger works when I manually input records into the table but I get the following error when I use an INSERT/SELECT : Server: Msg 2627, Level 14, State 1, Line 1 Violation of PRIMARY KEY constraint...

I've written a macro to export a hotfile to a specified path, however the export doesn't produce anything anywhere. However, if I leave off the path and leave just the name, the hotfile is produced in the winnt\system32 directory. See the code below. If anyone has any advise please let me...

I have a need to run two batch threads concurrently; on the completion of these two threads I need to start a job. Of the two threads one will not necessarily end before the other and both have to complete successfully before the next job is started. Does anyone have any suggestions how to use...

I have a job step that runs a vb exe, process exit code is set to zero, however if the vb exe fails the step doesn't capture the failure and continues as a success. I've tried raising an error from within the vb code, this still didn't work. Does anyone have any suggestions on how to make this...

I am using odbc to connect to DB2 on the mainframe.  My ODBC configuration states that MTS is the TP Monitor.  However when I run two simple queries in one transaction and end successfully (run setcomplete) and then try to do an insert I get the error message: only one...