Error is: Unable to retrieve file using ftp connection manager

It works fine through SSIS, no matter the number of files or the size of files.

The permission on all the files are same.

If i make another two copies of the...

Thanks,

Brian this is what i wanted.

Thanks a lot!!!!!!!!!!!!!!!!!!!!!!!!!!

Mark Thank for you reply

But here once i disable the primary job i want to make sure it has completed execution and then have the sql server agent start the...

Did you try question profiler with filtering?

and another option i think you can try would be sysprocess table.

sorry, its recovery instead of no recovery

-------------------------------------

you can use either of the below two options to get the database into recovery state

RESTORE DATABASE database_name

WITH RECOVERY

OR

RESTORE LOG database_name

WITH RECOVERY

you can use the following query to get the list of functions and sp that are executed against that

table

SELECT so.name AS FuncProcName, t.TABLE_NAME AS TableName, sc.text AS Definition

...

you can use either of the below two options to get the database into recovery state

RESTORE DATABASE database_name

WITH NORECOVERY

OR

RESTORE LOG database_name

WITH...