Profile cover photo
Profile photo
Avesh Dhakal
180 followers
180 followers
About
Avesh's posts

Post has attachment
SSIS: Cannot Create Connector, The destination component does not have any available inputs for use in creating a path
When creating SSIS package, I was trying to link the data flow source to destination I got the error below.     After looking properly, I realized that instead of using data flow OLE DB destination, I was using data flow OLE DB source in the data flow desti...

Post has attachment
Difference between Temp Table, Table Variable and Common Table Expression (CTE)
Temp Table in SQL Server are temporarily created table in TempDB database. TempDB can be found on System Databases. It is stored as an object and created with the help of single pound sign (#). Temp table acts just like normal table, it can have primary key...

Post has attachment
SSRS: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '162'. The expected version is '147'.
 My laptop has 2 different instances of SQL Server namely SQLServer2008R2 and SQLServer2012. Today I messed up 2008 R2 reporting services when I was trying to configure 2008 R2 Reporting Services using SQLServer2012 Reporting Services Configuration Manager ...

Post has attachment
Return Date Part from DATETIME - SQL Server
Most of the time we need date part only from datetime format in SQL Server.  1) Old method  SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) 2) On SQL Server 2008 and higher SELECT CONVERT(DATE, GETDATE())  Above two methods helps to keep original date for...

Post has attachment
SSRS Default Date Parameters
Default date value in SSRS will help to provide the date/time range (Start and End Date) as needed. This will help to reduce the report execution time, it also helps end users because they don't need to provide date range every time they run the report. For...

Post has attachment
Introduction to MongoDB
MongoDB is an open source non-relational JSON store. It does not store data in relational tables, it is schema less. MongoDB is document oriented and has dynamic schema. It does not support joins and does not have transaction against multiple document. JSON...

Post has attachment
Difference between SQL Server and PostgreSQL
I had a chance of working with PostgreSQL and SQL Server at the same time to pull bulk data from PostgreSQL to SQL Server using Linked Server and OPENQUERY function of SQL Server for report writing in SSRS. Though I don't have to work much with PostgreSQL, ...

Post has attachment
SSRS report header and footer get cut off when exported to word format
Problem : I had an experience of header and footer cut off while printing the exported SSRS report to word format. According to Riccardo Muti from Microsoft  " The margins in the word document do match those in the report at 2 cm or 0.79 in. However, Word a...

Post has attachment
How to import data into SQL Server using TSQL
There are features such as Import/Export and SQL Server Integration services to get the data into SQL Server. We can get the data directly into SQL Server using SQL command such as BCP , BULK INSERT , OPENROWSET , OPENDATASOURCE , OPENQUERY and LINKED SERVE...

Post has attachment
SQL Server - PATINDEX() function
PATINDEX() function helps to return the starting position of a pattern in a string. It takes two arguments, the pattern to be searched and the expression (string), and is not case sensitive. This will return zero if it doesn't find the pattern. Syntax: PATI...
Wait while more posts are being loaded