I write imports for excel in SSIS a lot.  To get around this you need to ensure the field in excel is formatted as text and the SQL column your...

Out of all the editorials I read by Steve, this by far is the worst. After being a member of this site for over 10 years, I check forums...

I have to concur with Mike's original post. I don't like reading texts on my cell phone nevertheless browsing web pages.

I guess I was used to this site and...

--terrible ddl but I took a stab at the first table
SELECT [LOGINNAME]
      ,LTRIM(RTRIM([FORENAME])) + ' ' + LTRIM(RTRIM([SURNAME])) as [Name] --might want to check for nulls
      ,DATEDIFF(dd,getdate(),[EXPIRATIONDATE?] --don't...

If you don't perform validations on data before you attempt to insert it into SQL you will be shocked/dismayed/disappointed your whole life as a developer.

Normally, developers would import the data from excel into a SQL staging table, then perform adds/updates/deletes in SQL.
There are plenty of articles on how to do what I mentioned above.

We create a variable called Environment as a Project Param in SSIS.  The values are TEST and PROD.  I then create variables for the Server and Database and change them...

I would import the data into SQL then I would do the transformations.
I try to keep the data flows clean, just going from source to destination.
Every now and then...

This is the way to do it in MS SQL, I don't do Oracle (Sorry)

Declare @Foo Table