Apple2_1979
Board Regular
- Joined
- Feb 17, 2012
- Messages
- 56
Hello,
I realize it is possible, but it will be my first time, can anyone point me to examples or the correct direction? I've searched but some sites seem kinda sketchy. I trust advice and like the people on this site.
I will be uploading multiple spreadsheets of Excel data into SQLServer 2008R2.
I would like SSIS or SQLServer to convert my VBA for cleaning and editing the data.
Then I'll be spitting out the information in reports afterwards.
I am currently reading MS SQLServer 2008 Integration Services-Unleashed and SQL and Relational Theory 2nd Edition to refresh my memory.
Thank-you in advance.

I realize it is possible, but it will be my first time, can anyone point me to examples or the correct direction? I've searched but some sites seem kinda sketchy. I trust advice and like the people on this site.
I will be uploading multiple spreadsheets of Excel data into SQLServer 2008R2.
I would like SSIS or SQLServer to convert my VBA for cleaning and editing the data.
Then I'll be spitting out the information in reports afterwards.
I am currently reading MS SQLServer 2008 Integration Services-Unleashed and SQL and Relational Theory 2nd Edition to refresh my memory.
Thank-you in advance.
