Updating ssis packages
Related: SQL Server 2012 Business Intelligence Enhancements When you open an SSIS package in BIDS, SSIS Designer tries to connect to the defined data sources and verify the metadata associated with those data sources.
If the data sources are unavailable, the database objects are locked, or the connect times are slow, you might have to wait an inordinate amount of time for the validation to complete or to learn that the validation failed.
Is there something I'm missing to updating the SSIS package parameters?
One of the most effective ways to extend your SQL Server Integration Services (SSIS) control flow is to use a Script task to write custom code that perform tasks you cannot perform with the built-in components.
For example, you can use the Script task to access Active Directory information or to create package-specific performance counters.
The purpose of the package is to retrieve data from a comma-separated values (CSV) file, insert the data into a SQL Server table (though no data is actually loaded), and then delete the file.
The package includes a Script task that will first determine if the file has been updated since the last data load and, if so, whether the file currently contains data.