5,946 reputation
11645
bio website billfellows.blogspot.com
location Kansas City, MO
age 40
visits member for 3 years, 9 months
seen 5 hours ago

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

@billinkc

SQL Server MVP


Feb
24
comment Upgrade to SQL Server from 2008 to 2012 - Developer perspective
Do not ask the same question on both sites stackoverflow.com/q/28690889/181965
Feb
21
comment How can I invoke an SSIS package from SQL Agent, via T-SQL, using a proxy
I assume you don't want to create N SQL Agent jobs that use the windows ETL credentialed/proxy user to run the packages that then get invoked from the stored proc call? Or to state differently, you're trying to do all the same steps that invoking an SSIS package stored in the SSISDB as a credentialed user but it doesn't work from tsql? (that parses in my head, not sure if it comes through properly)
Feb
19
comment Arithmetic overflow error for type varchar
I think the only mapping that doesn't have the ability to overflow the target type is your LoB column. You store postal code as float in the source. The East coast appreciates this. You then stuff that into a ten character, not varying character field. I think at a minimum you're missing a -0000 along with prepending the lost leading zeros. Your Part/Catalog number column is stored as varying length unicode in the source and this maps into a 34 character type in the destination. There's a binary or text data was truncated error waiting to happen. Float into an int: same issue, diff err
Feb
19
revised Arithmetic overflow error for type varchar
added 5 characters in body
Feb
19
revised Arithmetic overflow error for type varchar
Added create statements, moved the tables to be in the same order as referenced in query
Feb
18
reviewed Approve Shrink Database/Log (growing and non growing)
Feb
18
answered SSIS Transaction Problem
Feb
17
comment SQL Server database corruption in multi-user mode but not single-user mode
given all the nasty things that can happen when you run repair - make it your absolute last choice, not your first choice - always have a good backup strategy
Feb
16
comment Error while running SSIS Package job in SSMS
Alter your jobstep to be /REPORTING EWI Error, Warning, Information. Ohterwise, yes, as Nigel has specified - something is amiss with the SharePoint connection manager. If this is a clustered instance, did you fail over to a new node?
Feb
13
comment Creating joined rows from multiple tables on date field
I've only traced through Donald's values. It appears that someone can have a Payment without a DownPayment. Is the reverse possible: A DownPayment without a Payment record?
Feb
12
comment Azure SQL slow to delete 30K records
Azure SQL Database Service Tiers and Performance Levels If you need better throughput, you need to pay for it. Or your data model is inefficient. Or your queries. Or the .NET methods you're using. It's impossible to tell what percentage each of these factors is contributing to your experience.
Feb
12
comment Azure SQL slow to delete 30K records
I spun up an S0 instance and ran the same script. Only ended up with 1.1M rows and it took significantly longer to populate the table (6 minutes). Deletion was 5x slower, 2:42 but still completed just fine.
Feb
12
comment How to use HTTP Connection Manager in Script Component? (Not Script Task)
The challenge I was running into last night was that the IDTSHttpConnectionManager100 etc components really aren't intended for use by users, documentation even mentions this. If you don't have to go the route above, I'd just look at doing it all in a .NET script source. You can modularize it, if need be, via SSIS Variables that get passed into the Script Component. I usually end up developing my complex SSIS components as separate Visual Studio Console projects to get them right, then paste the resulting code into a Component and simply wire up the Output Buffer logic.
Feb
12
comment Azure SQL slow to delete 30K records
Works fine It took me 33 seconds to delete 422k rows from a 1.2M row table not even using the PK. SQL Azure, 11.0.9229.22 using the deprecated "Web" edition.
Feb
12
comment How to use HTTP Connection Manager in Script Component? (Not Script Task)
While I beat my head against some solid surfaces to get this working, what are you trying to do? I've done a bit with SSIS, used web services, etc but haven't gone this route to do things. If nothing else, the more we talk, the less apt I am to get distracted by squirrels
Feb
9
comment How to use HTTP Connection Manager in Script Component? (Not Script Task)
I'll try to look at this tonight but take a peek at how Matt handles an OLE DB CM Might need to take a similar approach
Feb
6
awarded  Popular Question
Feb
5
reviewed Approve Error message when importing data into SQL (Import & Export Data Wizard)
Feb
5
awarded  Popular Question
Feb
4
reviewed Close Exception handler on multiple row insert PostgreSQL