My apologies but but when I first replied I missed that you had tried:

SELECT * into Tbl_Cars FROM V_Cars

Try just the select statement

SELECT * FROM V_Cars

Does it return any records?

You need to spend a bit more time learning how to create tables.

CREATE TABLE Tbl_Cars

AS

SELECT * FROM V_Cars

is not valid SQL. You cannot load data into a table that...

I agree with Crispin. That's why I started my reply with "If were using SSIS...".

I'd much rather to this in VB.

If I were using SSIS, and since I'm reasonable new at SSIS, I would load both files into SQL tables and then generate a new file from these 2 tables.

However,...

Looking at the "Access Denied" in the error statement I would say that the scheduled DTS is running as a different user when scheduled. That user does not have...

Could you make sa the owner? The job would then run using the system account.

Wouldn't it...

I'm with Terry on this one. Actually, we also used SQLAdmin.

One problem that exists with the local system account is that is does not have rights on other servers....

Instead of changing the user you may have to drop the user then add the user again being careful to use the proper case.

I'm just grasping at straws here but try scheduling the job to run around 5:15.

Just a wild guess but I'm wondering if for some reason the data is not available...

Double check the time when the job runs. Is it possible it's running after the table has been truncated?

You got an error with VARCHAR(MAX) because that is only valid in SQL 2005 and 2008.

You can use DBCC SHRINKFILE or make the changes from the database properties using SSMS. SSMS will then use DBCC SHRINKFILE to make the changes.

If you want to use temp table try using ## instead of #.

Kayuca,

You might want to take a look at the resources that are available for certifications. These resources could provide a good list of the topics that you need to...