I suppose so... thanks again for your suggestions.

I implemented your suggestion CozyRoc and didn't see a performance gain. I also tried increasing bufferrow and buffersize properties for the dataflow which didn't yield antying.

I also tried to...

I'm using Script Component for this.

John,

Yep I see where you're going with that. That is the route I'm planning on taking if this doesn't pan out. Appreciate the help.

Thanks for...

The number of files we send varies. I found myself creating several flat file destinations. I was thinking to programatically write these files out directly to the destination.

Before going...

I'm wondering if I should install each SP by itself (1 then 2 then 3). I was under the impression the SP's are cumulative.

In this case I'll only run...

I'm about to do a new installation. This time I'll enable SQL Server Engine afterwards. I'll only install the DB Enging, Client Tools, and SSIS.

In regards to the provisioning...

Ahhhh... it's not variable at the row-level I have an issue with. It's the variables used for the file connection.

I finally got it worked out by positioning the file...

There must be something simple that I'm missing.

If you can provide a working sample that would be appreciated.

I gave that a shot when I looked this up yesterday... it seemed like overkill. But this was the script. Note that I've taken out the variable names from the...

I'm having trouble with this as well and I believe I have everything set properly. I want to be able to pull area code (ac) and phone (p) from different...

I didn't know that either. I kept thinking the default length when creating a table using the designer is 50. I knew that answer was too easy... 🙂

Not very good...

Flat File

You can ditch the dbconnection object I suggested. It was just to get the general idea across of changing a source. My goal is to programatically swap one of the...