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

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

@billinkc

SQL Server MVP


1d
comment resource wait SQLCLR - wait_type CLR_SEMAPHORE by SPID 0
Guessing it's an inversion of the installation so EXEC master..sp_procoption N'sp_ssis_startup', 'startup', 'off'
1d
comment resource wait SQLCLR - wait_type CLR_SEMAPHORE by SPID 0
Since it's 2012 and you mention ETL, are you using SSIS? Specifically, the new SSISDB? CLR is required for that to work and when you create the catalog, you have the opportunity to specify that a proc should run on server startup. Perhaps you've selected that for one instance and not in others
2d
comment How to recover Database System MDF and Ldf files and transaction ldf lifes
If you have backups, is the issue that you don't know how to restore system databases?
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?