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

Why 1753?

In SQL Server the minimum date that you can enter is the 1st of January 1753. If you are extracting data from SAP, as I’m doing, you will see this particular date if a null date is extracted. This date

Tagged with:
Posted in SAP, 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

Date Time conversions

If there is a thing that we all fear and hate is Date/Time conversions. The different formats used around the world are a real nightmare for data standarization and if there is a thing that really drives me mad are

Tagged with: ,
Posted in SSIS

Periodic Snapshot

The business requirement was: “We would like to see the number of Open Items that we had in each month for the YTD”. The SAP aware people, they will know that an open items is a line item that has

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