4,784 reputation
11239
bio website billfellows.blogspot.com
location Kansas City, MO
age 39
visits member for 3 years, 1 month
seen 8 hours ago

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

@billinkc


Jul
23
awarded  Notable Question
Jul
21
comment Got error with lookup transformation in sql server 2005 BIDS
Help me understand better what you're attempting to accomplish. You're filtering data. Anything older than 3 years should not make it to the destination? What does your source structure look like?
Jul
17
comment Moving SSIS Packages to New Server
It would. It would also copy your SQL Agent information, send mail configuration and a host of other things that you may or may not want ported.
Jul
15
comment Is there any way to avoid SSMS 2012 allocating extra 1.5 GB RAM for non-standard color scheme?
You sure the custom color scheme is what is causing it?
Jul
10
comment Looking for a utility to move data between databases (prod to dev) SQL Server 2012
SSIS can be a snap if it's a straight copy. See my answer here
Jul
8
comment How do I go about easy table input without creating an application?
I believe the search term you are looking for would be scaffolding.
Jul
8
comment Why cannot login to restored SQL Server 2012 database?
You're not in single user mode, are you?
Jul
3
comment Is select * still a big no-no on SQL Server 2012?
sp_refreshsqlmodule exists for a reason
Jul
2
awarded  Curious
Jun
24
comment SSIS - the 1st item in the data flow package view always imports way slower than the others
Sounds suspicious to me. How are you measuring your throughput? Watching it in visual studio and eyeballing it?
Jun
20
comment How can I resolve timeout errors in SSIS around midnight every night?
Sing out once you've applied SP2 and let us know if it fixes things.
Jun
20
comment Importing different file types to SQL Server
You could try running queries against the files to only pull the common data elements out. You'd need to have some mechanism for identifying the separator beforehand and change the connection string appropriately. See also stackoverflow.com/questions/8168548/…
Jun
19
answered Moving SSIS Packages to New Server
Jun
19
comment How can I resolve timeout errors in SSIS around midnight every night?
What's your patch level? Have you seen Phil's post on the matter?
Jun
15
awarded  Yearling
Jun
6
reviewed Approve suggested edit on MATERIALIZED QUERY TABLE on DB2 Z/os V10
Jun
3
comment How to fix type conversion error in Data Flow task?
Cross post stackoverflow.com/questions/24016449/…
Jun
3
revised Delete and Update of Foreign keys
Grammar clean up
Jun
2
revised SQL Server 2012 Agent Job not providing full failure message for SSIS Packages
Formatting
May
21
reviewed Close Mysql sequential numbering based on MAX of another column