SQL Server 2008R2 and SSIS

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.
(y)
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,108,979
Messages
5,526,020
Members
409,675
Latest member
audeser

This Week's Hot Topics

Top