Within a container I use a script task to verify the file

eg.

Dim FileInf As FileInfo

FileInf = New FileInfo(Dts.Variables("User::FullFileName").Value.ToString())

Dts.Variables("User::FileSize").Value = CInt(FileInf.Length)

and then depending on the filesize set a status flag,...

The alternative to Linking the table via ODBC is to use a DTS in Sql server.

In Access create a new table or erase and existing one.

In SQL create a DTS...

SQL Server runs under it's own user, so mapped drives under your username may not be accessable from the command line.

The easy solution is to use UNC filenames.

eg \\ServerName\Sharename\Directory\filename