my $Date = 20170121;     # Parsed from file
my $file = Testfilename; # Parsed from file

##</code><code>##

my $sql = "INSERT INTO TableName(Date,FileName) VALUES($Date,$file)";
my $stmt = $settle_dbh->prepare($sql);
$stmt->execute();

##</code><code>##

DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver]Invalid precision value (SQL-HY104)

##</code><code>##

print $sql;
INSERT INTO TableName(Date,FileName) VALUES(20170121,Testfilename)