It Works!

in C:\Temp i have 2 files: MyFile.txt and Schema.ini

MyFile.txt content (2 lines for example):

this~is~a~file

this~is~a~file

Schema.ini content (3 lines)

[MyFile.txt]

Format=Delimited(~)

ColNameHeader=False

T-SQL in Query Analyzer (like yours):

select * from OPENROWSET ('MSDASQL', 'Driver={Microsoft Text Driver...

Gabriela,

I think for custom formats schema.ini file should be used with text drivers as described in

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp

Schema.ini File (Text File Driver)

Which should contain lines:

MyFileName.txt

Format=Delimited(custom character)

This file should...

Francisco,

Check who is executing scheduled job.

It is possible that it is your more privileged domain or admin login is executing the job manually and it is someone with less rights...

Nick,

Check the identity.

When you run anything including VB script you are mostly is who you are (login name) unless specified explicitly. When you connect through IIS it is how IIS...

Nick,

I replied yesterday at the same postage on 2005 part of the forum with the following, you just replied on part of the question, but take a look at network...

Oleg,

Are you able to run this script outside DTS on the problem computer?

Please also compare the script versions on both good and a problem computer. To get the script...

Hello,

Please describe the connection string. Also, no error  message is posted where? Is it the web page that don't show error message or is it something else?

You may find helpful...

I did have an experience upgrading Master from 6.5 to 7.0 on the same machine, went OK. I never upgraded Master to another machine, but I moved Master to another...

Here is a quote from "Microsoft SQL Server 2000 Administrator's Companion" by Marcilina S. (Frohock) Garcia, Jamie Reding,

Edward Whalen, Steve Adrien DeLuca

Chapter "I/O Subsystem Concepts"

".........Don't use write caching...

I did have cases like that when restarting SQL Server 6.5 (long ago)

The reason was if I remember correctly an anti-virus SW and someone made a suggestion that it was a backup...

Jimmy,

I am not sure abbout XACT_ABORT.

What I would do is to check the check constraints if your data is partitioned properly. See this article, it may help.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag03/html/PartitioningTips2.asp

a paragraph right above...

Use Openrowset batches. The following connects first to the first server, then tries to connect to non-existing server then connects to the second server. The result is a first result...

I do get similar error when FTP zip or database backup files when I forget to use Binary in FTP and it downloads as ASCII files.

I don't know how this Double...

Hello,

My experience with Updatable Distributed views was that you should follow exactly all 5 pages of rules including

XACT_ABORT SET option must be set to ON.

Member tables must have the...

Hello,

You also can not see local temp tables that do not belong to your connection. That is why the best way to see them is to run a query in...