5,732 reputation
11342
bio website billfellows.blogspot.com
location Kansas City, MO
age 39
visits member for 3 years, 7 months
seen 20 hours ago

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

@billinkc

SQL Server MVP


2d
comment How to sync two tables which are on different databases and servers using SSIS?
Possible duplicate dba.stackexchange.com/q/30473/2131
Jan
27
comment SSIS append trailer with Script
You'll also want to take note that while this approach works, it will be memory bound. For large files/servers with small memory sets, you'll want to read a row and then write it. If you search for string splitting by adam machanic, look at how he handles it.
Jan
27
comment SSIS append trailer with Script
The reason this script won't work in the Data Flow itself is that the file isn't done being written to. Even if the rows have arrived at the destination, the lock may not be released on the file and so your script would generate access violations. You might be able to get away with it, in the Data Flow task if you push your code into an override for the OnPostExecute event but that still seems like it'd have the chance for concurrent activity.
Jan
27
comment Create a read only excel file from SSIS?
There are two different things you could be referring to: the file system supports the concept of a readonly file. Excel the application allows for the definition of worksheets to be reaonly. Which one are going for?
Jan
22
comment Validating Excel Counts against Database Inserts
How would you identify the row count in Excel? Have you experienced an instance where the row count you're computing differs from what SSIS was able to extract?
Jan
21
comment CASE with CHARINDEX and CONVERT
Just so you're aware of how the SE network works, if you find an answer helpful, click the up arrow. If an answer resolves your issue, click the outline of a green checkmark.
Jan
21
comment Datawarehouse bad practice?
At my last client, as part of our ETL we had two separate stages where we rebuilt our indexes: first being after the staging area was populated and then again after the dimensions were populated. As there was a single snowflaked dimension, we had a specific indexing task in between the outermost table population and the inner node to make the process as efficient as possible. My guidance on DW tuning: Do I have an SLA? Does the data warehouse processing surpass my SLA? If processing goes belly up, and it will, when does the issue need to be resolved in order that my SLA is met?
Jan
21
comment Datawarehouse bad practice?
The SQLCAT whitepaper, link dead, on high performance offered this advice on indexes. Never drop the clustered key. If there is only one non-clustered index and you expect more than 100% growth, drop and recreate. If there is more than one non-clustered index and you expect ~10% growth, then dropping and recreating might be faster. As always, evaluate for your system and re-evaluate over time as thresholds may change.
Jan
20
answered SQL ssis delete imported rows from source table
Jan
20
comment SSIS Multicast performance question
That's my quick brain dump, post a picture of your data flow(s) and I'll see if anything jumps out. Also, do you know it's memory that has your package execution constrained?
Jan
20
answered SSIS Multicast performance question
Jan
18
revised what is better, multiple column or multiple rows while schema design
added 10 characters in body
Jan
16
answered CAST SUBSTRING to NUMERIC SSIS
Jan
15
awarded  Excavator
Jan
15
revised Is there a reason to use extremely abbreviated table names?
Linked question has been deleted
Jan
14
comment SQL server export wizard gets stuck
Or fire up procmon from sysinternals and see what's happening. I've exported millions before without issue. Since you're exporting to flat file, I assume you aren't dealing with LOB data but feel free to correct me if I'm wrong in this assumption
Jan
13
comment How do you copy a TDE-encrypted SQL Server database using T-SQL programatically?
Right, but if you use some scripting magic, you don't care that things have changed. You push the button and all of your ETL is regenerated. It follows whatever pattern you establish, truncate and reload, incremental change, etc
Jan
13
comment How do you copy a TDE-encrypted SQL Server database using T-SQL programatically?
Possibly of interest dba.stackexchange.com/a/30476/2131
Jan
13
comment SQL Server 2014 Latest CU / Service Pack
And a possibly referenced meta question
Jan
13
comment SQL Server 2014 Latest CU / Service Pack
I favor sqlserverbuilds.blogspot.com as I walk into lots of unknown environments. Sadly, I know the RTM build numbers by heart as I see them far too often