OK, this is how I think it should work - not that I've done it before - so please excuse slight inaccuracies ...

1) Create two string package variables, 'FileSpec' and...

Surely this thread would be more likely to get a decent response in the BI forum?

Introduce an initial Execute SQL task which sets a package variable to, say, the result of running a query like this:

select count(*) [VersionCount] from table

where version = 'xxxxxx'

Then, after your...

I asked you two questions and you answered neither. So I do not know whether I am on the right track.

A Foreach container might give you what you want ......

This is how I would do it.

1) Copy from a blank (except for column names) Excel spreadsheet file to (say) export.xls

2) Your package always exports to this new export.xls

3) A...

Do you mean that you know that there will be a file called

filename_2006_06_30_hhmmss.xls

but that you do not know what the hhmmss bit will be? So a test for

filename_2006_06_30_*.xls

would return the...

Using the Excel file as the source, a Script Component should be able to build the output you want. Will take some dev, but may be able to code it...

OK, great. You need two datasources (your two files) going into a MERGE JOIN transformation within a dataflow task.

From your MERGE JOIN, output to your SQL Server destination (third table,...

What do you mean by 'selected'?

Are the tables in SQL Server?

How does this question relate to SSIS - what are you going to do with the data?

That's quite a long post and I did not read it in detail. But I think I get the gist.

The way I would do this is to maintain your ExternalID...

Here's a VB.NET function that you could adapt:

Public Function GetLongDateSQLFormat(ByVal data As Date) As String

getLongDateSQLFormat = ""

getLongDateSQLFormat = Format(data, "yyyy-MM-dd...

Log in to the server using Terminal Services and run it there ...

In the editor for the flat file connection, what are the datatypes for the input columns?

Your original post did not suggest any reason why you would need to use a conditional split - can you describe why you are doing this?

You talk about 'dragging' from...

Here is one way.

1) Create a package variable - UserID

2) Modify your ExecuteSQL task so that the result of the query is mapped to UserID.

3) Add a Derived Column transformation...