I have a table comprising of the following 3 bigint fields (1 not null [identity primary key] and 2 null) 3 int fields (2 not null and 1 null) 46...
I have a step (call it RunEXE) in a package (call it PackageA). RunEXE executes another Package (call it PackageB) passing two global variables....
I have a stored procedure which takes about 5 seconds to run. If I call it from a DTS step it takes about 5 minutes to run. The code is like this....
Does anyone know of any issues in storing a text column as a global variable? Is there a size limit to the string?
Does anyone have any experience with accesses SQL using OLE DB from C++? I have a system where a number (about 10 to start with) C++ clients need to...
I currently use Erwin as my database comparison tool (the SQL 7 version even though I'm using SQL 2K). I've used the SQL 2K version of Erwin in the...
I need to export some data as XML. I have a table (call it Parent) with a PK of ParentID (BIGINT).<br /><br />I have maybe 40 other tables that have...
Does anyone know of any performance tests done comparing XML Bulk Load against Bulk Insert?
I need to call an exe as part of a DTS package and have that exe be able to report success or failure to the DTS package. I'm sure this will no...
I've written a stored procedure to produce the code to create a stored procedure (based on parameters). It stores the code in a VARCHAR(8000) and...
I'm getting a most strange error setting up one of the above. Setup is as follows. SQL 2000 SP3 SQL Server is running in a startup account (local...
I have a DTS package (we'll call it Bob) which will be calling a number of other DTS packages. The whole process needs to be within a transcation...
I need to have users run DTS packages from a web page. I've got this working by starting a job that runs the DTS (so that the webpage does no...
We have an application in development which will make use of simple database table. The primary key (TableID) on this table could be done in two...
I have an Excel file that uses the objects DTS.Package and DTS.Step. I therefore need to redistribute the relevant dll files to get it working. Now...
Separate names with a comma.
