Close

SSIS

Unable to start execution of step 1 (reason: JobOwner domain\domainuser

On a server running SQL 2014 SSIS with SSISDB configured, one of the SQL Agent jobs configured to run using a proxy account kept failing with the error below. Message Unable to start execution of step 1 (reason: JobOwner domain\domainuser doesn‘t have permissions to use proxy 1 for subsystem SSIS). The step failed. Solution that […]

Read More

Resolving SQL Server Agent Job Issue – System.InvalidOperationException: Unable to generate a temporary class (result=1)

Below is the final error message l kept getting when setting up a SQL Server Agent Job which ran an SSIS package. The SSIS package is designed to create a folder in a network share as well as copy some files into that folder.   Message Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 […]

Read More

Microsoft SSIS 2012 Data Import – WA State Corporation Data

Below are screenshots of SSIS – Microsoft SQL Server Integration Services 2012 importing data from Washington State Secretary of State Corporations public data file. Click here for the source link.   Below is the target table creation T-SQL code USE [CorpWA] GO /****** Object: Table [dbo].[Corporations] Script Date: 8/2/2013 12:16:57 AM ******/ SET ANSI_NULLS ON […]

Read More

Importing Edgar Database

We will be showing how to import database data from Edgar, with SQL code as well as SSIS Import Wizard configuration settings. “Since 1934, the SEC has required disclosure in forms and documents. In 1984, EDGAR began collecting electronic documents to help investors get information” First import the latest master.idx from http://www.sec.gov/edgar/indices/fullindex.htm and edit the file as shown below. […]

Read More