You will need to loop through all the files and send them one by one (unless there is a bulk send option somewhere that I haven't heard of) so I...

Have you tried using the FTP Task or do you need to use a Script Task for some reason?

I've never used it before but it may solve your issue.

Sample code:

For Each row As DataRow In myDataTable.Rows

txtperson_name = row!person_name.ToString()

Next

Don't have an SSIS package at all. Do all validation and stuff in a windows application.

OR

Have your client windows application call a service (web or wcf) on a sql server...

This may help:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1406170&SiteID=1

So you want to create a wrapper package that checks a condition (the value of recordcount) and then calls the appropriate package?

If you have the recordcount in a variable, then...

Getting the 12 most recent files in a folder is possible in a script task for sure. There is also a file system task which may be able to do...

This post may help: http://www.sqlservercentral.com/Forums/Topic456102-148-1.aspx

We need more info. It depends on how you are calling the package. Are you executing it from a proc? From .NET code? etc. One option is also to...

Sorry I have no experience with setting up jobs in sql server.

But I don't see why it has to be an ssis package at all. This just doesn't seem correct.

I know that it's possible to use .NET 3.0 assemblies (to call a WCF service for example) but as far as I know they haven't been tested so the same...

This would be possible using a code (VB.NET for example) by getting the data, examining it and then chucking it into the appropriate worksheet. Using a script task in SSIS...

Just need to create an executable (in any language) and create a windows scheduled task to invoke it at the time(s) you want.

The code simply needs to check that the...

You could propagate the error (I believe there is a System::Propagate variable or similar) to the main package error event handler and set one of the package properties (forget what...

Some of the options you have are:

1. Use a sql server job

2. Use a Windows scheduled task

3. Use a Windows Service

I have no experience with the first option. The second...