The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...

BlueFinity will demonstrate how to create a simple SSIS transformation to move MultiValue data into MS SQL Server using mv.SSIS in a free webinar on November 30. Microsoft SQL Server includes a ...

We have an ancient AS/400 730 system that still houses some old budget/financial data. We'd like to decommission this box, and migrate the data to a SQL server. The data won't be modified or changed ...

BlueFinity International recently demonstrated how to create a simple SSIS transformation to move MultiValue data into MS SQL Server using mv.SSIS in a free webinar on March 1. According to BlueFinity ...

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

Use custom-built .NET Framework 4.0 classes to connect an ASP.NET Web application to a SQL Server 2012 database. In my recent article, I showed how to connect .NET 4.0 C# and Visual Basic applications ...

Drooker says SQL Server’s Data Transformation Services (DTS) component has been a great time-saver in building and processing interface files. Little programming expertise or effort is required to use ...