Recent content by drewj840

I have always worked in VB but recently inherited a C# application. I decided not to convert it so that I can become familiar with C#. I have an issue using the Path.Combine method in that it seems to add an extraneous "@" character at the beginning of the string which throws off an error in...

The bcp command is running from the command line and not inside a stored procedure or Query Analyzer. I don't have access to these global variables when running from the command line.

I am copy DTS packages from one server to another using BCP. This action is part of a larger script for change management control. I want to be able to determine whether the BCP was successful or encountered errors. One way I though of was to check the size of the ".err" file and if it...

I don't want to have to actually go to the machine where the package is stored. This is because I am trying to write a complete script for change management that will be run by a different group. They do not (and should not have to) have the expertise to do this (although admittedly it is not a...

Is it possible to script a DTS package so that it can be recreated on another server? I know you can output a DTS package to a structured file or to VB (6.0?) code, but I want to script the DTS package in the same way that a table or stored procedure is scripted. The purpose is to be able to run...