Fantastic - thanks!

Scott

I picked up on 'trolling' forums. I suspect you meant 'trawling', unless you think we're a rather mischievous bunch!

All the help offered is appreciated. I haven't actually had a modified file yet, so may be back...

Thanks for the offer Jeff. I've got back to the data suppliers and they've agreed to make the row terminator carriage return + line feed, which should do the trick....

Drat. Have to find a plan B then. I had read that but it didn't sink in. Brain too hot.

Thank you.

A little off-topic I know, but do you really only ban drunk drivers for 30 days in the States? In the UK you can expect to lose your driving licence...

Will something like

SELECT CAST(CAST('011953120' AS decimal(19,7))/10000000 AS decimal(10,7))

do the trick?

If the name of the database server which holds this table changes, won't I then have to go through all the jobs and change the location from which they retrieve...

All the connections are (and always have been) set to Windows authentication and the server is set to mixed mode. All I did was paste the server name over the...

If that doesn't work, try echoing your $rs string to the screen and then copy and paste it into Query Analyzer. If you get an error message in QA it...

Shouldn't your insert be

$rs = us_query("insert into FormDB Values

('".$Name."','".$Number."','".$Customer."','".$Address'".,'."$City."','".$State."','".$Zip."','"[more stuff]);

(omitting the apostrophes for numeric fields)

All the tasks and the job itself are all on the same server. In the properties of the Execute DTS package task and in all the database connections, the server...

The owner is DCF\svc_sql, who is a system administrator

Just some straightforward updates. If I delete this step the next one (DTSStep_DTSExecutePackage Task) fails with the same message about not being associated with a trusted Connection.

Are you saying that your transaction log is currently 1.5GB, or that 1.5GB of log is produced every 15 minutes? If it's the former, once the initial transfer has been...