1. Launch the SQL Server Management Studio and connect to the Integration Services Server.

2. Right click on the MSDB folder and import SSIS packages by specifying the filepath.

Hi,

Very nice technique indeed !

There are SQL scripts to achive the same and may come handy in such situations, however in case you do not have one with you then...

Hi all,

As rightly mentioned by Jonathan, the use of Dynamic properties task is to read the connection parameters from an .ini file rather having to hard code it in the...

Hi,

We too have a similar requirement of parsing and loading EDI 850 files to SQL Server tables in our project. These EDI 850 files consist of different segments followed by...

Hi,

Try adding clustered index on authdate column of billing.dbo.payments if not already existing. Since authdate is searched for a range of values, clustered index is recommended.

Hope this helps.

Thanks,

Amol

Probably one of the rows in the excel sheet exceeds the maximum buffer size. To over come this problem shift all such rows at the top of the excel sheet...