Venki

Do you run the query as a query in Access?

In design view you have Query Properties there you can adjust the

ODBC Timeout. Default is 60 s. I run into the...

I don't run the DTS package(s) stand alone but in a VB.net project.

I know you can run a DTS package from SSIS (control flow Execute DTS 2000 package task).

This...

"but, In this case my package will be recorded in my MSDB database?"

What du you mean?

In may case the DTS packages where designed in server 2000 and saved as

etc.dts...

I know the SQLServer2005_DTS.msi, but to use this solution I need one server to sql2000 to run my packages DTS, and another server to my solution with sql2005. right?

You just...

Dan

"From what I have heard it is a quick startup solution etc"

I don't agree. Take a look at the product.

/Gosta

Hey greggoble2,

QV is now the leading product in in-memory based solutions for analysis and is a serious challange to what Paul says about OLAP.

Try it and Google about other...

Eudes

I also had a number of DTS packages importing flat textfiles developed in SQL Server 2000.

Instead of SSIS I decided to use the option in SQL Server 2005 to run...

"I'm looking for a solution to allow multiple files to be moved concurrently"

If you look at the task manager

you will probably see the the process will consume very little...

Poor datatransfer speed may also happen if you connect to other sources than AS400.

If you any form of data encryption that will slow down the speed.

I gave up SSIS and...

Venki

"Timeout messages can be misleading, but maybe you could rule out a query timeout by increasing your query's ODBC timeout property from the default 60 seconds to a larger value"

Have...

"When I export a report to excel and my report has sum fields, I would like excel to create the fields into formula fields that I could manipulate the data...

nvarchar number of characters ok?

Look in the textfile with an editor to see if there are any strange signs.

SSIS text import should work without problems but I don't use it...

Nikhil

The problem you have "is by design" when there are are a mixture of numeric and text in

a column. This problem has been on the agenda many times in...

Patrick

"** this is SQL 2000"

Will you stay in 2000 ? If so DTS and VB.script may help you.

I have left DTS behind me so I cannot help you there.

/Gosta

Marcus

I agree with Phil. What I do prefer in a matter like this is to save the Excelfile

as a tab separated text file and use bulkinsert.

But looking at your...