How about openrowset()? I've tried using it but Im running into some error when I try to compile.

I've tried using this:

INSERT INTO TABLE_A

SELECT * FROM OPENROWSET

(BULK...

I was told that it doesn't work well in SQL server 2005 and that it will be completely phased out by the following release.

I was told it wont work in SQL 2005, and Im getting an error when I try to compile my script that says 'unable to open BCP host data-file.'

That was it. Thanks again, you guys are great!

I'm sorry, I worded my initial question a little wrong.

The actor_role column is actually in another table, a temp table, that gets created just before this one. When I...

I believe I got it guys. I was making it harder than it needed to be.

SELECT @IMPORT_FILE_PROP = INSTALL_DIRECTORY + '\file1.TXT' from county_master

...

SELECT @IMPORT_FILE_PROP = INSTALL_DIRECTORY + '\file2.TXT' from county_master

...

SQL...

Right. I see what you're saying. The thing is, the table containing the preset column value already exists in the database. Couldn't I do this without declaring a new table...

Let me try to be more clear...

The data won't change from the text file to the table. I just need the location of the text file to be referenced within...

Eureka!!! That got it!

Thank you everyone for your help!

Got it. I tried that and it works.

But now I'm back to the original problem. I need to store the format file on a mapped drive. For instance:

BULK INSERT manatron.dbo.pt61_actor

FROM...

Thanks, I gave this a try but it still didn't work. The format file is putting "\t" as the terminator, and I can't find anything online that tells me what...

Hehe, I'm pretty much the pioneer with sp_oa*.

My boss has suggested just using bcp/xp_cmdshell to read this file into a table I created that only has one large column,...

sqltest is a member of the System Administrator fixed server role. That is what you meant, right?

Thanks...

Thanks for the quick reply...

sp_OAGetErrorInfo isn't firing. I've got it set up to fire only if an error should occur, here's part of my code:

--------------------------------------------------------------

-- Method call to execute the...

Interesting, I tried what you suggested Teague and now the DTS package works! Even with the package pointing to a mapped drive, if I run it manually, the table gets...