Language Lassi

In this post we will try to crate a package that extract the data from 'Student Table' of Source-Database and load it successfully in 'Student Table' of 'Destination-Database'. You can Download or look into the sample database I am using. System requirements for SSIS or Business intelligence Development: You should have installed SQL Server Standard or Enterprise version. I am using Visual Studio Add-in (SQL Server Data Tools) in this SSIS tutorial to design SSIS package. This needs SSDT also to be installed. Once confirmed that SSDT is installed on machine. We are ready to create an ETL(Extract - Transform - Load) package. So here we go! Here are the scripts that you can run in order to generate two databases(Source and destination) with Tables in it. Go to Start Screen or Click Start Button. Go to Microsoft SQL Server and you will find 'SQL Server Business Intelligence Development Studio' under this. Open SQL Server business Inte...

How to search for a 'text' in SQL Server. So here is the magic query : You have to declare a sql variable @Search and set this variable as our text. This query will get you all the objects under the selected database containing the "text" set in sql variable. And also this will get you the object type. So you are good to know if this is stored procedure or view or anything-else. DECLARE @ Search varchar ( 255 ) SET @ Search = '[10.10.100.50]' SELECT DISTINCT     o . name AS Object_Name , o . type_desc     FROM sys . sql_modules        m         INNER JOIN sys . objects  o ON m . object_id = o . object_id     WHERE m . definition Like '%' +@ Search + '%'     ORDER BY 2 , 1 Here is the output of the query looks like: Find By Text in SQL Server