My scenario is slightly different I think. All source files ouind will be moved to Dest1, Dest2 etc. ie. it doesn't matter how many source files I find or what...

What I have now is an Execute SQL Task wich reads the different Destination recordfs from the SQL table and puts them in an object variable.

I then move to a...

Yes - maybe I'm over complicating things. If I use the wildcard method for the Source folder, how do I loop through to different destinations. Do I still assign the...

Apologies.

The scenario is:

Move C:\SourceFiles\*.* to C:\DestinationFiles\*.*

Over time more destinations may be added so I put them in a SQL table with SourceFileName and DestinationFileName columns. I can simply add new...

the SourceFolder variable will be the same, but there may be more than one text file in there - so I need to iterate over these files (one or many)...

It was assigning the source and destination paths to an object variable and looping through them via a ForEach loop / FST using these variables.

That sounds like just what i need.

When you say VB Transform what exactly do you mean? Do you have an example of the code? My data looks like:

3000000

4111111

4111111

4111111

3000111

4111222

4111222

4111222

So 3000000...

One more question on this...

As I split the records up from the original file, the detail records need to have some information from their header records appended to them. The...

Thanks for all your replies. I'm still workingh on the solution but am nearly there (using Conditional Split)

I have solved the problem.

What I had to do was put a ? in the Filter columns against the Year and Period columns. This then automatically created two Parameters under...

I assume these tools actually create a series of ALTER TABLE / VIEW commands to be run over the live database, as I notice the "Script Table As - Alter...

Tables and sp's.

Sorry, on 2000 I do.

Post 2000 I use EXEC msdb.dbo.sp_send_dbmail.

Thanks for the explanation. I see now. When I use for example "exec master.dbo.xp_smtp_sendmail" you have to specify a @To parameter which I suppose is the equivalent of specifying an...

Everything is controlled by the Web App.

And yes all that makes sense. Thanks.