Use an Expression to set the SQL ... That will decode your variable for you.

Ah, yes, I see it now. That would require detailed knowledge of importing from XML, which I do not have, sorry:-) But, in SSIS, there's always a way ... it's...

Your example did not appear, but you should check out the Multicast transformation to see whether it gives you what you need ... one source to multiple destinations.

Perhaps this thread is relevant to what you are trying to achieve?

http://www.windows-tech.info/15/e7e4a96178d88c7e.php

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...