...Not enough storage is available to process this command.
The file I'm try to import is a text file.  There are 874,000+ records and
each record is 856 bytes long.  This is for SQL2000
I have successfully imported previous files from the same source with more

I have a scheduled job with 6 steps like
DTSRUN /s<SERVER> /e /n<DTSjobname_import_from_Access_MDB>
The job fails on these steps if users are in the Access system which the DTS
jobs import from. If no users are in, then the scheduled job runs fine.

Does anyone know of any tools and/or utilities that will document a DTS
package.  I have a bunch of them that I need both a high-level and detail
documentation for auditing purposes and change control.
Any help would be appreciated.

I'm, trying to create a ASP page that launch a DTS packed after setting a
globla variable for the import file name.
I need to import only today (2005-01-18.CSV) file, so the DTS first delete
today records than import the new file.

We have several backup jobs on MSDE.
How do I monitor these jobs and get notified when a job fails. What are the
different notification possibilites with MSDE.

I have the following problem with my custom transformation: sometimes (I have
no clue, what the reason is) it doesn't end its work. It just goes on and on
for ever, eventhough it might work just fine with the same properties some
other time.

I have created a task that executes a simple query:
select count(*) from ifsmessages
Within this task I have created an output parameter called gMsgCount with a data type of int. I have given it a parameter type of Row Value.
Next I created an ActiveX object with VBScript language. ...

I have 2 tables: 1 contains postcodes and map coordinates - tblpostcodes.
The other contains new locations with postcodes and map coordinates
tblpostcodes - tblnewLocations. eg:
tblpostcodes

One of my servers needed to be rebuilt recently and a new C drive was
installed.
SQL Server (7) was lost although the DATA was held on another drive. So I
installed SQL Server 7 again, on the C drive as a clean install and then

I have two queries shown below. They both use cursors created from the
same table (but with completely different data), and they both write to
the same table. Problem is, when I run them back to back in Query
Analyzer, the first one will execute and insert rows in the

 I have a foxpro database--not sure what version, but it is a .dbf file and
I know it is foxpro.  I need to get the data out of the database and into sql
server, so i run my DTS, and I am asked for a data source.  I then select
Microsoft FoxPro VFP Driver(*.dbf).  

In a DTS package, I am trying to define the transformations between the
source and the destination.  I have selected the "Copy Column" type and went
into the "Transformation Options" dialog box.  I selected my source columns
and my destination columns.  My problem is that when I ...

I need to do the following through Enterprise Manager (EM).
I need to copy the structure of all the tables along with their PK, FK
etc and need to copy the data of only select set of tables (not all of
them). I tried doing this in EM but lost the relationship between

i use BulkInsertTask to import txt file programly,in vc++, how can i
get number of rows imported ?

I have a package that imports data from a text file, located in an specific
folder.
My problem is that many files can be inside the folder and their names are
unknown for me. How can I find out the name and quantity of files within the