4,579 reputation
11038
bio website billfellows.blogspot.com
location Kansas City, MO
age 39
visits member for 2 years, 10 months
seen yesterday

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

@billinkc


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
Mar
5
comment SQL string field lengths in a db having about 6 different types of addresses, with about 20 markets and environments
Martin Smith's answer is a good one on this question stackoverflow.com/questions/2009694/…
Mar
5
comment SQL string field lengths in a db having about 6 different types of addresses, with about 20 markets and environments
While I find the relevant question, it's a bad idea as the optimizer chooses really bad plans because it has to assume the worst when you might never go beyond 30 characters for a field
Mar
5
answered How can I get more information about which lookup failed in an SSIS lookup?
Mar
4
comment Ola Hallengren with database mirroring
Do you really think you're qualified to speak on this matter? ;)