Blog Archives

Memory monster SSIS Sort transformation

For a while I had an SSIS package being unable to complete in the production environment but which worked perfectly in development. To make matters more interesting the package will not always fail… oh! “Welcome back!” That was what I

Tagged with: , ,
Posted in Errors, SSIS

Missing Access OLE DB Connector in SSIS

And finally a new production server came along with SQL Server 2012. All works fine but the only Access database connection that I have. The image that you see above is the dialog box that I see when adding a

Tagged with: , ,
Posted in SSIS

Impersonate SQL Server Agent Job step

I had to retrieve data from a SharePoint list using a SSIS package running in a SQL Server Agent Job. The security maze came to play with me when I discovered that the account running the job is not even

Tagged with: , , ,
Posted in SSIS

SSIS SharePoint List Source Authentication Error

If you have the need to extract data from a SharePoint list into a SQL Server table most probably your are using (or tried to) the SharePoint List Source and Destination components available in CodePlex (http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652). And maybe you had

Tagged with: , , , ,
Posted in Errors, SSIS

Importing data from SAP using parameters

In the previous entry, ‘Importing data from SAP’, I detailed how to import data from SAP to SQL Server, but every time that process is executed, it imports all available data from the SAP query to SQL Server, so there

Tagged with: , , , , , ,
Posted in SAP, SSIS

Importing data from SAP

In this entry I would like to share the steps that I do when configuring SSIS to fetch data from SAP. First step: Which data to fetch? That should be the very first question of all. Which data should I

Tagged with: , , , , ,
Posted in SSIS

Non-fix width flat file

Recently I had to get the data from a flat file into the data warehouse. The file is coming from a vwell known company that provides oil & gas product prices in the international markets. The file is fetched via

Tagged with: , , , , ,
Posted in SSIS

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 24 other followers

Categories