Friday, November 4, 2011

Opening SQL Server 2000 DTS Package in SQL Server 2008

Error:

TITLE: Object Explorer
------------------------------

SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)

------------------------------
BUTTONS:

OK
------------------------------

Fix: Install SQLServer2005_BC & SQLServer2005_DTS softwares from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11988

If you are still not able to get it working. Please follow the below steps:

The issue was with PATH environment variable setting.

After changing the order in the path setting it got resolved.



C:\Program Files\Microsoft SQL Server\80\Tools\Binn\; should appear before the

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;

Incase of 64 bit machine:

C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;

Be sure to restart the SSMS after changing the PATH env variable

Monday, October 11, 2010

TSQL Currently logged windows user name

SYSTEM_USER

Example:

DECLARE @sys_usr char(30)

SET @sys_usr = SYSTEM_USER

SELECT 'The current system user is: '+ @sys_usr

GO

Sunday, October 10, 2010

Your Current Security Settings Do Not Allow This File To Be Downloaded

Through trial and error, I found that in addition to enabling "File Download" (Tools > Internet Options > Security (tab) > Internet > Custom Level > Downloads >> File Download) you also have to Enable (or set to Prompt) these other two options:
"Launching applications and unsafe files" and
"Launching programs and files in an IFRAME" (this one is only needed if your download occurs in an IFrame),
These 2 options are found under the "Miscellaneous" subsection, on the same settings screen as the "File Download" option.

After making these changes, I was then able to download files from sites, without having to put them into the "Trusted Sites" zone.
Hope this helps/works for others.

Thursday, September 30, 2010

MS Excel Spell Check

Select the rows/fields you want to run the spell check for and hir F7.

Thursday, September 23, 2010

'xp_cmdshell' does not exist

In order to configure xp_cmdshell, first need to enable the advanced options and then only all the advanced configuration options works out.

It can be done as follows:


EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

EXEC sp_configure 'xp_cmdshell',1
GO
RECONFIGURE
GO

Refer http://msdn.microsoft.com/en-us/library/ms189631.aspx for more options.

SQL: Enabling xp_cmdshell in SQL Server 2005

http://www.mssqltips.com/tip.asp?tip=1020

Wednesday, September 22, 2010

SSIS: Performance Tuning

http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/