• Hi,

    Thanks for ur reply. The problem exists still. I changed a package configuration for SSIS to XML file. it worked fine for the first time. I closed and reopen in BIDS... I got the following package loading error

    "Error loading Package.dtsx: The connection string format is not valid. It must consist of one or more components of the form X=Y, separated by semicolons. This error occurs when a connection string with zero components is set on database connection manager. E:\TestPackConfFromXML\Package.dtsx11"

    The connection string is stored in SQL Server as

    Data Source=LocalServer;Initial Catalog=MyDB;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;

    I have the default package protection level as EncryptSensitiveWithUserKey

    Please suggest me a way to solve this issue.Im struggling for the past 2 days....

    Thnaks in advance

    Nithya

    Regards
    Priya