Thanks for the reply.
Yes, I tried the export wizard, which is what I use for casual one-off exports.
This is more complicated - three different files exported every day at a specific time (overnight), with a very specific naming convention, then posted to the client's FTP site.
For (at present) three different projects for this client.
Which is expected to expand to 32 projects. A year.
So I need a parameterized, robust solution where I can pass in a project code and have all the files created. With an outer container that will run through the project codes and apply the same logic to each.
So I need the SSIS variables to assemble the file names with the correct date and project code.
The T-SQL part is done - stored procedure, views - I just haven't had to dive this deeply into SSIS before. With any success.
I learned coding waaaaayyy back in VB days (1980s?) before moving to RDBMSs.
T-SQL has been very forgiving about datatype conversions; SSIS is not.
I'm only slowly learning how to think in this paradigm. I'm trying NOT to bring DTS tricks (file scripting object) to SSIS and learn how to do it the new (or not so new) way - you can see my struggle in the posts. There's no money for classes or conferences and we are discouraged from buying books ("just google it!") - it's slow.
OK, there has to be a question here somewhere.
I have to pick up from yesterday after I get the am tasks done. Be back...
And I am *so* grateful for this online community...