5,363 reputation
11341
bio website billfellows.blogspot.com
location Kansas City, MO
age 39
visits member for 3 years, 5 months
seen 1 hour ago

Developer, devourer of pie, disciple of databases, dictator of datum, drinker of tea, delirious with alliterative devices

@billinkc

SQL Server MVP


Nov
18
comment Oracle 11g SSIS SQL Server 2014 Truncation
Current on your patches? How are you able to tell when the truncation occurs?
Nov
17
revised Any way to import-export-migrate-save-restore a maintenance plan without having SSIS installed (and running)?
added 245 characters in body
Nov
10
revised SQL Server edition support
added 24 characters in body; edited tags; edited title
Nov
10
reviewed Leave Open Division Email Template DB Design
Nov
10
reviewed Close A transaction log grows unexpectedly
Nov
10
reviewed Close The memory usage of SQL Server keeps growing
Nov
10
reviewed Close How to insert values into Bridge Table in star schema?
Nov
10
reviewed Close Update datatype of primary key without deleting the table-SQL Server
Nov
4
comment SSIS package error, can't find pre-compiled script
Look at your Output/Error window. Why it can't find the compiled script is unknown but if the source got modified and it no longer compiles, you'll get the above situation.
Nov
4
comment How to specify localhost for SSIS package source server?
and the error message is...
Oct
30
comment Why is Excel File Opened Exclusively By Another?
I can reproduce your error, if I have Excel open
Oct
29
comment expression to transform 'I' to 0
Your source data can have A, I, empty string and NULL. A becomes true, everything else is false. I ran each of those situations through your expression and they all evaluate as expected. Am I missing something in the question?
Oct
29
answered script task sssis file extension is missing?
Oct
28
reviewed Close Can you use CDC on a subscriber for transactional replicaiton
Oct
28
comment Trying to map postal codes to their respective cities, but running into some issues
Cities can have vanity names as you've discovered. Hollywood is a famous one, it's just Los Angeles I cover a bit of this over on SuperUser. The next challenge you might run into is these postal codes can change. The +4 delivery route more freq than the 5 but it happens. Also, a zip on the MO/IA border covers both. The source of the postal code data is the USPS.
Oct
28
comment How to deal with finding nearby locations when given a zip code or city?
This was fairly common at an old job (I sent you junk mail, love me) We tied a postal code to the centerpoint and used that for our lat and long. Then used great circle distance to find all the postal codes within whatever distance our client specified. I'm guessing your final link there is doing the same thing
Oct
24
comment script task sssis file extension is missing?
Are you open to a different mechanism for prefixing a log file with a date or are you married to a script?
Oct
21
reviewed Approve suggested edit on Delete and merge duplicate records from joined tables?
Oct
21
revised Delete and merge duplicate records from joined tables?
formatting
Oct
21
comment SQL Insert Statement Persists Two Records When I Need Just One
Since you're on 2012, there's no need to muck about with @@ERROR and RAISERROR. We have try/catch/throw available. Eyeballing the cursor, it looks like you could have done that with a set based insert and used the OUTPUT virtual tables to tie the newly generated ID back to the originating data. Nothing much is going to help with a bad join logic though