There is a difference how Script task (VB2005) and AxtiveX script (VB6) handels

creation objects. I have noticed the same behaviour as you desrcibe.

How do you end the Scripttask?

If you...

I did make a procedure to remove bad charachters a long time ago.

In this case the characters to be removed are stored in table scrapsign with column sign varchar(1).

This...

You say that you don't want to use DTS or SSIS.

Have you consider to use Excel and VBA instead?

If you have Excel installed at the "production machine" then think about...

There is no short answere to your question. Before choosing the technology

you must define the purpose of the datawarehouse project. Who will use it?

What are the expectations? Put resources...

What kind of application?

Do you use ADO? If so

Just a thought look att

Dim conn As New ADODB.Connection

Dim cmd As New ADODB.Command

conn.ConnectionTimeout = value

and conn.CommandTimeout = value

VBA is Visual Basic for Application built in Excel.

Open Tools Macro Visual Basic Editor

or press ALT+F11. I still use Office 2003

VBA is the macro language used in Excel and is

very...

Hi

If you are to produce Excel files why not use Excel and built in VBA?

There are a great number of examples around how to do it and also works

for remote...

What Jack Corbett says is true also then using bulk insert.

But I do not understand why MS has done this by design.

Why should the local system account be involved at...

Hi

I use:

Microsoft SQL Server 2000 DTS Designer Components

The Microsoft SQL Server 2000 Data Transformation Services (DTS) package designer is a design tool used by developers and administrators of SQL...

Hi,

This is a classic question in this forum. I don't use the Excel file format.

I save the Excelfile as a text file and then import that file. This workaround

works excellent...

Thank you

The thing is that the logg is created all the time. No queries etc are running.

be aware that a field in a table can have a different collation than the default...

I never use the Excel DTS import function because of the nature described

by Mark and PW. Save the Excel sheet as a flat text file and use DTS or bulk...

Take a look at:

QlikTech : QlikView WebbPresentationer

Gosta

Hi CsDunn

I don't know how to do this in VB-script. But I had a similar problem which I used VB  or VBA like this:

Sub Test()

    Dim...

This issue has been on the agenda before.

I think the simplest way to get rid of the design problem importing Excel files with

DTS is to save the Excelfile as...