It should. I always find it time consuming to debug through DTS scripts. I feel more comfortable using my own code.
Is your SQL Server running under domain account? of "Local Account"?
If you really need to find out why it is not working, you should create a small VB app using the same script and debug that way.
>Hi Jayesh,
>
> Thanks for the reply. Yes it works by using ftp command not only in windows xp but in windows 2000 as well which is what I am using. But that way, it is seperate from the Package itself. It is the good solution but I am not sure why the script won't run from within the package instead of running from command line.
>
>Thanks
>Bharat
- Jayesh