Package source = Microsoft SQL Server Server Type the name of the server that has the packages to be upgraded, or select this server from the list. Use Windows authentication Select to use Windows ...

The options that you see on the **Save SSIS Package** page depend on the choice that you made previously on the **Save and Run Package** page to save the package to SQL Server or to the file system.

Calling an SSIS package from another SSIS package is, on the surface, a simple task. You just use the Execute Package Task and point it to a package on a SQL Server or somewhere in the file system ...

You can design your SSIS packages in various ways, but you should always keep your goals and other factors in mind ...

You'll wonder no more how to manipulate SSIS Package Variables via Script Tasks, once you're done reading this little tidbit.

By using the Microsoft.SqlServer.Management.IntegrationServices.dll library, we can use PowerShell to automate the creation of an SSIS catalog along with folders inside. Before we get started writing ...

Today’s guest blogger is CRM MVP Darren Liu who is a CRM specialist at Sonoma Partners in Chicago. I wrote a blog article last year on how to integrate Microsoft Dynamics CRM using SQL Integration ...