Also while looking for something else..

Does your server domain account have these permissions on the local server:

Setting Required Permissions

To perform its functions, SQL Server Agent must be configured to use...

That is a generally true statement, and a good idea. However if the owner is a SQL login, especially a sysadmin, it does run under the login context of...

I'm with Todd on this, you can't really get access to those properties from a script. And the Expressions functionality is really built to handle this.

The only way to...

I have to admit I have never seen that. I would generally point you at the share security and then the underlying file system security since that is usually...

I would probably build a sproc that hands out job_id values to use. within it I would start a transaction, lock the record for both reads (as long as...

What tool are you using to do the import? I agree that it is a varchar(15). It is text as far as the database is concerned.

CEWII

Assuming machine B is SQL 2005 or higher the easiest way is to create a SQL Agent job on machine B that uses a job step that is of the...

I believe the reason is that the file is still in "use", you may be done with it but the system isn't. I *think* this can be resolved by...

I'm not fully understanding.. Please correct me..

You have 2 machines, one is basically a SQL server and the other is just the client tools?

You (client) doesn't want to store...

That is good to hear. The reconcilliation part of the multi-insert model is the deal breaker for me.. there is just two much to go wrong..

CEWII

I think it should always be true. If it is showing an error check the error output window, if it isn't showing then get it showing, it is your...

I seem to remember in the long long ago that there were three options in sql 6.0 and 6.5 where you could chose windows, sql, or mixed..

I don't really see...

In your exec sql task it isn't that easy.. Your query should be:

INSERT INTO CBSS_Log (FileName, FileSize, LoadDate) VALUES ( ?, ?, getdate() )

Then you go to Parameter Mapping...

Take a look at this..

Rename it by taking the .txt off the end..

CEWII

Probably the easiest would be to use a Script task in the ForEach container that uses the system.io.fileinfo and the Length property.

Does this make sense or do I need...