One new feature in SQL Server Management Studio 2008 is the ability to restrict changes that would force a table to be re-created. This is a safety valve which can be turned off, if you choose. Let’s ...

I'm importing a flat file into SSIS which needs to be split into two tables. In my input file I have a few columns (just an example.. I'm not really working with boxes): Box contents, box weight, box ...

I have never used SQL Server Integration Services before and need to extract data out of several Access databases, then transform it and load it into an SQL Server table. Migrating data from Access to ...