Awesome....

Thanks for the tips....

Does FTP logging use the same table as HTTP logging I can't seem to get that working 🙂

Ok... i want to use a DTS package instead....

Same thing though... start the JOB? What do you mean by job?

I see it here: http://support.microsoft.com/kb/245243

Excellent. Does it log when the file is done uploading? Or when it starts?

Can I use a trigger to call a DTS package? ...

Interesting... how is this done: The FTP Service was configured to log all data transfers to the SQL database.?

Its done through the FTP service in IIS. The file will either arrive once per night or once per month. The client has sporadic updates but as of...

I hear ya brother... its the easy way out... then the next guys looking for the answer and can't find it

😀

I solved it...

SSIS takes a look at the frist 8 records guess at the data type. Anything that doesn't fall into their guess is considered null.

Solution set IMEX=1 in...