Last Step .. Tracking Down The Problem

Firstly thank you all for you help ... i needed it .

I now have a package residing on the SQL server that i can parm in a filename and it imports the file into two tables .... works great ... till

Till i call it from a VB.net application on a FTP server. The logging im doing on the FTP server indicates the package runs ok, however there is no data in the SQL tables. In the package i was using a OLE DB connection to the SQL server tables but when running the package from the FTP server i was comming up with a manager connection error. After extensive research on the various forums i found a snippit that suggested using an ADO.Net connection, which with a few modifications have now done. As i said, i can through VS on the SQL server, run the package and everything is as it should be.

I have tried using the logging to a text file to see whats happinig when the vb application runs the package .. but it is empty apart from one line ... and still no data in the tables

data in the Package log

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
OnPreValidate,FTP2,DOMAINNAME,FTPXMLImport,{A8DA6BE3-8CCE-4E8D-97B9-D9EFB8F83584},{705B224E-7AAD-417E-AC44-ED0606947426},19/12/2007 05:29:59,19/12/2007 05:29:59,0,0x,(null)



Any suggestions on where to look to resolve this ?


ta