Linked server&txt in SQL 2000 and SQL 2005 issues

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Linked server&txt in SQL 2000 and SQL 2005 issues

Author

Topic

rikleo2001
Posting Yak Master

185 Posts

Posted - 2008-03-07 : 09:38:13

Hi Guys,

I am trying to Query text file into SQL Server 2005 using linked server.
In SQL Server 2000 here is what I have.
Linked server configured to use following parameters
Product Name : Customer_file
Provider Name: Customer_File ( System DSN)

Here is basic file

0000003700 0000XXXXXX XX14 61J 1154-06-249
0000008600 0000XXXX11 YY17 41F 1144-12-309
0000010700 00023232323233 XX48 9DY 1145-10-299
0000015700 00001212121212 OX1 5RW 1163-08-079
0000026600 00001233333 YY1 31S 1150-12-111
0000027600 00001212121 YY15 8HU 1176-04-0891
0000038700 0000H13344 B120 8RF 1157-05-211

Now when I EXECUTE following command.
select * from openquery (TEST, 'select f1,f2,f3,f4,f5 from t#txt');
I normally get formatted output in columns..

As soon as I setup the same Linked server in SQL Server 2005, and follow same process I get all data in one column with first line as header.

I am basically concerting old import process into new one..so trying to figure out what i am missing?

Anay help?

THanks

SKR

rikleo2001
Posting Yak Master

185 Posts

Posted - 2008-03-07 : 09:59:44

It worked.. There was a schema file in sql 2000 which I was missing..
Solved.. Thanks for reading it..

Cheers

SKR

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources