I have a flat file with row delimiter <cr> & <lf> and column delimiter <tab>.
This file has certain rows less columns than other rows. The rows which have
less columns have early termination with <cr> & <lf>. When I parsed this
file, I found SQL is not inserting missing column ...

I need to find out how to process an AS 2000 cube via vbscript.
So far I have set the following properties:
    ' *** Set Task Properties
    oOLAPTaskProperties("Description").Value = "Process MyCube"

Microsoft says it is possible but I just do not see how. Here is the
link to the help file where it said that variables could be pass as
input to web methods...I do not see the check box they mention on my
IDE.

We need to have a DTS package that takes in a parameter and exports records
from a main table that match the parameter and then exports records from
other, related, tables. Then a DTS package that imports this same data into
another db of the same structure. Can someone help me ...

I have the DTS package as follows:
Function Main()
dim i_Day
dim i_Month

I am creating a "GENERIC package" in dts 2000 that will use a dynamic
connection string from user input.
Since the source table can be different every time, I need to delete
existing transformations, which I did using an AciveX script task, now

With SS eval (enterprise edition) I cannot see the template for SSIS projects
(only the one for Reporting Services) - can anyone help?
The report for setup says the SSIS service is correctly installed and the
service is running...

Will upgrading from SQL 2000 Standard Server to SQL 2005 Standard Server
break my exisiting dts packages?  We have a large number of packages and I am
hoping that I will not have to recreate them.
TIA,

Is there any way I can zip up files within an ActiveX script?
Thanks,
Ninel

In our application, we would like to export the user data. In the main table,
it is related to many other tables with foreign keys. We have not used DTS
before and would like to see if it can export the data for us. How can we
write a DTS package that will export from the main ...

I have created a SQL Server 2000 DTS package that exports data to an excel
workbook.
It runs successfully every time that I execute it from the DTS portion of
Enterprise Manager.

Our application is used on both SQL 2005 and SQL 2000.  Is there a way to
copy a database from 2005 to 2000?  I would like to start working with SQL
2005 and support SQL 2000 as well.

I'm rewriting all of our sql2000 dts packages in ssis for our upgrade.
One of my packages has several ActiveX scripts.  The script checks to
see if a marker file is available and if it is, it proceeds to run the
rest of the package.  If there's a better (easier) way of doing this I

I need an example or some ideas - how to do this -
I need to run a job that searches a directory every hour to see if any files
are available for upload - and then upload it into a SQL data base - and
then move the file to another directory.

i'm a bit confused about how protection levels, deployment and configuration
fit to each other.
I have sensitive data in my connection strings (such as passwords) and it's
out of my reach to change this design decision. These info should be kept