This is getting closer, but only picks up the last record from the table.  If there were 5 rows (file names) it only sends the last one???

DECLARE @@AttachMe varchar(5000)

SELECT @@AttachMe =...

I use something called Email2DB  ...  I'm pretty happy with it although have issues every now and then.  About a $350 piece of software. 

Why am I jumping through these hoops? 

- I know how to manully use DTS but never figured out how to automate it.

- BULK INSERT does not move text data in...

Here is my solution.  Probably ugly but it works.  I'm using OSQL and xp_cmdshell.

CREATE PROCEDURE

p_TryThis

AS

DECLARE @@DOSCommand varchar(150)

SET @@DOSCommand = 'c:\rci.bat'

TRUNCATE TABLE _TestIt

EXEC sp_dropserver 'txtsrv', 'droplogins'

--Create a linked server

EXEC sp_addlinkedserver txtsrv,...

EXEC ('INSERT INTO _TestIt (rawdata) SELECTcolumnname FROM txtsrv...[temp#txt]') 

Hack figures another thing out, new problem now.  All I needed was () and not this can be put in a stored procedure ...

Hack boy is only good for one thing a year.  I created a table, added two fields.  One an identity called SEQ and another called COLUMNNAME.

In query analyzer ran:

INSERT INTO...

WOW  ...  hack boy here figured it out.  When a linked server is created it shows in the security area. 

Went to Properties, Security, "be made without security"

I'm still getting this message.  Even ran it from the master database in care I didn't have permissions.  I'm wondering if I need to set something up with 'Microsoft.Jet.OLEDB?

Error:

Server: Msg...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=14488

Looks like I'm not the only one who has a problem with this.  Does anyone use sp_addlinkedsrvlogin?  I'm wondering if it works at all, have tried just about everything. ...

I'm not very good at SQL, so DTS is out of the question.  Well I've never figured out how to make a DTS stored procedure.  DTS works differently right.

Actually I'm...