This post should really be in the SSRS forums.

Nevertheless, yes, this is supported in SSRS 2005 and 2008 (not sure about earlier versions). 2 terms this sort of thing...

CozyRoc (9/7/2009)

---

Paul,

This is the custom File Watcher Task, not the File System Task. And it...

Sorry I actually don't think the File System Task supports checking if a file exists.

You can use System.IO.File.Exists(yourFilePath) to check whether the file you are after exists in the given path. This can be done in a loop with a sleep - System.Threading.Thread.Sleep(yourTimeout).

Note that...

I recommend 7zip for unzipping/zipping.

It doesn't really matter which sql server the package that you are loading is on. Whichever machine you load the package and execute on is where it gets executed.

If you...

You can use something like this in a Script Task:

Dim pdfFiles() as string = System.IO.Directory.GetFiles(theDirectory, "*.pdf", System.IO.SearchOption.TopDirectoryOnly)

then loop through each file and get the ones that don't have an underscore...

Generally you'd want to run SSIS packages on sql server boxes and asp.net apps on web servers.

amit (8/18/2009)

---

This is what is Have :

I have a dtsx package which does logging in to sql server 2005, like this I have many packages.

Now I am executing these packages...

I'm...

I'm not aware of any products that can do this so I would say custom code. Shouldn't be too difficult for a programmer as the scheduling business is taken care...

A Windows scheduled task can do this. It can run every so often (every day?) and download it if necessary.

Do you mean these?

Computer name where SSIS package is currently running: My.Computer.Name

User name SSIS package is currently running as: My.User.Name

willmiss20 (8/9/2009)

---

This is the code in the script

' Microsoft SQL Server Integration Services Script Task

' Write scripts using Microsoft Visual Basic

' The ScriptMain class is the entry point of the...

willmiss20 (8/9/2009)

---

Well, scratch that last reply. Turns out with the script set to "Constraint" and "Success", it is success full every time now, even when the file does not...