I don't believe SSIS can handle a dynamic number of column names.

Perhaps you could add a static header in row A. Column1 - Column32.

The B would be your true header...

Awesome. Thank you. I will give it a try.

Ok, thanks I'll set up a central location. The revision folder naming scheme souds good.

I'll set up this structure and create the projects. My remaining question is how would I...

Thank you for your offer. This looks like the relevant part of the log.

When I rebooted the server it went down quickly and also came back up quickly but I...

I ended up doing a reboot and everything came back up clean. I'll review the logs and post again if there is anything interesting.

Last entry in error log. Login failed for user x. Only administrators may connect at this time

Easy way to get started is to run the Export Wizard and save/edit the package.

You'll end up with 2 connection manager items: SourceConnectionOLEDB and FlatFileConnectionManager

You will also need an OLE...

Thank you both for the incredibly quick responses! Both look good.

Sorry my desired results need revision.

A=4

B=2

C=3

D=4

E=4

F=1

G=3

H=4

I=1

Thanks you for your response.

SERVERIN would be a conduit to transfer data across the firewall. DATA1 would contain our sensitive business data only some of which needs to be...

I was never able to resolve this and in the interim my specification has changed so I am no longer pursuing this.

The following link seemed the most pertinent to...

http://msdn.microsoft.com/en-us/library/cc645993.aspx

If the column count will be static then use I believe you could use SSIS.

So you will import your two files into two separate tables.

The trick will be to combine...

Will your output file always have the same number of columns? To the best of my knowledge SSIS can not handle a dynamic number of columns.

I am not sure if...

>>Would a single shared database server at one of the sites be better/fast enough?

Definitely would be simpler and for me that often means better.

Is it really acceptable for one...