In last weeks posting, we created our first SSIS package which queried a database and saved the information to a file so we could send the information to a user. This week we are going to modify that same package to save the file with the date and time included in the filename.
What is SSIS? It stands for SQL Server Integration Services which may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing. Today I am going to show you a simple solution on how to extract data and save it to a file. This exercise will show some commonly used elements to creating a lot of different solutions.
Have you ever received an email like below and then got a big pain in your stomach? Disk E: is running out of room and you need to move one of your user database files before you totally fill the disk. Yes, your VM admin might be able to add disk space but they are out sick or this is a physical machine and you need to order bigger disks and you need to make this change right now.
When you look at your data, do you see a mish mash of formats? Do some people use camel case, some all lowercase, some upper? Here is a quick script that you can use to capitalize the first letter in your single word strings.
On 2/4/2017 I went to my third SQLSaturday hosted at Hyland Software in Westlake, OH. What is SQLSaturday? From their site: “SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.” http://www.sqlsaturday.com/
Duplicate data in your database? I will show you two ways on how to delete duplicate data in your Sql Server database. How does it get there? The ways are limitless, but you more than likely do not have an adequate unique index or unique constraint setup for your table.