Viewing 15 posts - 1 through 15 (of 119 total)
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...
April 16, 2019 at 8:26 pm
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...
April 9, 2019 at 1:24 am
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...
April 4, 2019 at 8:37 pm
--terrible ddl but I took a stab at the first tableSELECT [LOGINNAME] ,LTRIM(RTRIM([FORENAME])) + ' ' + LTRIM(RTRIM([SURNAME])) as [Name] --might want to check for nulls ,DATEDIFF(dd,getdate(),[EXPIRATIONDATE?] --don't...
March 28, 2019 at 1:54 pm
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.
March 28, 2019 at 9:11 am
March 21, 2019 at 11:05 am
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.
March 4, 2019 at 1:13 pm
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...
December 18, 2018 at 8:00 am
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...
December 12, 2018 at 12:35 pm
This is the way to do it in MS SQL, I don't do Oracle (Sorry)
September 17, 2018 at 6:26 am
Declare @Foo Table
September 17, 2018 at 6:25 am
This is a Unicode character making it into your data. You need to determine what the code is and do a replace.Google is your friend.
September 10, 2018 at 2:16 pm
I wanted to point out another alternative. Use Excel to query SQL.I don't really have time to give you step by step instructions, but there are plenty of how-to...
August 29, 2018 at 12:34 pm
One way I do this is use a Recordset Destination (ensure the variable you are populating is an Object.
August 16, 2018 at 12:45 pm
I work at a large Law firm with 20 offices across the country. After a six month grueling conversion to iManage from opentext (Document management software) last Monday @ 9AM...
August 10, 2018 at 6:22 am