This is an easy run through tutorial of how to create a SQL Server Integration Services (SSIS) package to export a file.We are going to connect the database and use a query to populate a file. The file will be a standard CSV file.
Category: SQL Server
Create an SSIS Package to Import a File
This is an easy run through tutorial of how to create a SQL Server Integration Services (SSIS) package to import a file. This is the most basic task there can be for a product named "SQL Server Integration Services." We are going to connect the database to a file so the data from the file … Continue reading Create an SSIS Package to Import a File
SSIS: Change Encryption on a Project and Packages
When creating packages, the default security protection level is set as EncryptSensitiveWithUserKey. The user key mentioned is created off of the login of the user who created the project. If a developer other than the one who originally created the project or package opens it, they will receive the following warnings: Warning loading project_name.dtproj: Warning: … Continue reading SSIS: Change Encryption on a Project and Packages
SQL Server’s oSQL – How to Create a Date-Stamped Log
Use oSQL to run a query and save the output to a file that includes the date in the filename.
SQL Server’s Max Degree of Parallelism
I've been working on performance issues in the production database this week, taking it from a "server" level instead of database/table/index level and also adding some query changes. The database is working better, and I am continuing to keep it heading in that direction. Adding OPTION (MAXDOP 1) to certain queries has increased performance (sometimes … Continue reading SQL Server’s Max Degree of Parallelism
DataSimAntics 