My ActiveX Script Task Properties dialog box has the "functions" window
maximized and I
can no longer get at my code.
I can not find any way to resize it.

Hello evryone,
I want to load access files in sql 2000 server with a dts package. the
acce4ss files are in different directory's
for example

I used the export wizard to create a package to export a table to a CSV text
file. When the wizard is done the package runs OK and creates my CSV file.
However you can not edit the resulting package. When trying to edit the
Transform Data Task the “Verifying Transformations” ...

Using SS2000 SP3a. I have a step in a package where I check for the existence
of a file. If the file is not there, I want the package to stop but it
doesn't. I've set "fail package on first error in package properties. The
code in the step is this:

I have several DTS Packages that are scheduled to run every night. If I
change the Packages, which version will be run the following night? If its
the old one, how to I update the schedule to recognize the new version?
--

Hello, I installed MS Office 2003 and SQL Server 2000.  However, when I went
to create a DTS pkg, I found that the following connection objects are
missing:
Excel,

A remote office developed a PC-based app that writes its data to a text
file. We want to maintain this data at the main office, and in SQL Server,
due to the significance of the data. A typical day's file may have a couple
hundred records, written over an eight hour shift. Rather ...

 I am trying to retrive the info (SQL Statement) from a data pump task.
 But i got an error It said "Object doesn't support this property or method"
Am i MISSING something
Dim tsk

im working on Server-client environment where i need to query data from MS
SQL to be inserted into MS access database whenever user prints report.
would like to know on the SQL Statement  syntax on how to do that .  
insert into <ms Access tbl> select ...... from <MSSQLTbl> ...

 I have a stored procedure that generates a table variable.  How am I able
to export the result of that table variable to an excel file.  I don't see
any function in Transformation Task that allows to run any stored procedure.  
All I can choose from Transformation Task is a ...

I wish to execute a DTS package from an ASP.  The package was written in SQL
enterprise mangaer then exported to a VB file.  The reason for this is that
the source file and it's path can and will change.  I therefore allow the
user to specify the file name and path and ...

I need to run 5 different Select Count(*).........
Statement from the DTS package and get the result out to
the text file. What is the best way to do this ? (It has
to be a DTS package and not any other method Jobs, SP

I have a very simple DTS process that copies five columns from an Excel
spreadsheet into a SQL table.  One of the fields is product description that
tends to be about 350-500 characters long.  When I run the DTS, SQL Server
truncates the description field at 255 characters?  Does ...

i new to msde and ms sql. i need to migrate a access db to msde/sql. The access 2000 upsizing manager crash with a overflow error for me. M$ suggest to use dtsrunui , but msde2000a is missing dtsrunui, dtsrun and all dlls are there, but there gui is missing. Is that true ? Can i ...

When you execute a package from SQL Server Agent there is some run
information that gets written to msdb.sysjobhistory.messages. Is there a
way to use a script action to append some text to that information? This
seems like an obvious thing to do to me but I'm banging my head ...