//one FTP connection thru multiple Folders C#

FtpClientConnection ftp_client;

public void Main()

{

ConnectionManager conMan;

String[] sFolderNames;

String[] sFileNames;

String[] sFileNamestoWindowsFolder;

...

if U are copying data set replace option to true and make sure to copy the schema too;)

when you save the package to the SSIS make sure you rely on the security of the SQL Server

to run the package .Then the SQL Agent account with rights will...

or make sure your crystalviewer properties are set as you need

Any .Net Service Pack?

Are you creating the reports from within .Net or outside  in Crystal Report ?

You need to configure SQL XML support in IIS

Then you can execute query to you DB from the IE

try these plus any other dll the package uses

REGSVR32 C:\Program Files\Common Files\Microsoft Shared\DSO\Resources\1033\msmdlock.dll

REGSVR32 C:\Program Files\Common Files\Microsoft Shared\DSO\Resources\1033\msmdnet.dll

REGSVR32 C:\Program Files\Common Files\Microsoft Shared\DSO\Resources\1033\msmddo.dll

REGSVR32 C:\Program Files\Common Files\Microsoft Shared\DSO\Resources\1033\msmddo80.dll

REGSVR32 C:\Program Files\Common Files\Microsoft Shared\DSO\Resources\1033\msmdso.rll

Check how much free disk space you have left

if the tempdb went too large restart sql

Could hardware[disk]/memory inadecute