Reputation
6,250
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 18 47
Newest
 Caucus
Impact
~392k people reached

1d
comment Create an AD user from a SQL Server trigger
Service Pack 4 is available for SQL Server 2008. You should patch your SP3 instance in addition to the fine advice from marc_s and mike fal
1d
comment Could not load file or Assembliy “SecureBlackBox.dll”
You need to register the assembly in the global assembly cache. The typical tool for doing so is gacutil which you indicate does not exist on the server. Best I can think of is to open a command prompt (Start -> Run cmd.exe) and type cd ` and then dir /s /b gacutil.exe` and hope that there's one hiding somewhere in a frameworks folder
Jul
30
answered When does SSIS SQL Server Configuration write to the configuration table?
Jul
30
comment Is an SQL Server trace 'considered harmful' in production?
"You won't run a trace? That's fine. So, the users are waiting for the queries to complete so they perform their jobs. What alternative do you propose to identify the hotspots? " They may come back and say XE but I've often found that in larger organizations, it's the monkey banana spray scenario - someone set a rule once and no one left knows why the rule is there but it's the rule
Jul
30
reviewed Approve MySQL data transfer to different schema
Jul
29
comment How to capture PRINT statements from TSQL called by CLR stored procedure
PowerShell version sqlskills.com/blogs/jonathan/… SO answer stackoverflow.com/q/1880471/181965
Jul
29
reviewed Close MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3
Jul
29
reviewed Close insert or update on table “ aaa” violates foreign key constraint
Jul
29
reviewed Approve How can I tell how many Cores SQL Server is actually using?
Jul
29
answered SSIS: How to check if a record DOESN'T exist in flat file but exists on the database
Jul
28
comment sql server max memory includes SSIS?
Will you ever have more than one SSIS package running at the same time? If so, they'll both be contending for the free OS memory so keep that in mind.
Jul
27
awarded  Caucus
Jul
27
comment Maximum character length for a column if I concatenate all the columns together in SQL Server for SSIS packets
What value is your source system going to get from having 110 in the file? Was that 11 and 0 or 1 and 10?
Jul
26
comment SSIS - Best way to insert large number of rows
Please, don't cross post
Jul
20
comment Failed to deploy the project. Try again later. (Microsoft SQL Server, Error: 27118)
Awesome, glad you found the issue and what a weird error to have raised by the deploy procedures. Any idea how the AllSchemaOwner user lost the ssis_admin role?
Jul
15
revised SQL Server: Unable to save import export package, but am on Standard Edition
Creating packages, not profiles
Jul
15
comment SQL Server: Unable to save import export package, but am on Standard Edition
The version of DTSWizard that is launched is or isn't licensed based on the installation. Here you can see that I am licensed for SSIS on my 2008 instance but not for the 2014 (because I only installed client tools) Picture You can have valid a valid SSMS install and even a BIDS/SSDT install and still not be licensed for creating SSIS packages. Also, you might be connecting to a licensed Standard Edition box but the tools on your local machine would need to be Dev/Standard/BI/Enterprise/DW edition.
Jul
15
answered What is the relationship between the SSIS Package Store and Catalog?
Jul
15
comment SQL Server: Unable to save import export package, but am on Standard Edition
What numbers are listed when you navigate to C:\Program Files (x86)\Microsoft SQL Server? Within each of those numbered folders, is there a DTSWizard.exe in C:\Program Files (x86)\Microsoft SQL Server\NNN\DTS\Binn where NNN is 80/90/100/110/120/130?
Jul
9
comment How can I eliminate false “connection string format is not valid” messages from SSIS log?
Any chance the design-time value for the connection string is empty and only the run-time values are valid? From the logs, does it look like Execution begins, SSIS logs that the CMs are invalid and then applies the run-time connection strings and then re-validates and errors go away?