ing-database.blogspot.com
Xu - Business Intelligence: SSIS - System Null Reference Exception
http://ing-database.blogspot.com/2008/08/ssis-systemnullreferenceexception.html
Xu - Business Intelligence. Thursday, August 14, 2008. SSIS - System Null Reference Exception. If you facing the error message in SSIS like below:. You might be using "Select * " statement in Data Flow Source, and the source has added new columns. There's an empty row data exists in Data Flow Source result. To avoid this type of error message in daily scheduling, try to use "Select specific fields" rather than using "select * statement". Which might be dangerous and will cause the package failure. T-SQL ...
ing-database.blogspot.com
Xu - Business Intelligence: T-SQL - Check all collations in SQL Server 2005
http://ing-database.blogspot.com/2008/08/t-sql-check-all-collations-in-sql.html
Xu - Business Intelligence. Thursday, August 14, 2008. T-SQL - Check all collations in SQL Server 2005. Simple T-SQL to show all available Collations in Microsoft SQL Server 2005:-. SELECT * FROM sys.fn HelpCollations(). Subscribe to: Post Comments (Atom). Analysis Samples with Excel. SQl Server 2005 Connection String. SQL Server Express Connectivity. BOE - Web Services. Crystal Report - Alternate Row Color. Crystal Report - Auto Schedule by Weekly or Monthl. SSIS - System Null Reference Exception.
ing-database.blogspot.com
Xu - Business Intelligence: August 2008
http://ing-database.blogspot.com/2008_08_01_archive.html
Xu - Business Intelligence. Wednesday, August 27, 2008. SQL Server Express Connectivity. If you are facing problem to connect to your SQL Server Express 2005 from SQL Server Management Studio, try the follow codes:-. IP Address Domain Name] SQLEXPRESS,[PORT]. PORT number by default = 1433. Make sure your UserName and Password are correct. Friday, August 15, 2008. BOE - Web Services. Having hard time to look for web services url provided by BO? Example of business objects XI Release 2 Web Service URL:-.
ing-database.blogspot.com
Xu - Business Intelligence: T-SQL - Check if Table Exists in Database System
http://ing-database.blogspot.com/2008/08/t-sql-check-if-table-exists-in-database.html
Xu - Business Intelligence. Tuesday, August 5, 2008. T-SQL - Check if Table Exists in Database System. IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT ID(N'[dbo].[ TableName. AND OBJECTPROPERTY(id, N'IsUserTable') = 1). DROP TABLE [dbo].[ TableName. Subscribe to: Post Comments (Atom). Analysis Samples with Excel. SQl Server 2005 Connection String. SQL Server Express Connectivity. BOE - Web Services. Crystal Report - Alternate Row Color. Crystal Report - Auto Schedule by Weekly or Monthl.
ing-database.blogspot.com
Xu - Business Intelligence: BOE - Web Services
http://ing-database.blogspot.com/2008/08/boe-web-services.html
Xu - Business Intelligence. Friday, August 15, 2008. BOE - Web Services. Having hard time to look for web services url provided by BO? Example of business objects XI Release 2 Web Service URL:-. Subscribe to: Post Comments (Atom). Analysis Samples with Excel. SQl Server 2005 Connection String. SQL Server Express Connectivity. BOE - Web Services. Crystal Report - Alternate Row Color. Crystal Report - Auto Schedule by Weekly or Monthl. T-SQL - Check all collations in SQL Server 2005.
ing-database.blogspot.com
Xu - Business Intelligence: SQL Server Express Connectivity
http://ing-database.blogspot.com/2008/08/sql-server-express-connectivity.html
Xu - Business Intelligence. Wednesday, August 27, 2008. SQL Server Express Connectivity. If you are facing problem to connect to your SQL Server Express 2005 from SQL Server Management Studio, try the follow codes:-. IP Address Domain Name] SQLEXPRESS,[PORT]. PORT number by default = 1433. Make sure your UserName and Password are correct. Subscribe to: Post Comments (Atom). Analysis Samples with Excel. SQl Server 2005 Connection String. SQL Server Express Connectivity. BOE - Web Services.
ing-database.blogspot.com
Xu - Business Intelligence: Crystal Report - Alternate Row Color
http://ing-database.blogspot.com/2008/08/crystal-report-alternate-row-color.html
Xu - Business Intelligence. Thursday, August 14, 2008. Crystal Report - Alternate Row Color. Simple way to color row alternately. IF RecordNumber Mod 2 = 0 THEN crSilver ELSE crNoColor. Subscribe to: Post Comments (Atom). Analysis Samples with Excel. SQl Server 2005 Connection String. SQL Server Express Connectivity. BOE - Web Services. Crystal Report - Alternate Row Color. Crystal Report - Auto Schedule by Weekly or Monthl. T-SQL - Check all collations in SQL Server 2005. The real treasure is here!
ing-database.blogspot.com
Xu - Business Intelligence: July 2008
http://ing-database.blogspot.com/2008_07_01_archive.html
Xu - Business Intelligence. Wednesday, July 30, 2008. SSMS - Shrink Database Log Files. Microsoft SQL Server 2005. Two simple steps on how to shrink database log files using SQL Server Management Studio (SSMS):-. 1 Open SSMS login Database Server Right Click Database that you would like to shrink select Task Shrink Files. As shown in figure below. 2 Do a full backup first! Select "Log" in File Types and check carefully before you click "OK". Labels: Shrink DB Log Files. Tuesday, July 29, 2008. I able to ...
ing-database.blogspot.com
Xu - Business Intelligence: Crystal Report - Auto Schedule by Weekly or Monthly
http://ing-database.blogspot.com/2008/08/crystal-report-auto-schedule-by-weekly.html
Xu - Business Intelligence. Thursday, August 14, 2008. Crystal Report - Auto Schedule by Weekly or Monthly. Human nowadays is getting lazier and lazier. Most of the time we will let "Robot" to do our daily jobs. In crystal report, it is possible to schedule daily, weekly, monthly, or quarterly report based on the parameter with auto scheduling using Job Scheduling function provided by Microsoft SQL Server. To accept values Weekly or Monthly,. Create a crystal report formula. Filter From Date (Last 7 Days).
