4,914 reputation
11239
bio website billfellows.blogspot.com
location Kansas City, MO
age 39
visits member for 3 years, 2 months
seen 30 mins ago

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

@billinkc


May
21
reviewed Reject suggested edit on Connect Apache Http server with Oracle
May
8
reviewed Close How to restore a database from a .bak file to an existing database via GUI?
May
2
revised Looping through values stripping 1 character at a time
Formatting
May
1
comment Stack overflow when parsing a lengthy query
Perhaps your approach could use some refinement. Could you help us understand exactly what you're doing here. It seems like the string concatenation bit could be simplified if we better understood what problem you're attempting to solve
Apr
14
comment How to Implement a Retry Feature in SSIS 2012 When a Database Connection Fails?
Checkpoints are an interesting beast. If you use them, be certain to force a failure during execution to ensure they behave as expected when you resume.
Apr
11
comment Sort Totals By Months
Mihai is on the right track. Join your derived pivot table, p, to an derived table with 1 to 12 and the month name. Order by month_number
Apr
7
comment ssis ado.net destination has failed to acquire the connection
What does your connection string look like? What components are you using to transfer the data? Is there a particular reason you're using the ado.net connection managers?
Apr
3
awarded  Popular Question
Mar
26
comment How to aggregate pairs of id values into groups
Also, which version of SQL Server are you using (please say 2012)
Mar
26
comment How to aggregate pairs of id values into groups
How derp can this hierarchy go?
Mar
26
comment SSIS and Script Component - WebReference problem
My general experience has been that when I receive the "binary code not found" message, my code didn't actually compile. Since you provided no details, my only proposal would be to add a new script component as the source, have it emit a single row (hardcoded values). Once that's working, add your web reference but don't actually use it. Does it still work? Incrementally add functionality into the component until it's finished or until you've identified what's breaking it. For us to help, we'll need to see your code and ideally access to the web service - or a comparable substitute.
Mar
23
comment How To Execute an Integration Services (SSIS) Package from a SQL Server Stored Procedure
Or they need to create a stored credential that is authorized to decrypt the package or provide the password to decrypt the package. While I wholeheartedly support a package protection level of DontSaveSensitive as a standard, if they don't have configuration in place, this is going to cause additional work for them to configure package execution
Mar
23
comment How To Execute an Integration Services (SSIS) Package from a SQL Server Stored Procedure
Open the package in BIDS and report back on what the current ProtectionLevel is
Mar
13
awarded  Popular Question
Mar
6
comment SQL Server - Same query, same database, different results
Could you try to better defined the "problem"? It appears that you are running a query, altering data, re-running the query and receive different results. As JNK has pointed out, this would be expected.
Mar
6
revised SQL-Server Custom Database Role
No signature needed
Mar
6
revised subqueries with select
Formatting to make the limit more obvious
Mar
5
comment OLE DB Sybase Connection Failing
Never dealt with sybase proper - User and password required? Have you consumed data from sybase before or first time? Any other errors or warnings before/after this that may be relevant?
Mar
5
comment OLE DB Sybase Connection Failing
32 vs 64 bit an issue?
Mar
5
revised How can I get more information about which lookup failed in an SSIS lookup?
Moar approaches