You can add multiple Data Flows to the Control Flow and set precedence constraints between each Data Flow.

What time zone is the computer running this package set to? I'm guessing that it's set to GMT since the UTC offset is changing your dates to 9 pm...

There are a bunch of different ways you could handle this.

Are you using a Foreach Loop Container and using "*.pdf" in the Files text box under the Enumerator Configuration of...

The value "1997-10-16-04:00" does not mean "October 16, 1997 4:00 am".

The "-04:00" part of the date means offset the date (in UTC time) by 4 hours, which is why you...

Keep in mind that the OnPostExecute event can be coded at both the package level and the individual task level. OnPostExecute will fire one last time after the package...

I'd replace the File System task with a Script task and add the following code. Be sure to add the variable populated in your ForEachLoop Container's variable mappings...

Click on your 1st Data Flow task. See the green arrow on the bottom? Drag & drop the arrow onto the 2nd Data Flow task. This...

Yes, your package will simply contain multiple Data Flow tasks.

Set up your 1st Data Flow task normally.

For the 2nd Data Flow task, the connection manager used in the Destination of...

Have you tried using xp_cmdshell to run the dtexec utility?

Your SQL Server will have to be configured by an admin to use xp_cmdshell. If that's a possibility, you...

The easiest way to do this would be to create a SQL job that executes the SSIS package, then execute the stored procedure master.dbo.sp_start_job to run the job.

You could also...

Create a new variable that will store your paramaterized query.

Go to the variable's properties window (F4) and set "Evaluate As Expression" to true.

Click the ellipsis next to the Expression property...

Even better, get rid of your HoldingVar code and do this:

If IsDate(AllFields) Then

...

http://msdn.microsoft.com/en-us/library/ms403355(SQL.90).aspx#service

Something like this will work:

SELECT

a.empno,

a.address,

a.dob,

a.joindate,

a.timestamp

FROM

MyTable a

INNER JOIN

(SELECT

empno,

MAX(timestamp) as timestamp

FROM

MyTable

GROUP BY

empno) as b ON...

You have to add a Parent Package Variable configuration to your child package.

http://technet.microsoft.com/en-us/library/ms345179(SQL.90).aspx