Post reply

SSIS

  • July 10, 2009 at 2:41 am

    #211979

    Hi,

    I have create one SSIS package that data has fetch from excel sheets into the DB tabels. Here i have used foreach loop container.

    In this case i got below error. Plz guide me.

    Error at Package [Connection manager "Excel Connection Manager"]: 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.

    Error at Package: The result of the expression "@[User::varLoop]" on property "ConnectionString" cannot be written to the property. The expression was evaluated, but cannot be set on the property.

    Thanks

    Sridhar.

  • July 13, 2009 at 3:40 am

    #1023748

    Sridhar,

    I am sure you are doing some mistake in Connection String.

    Could you explain the ConnectionString properties you are using in your package.

    Cheers,
    Hari
    Tips & Tricks for SQL BI Developers

  • July 13, 2009 at 5:01 am

    #1023778

    Hi weather u import the data from the excel to tables the data has entered into in check and

    please explain the conection string.

    Regards

    sat_sql

  • July 14, 2009 at 6:58 am

    #1024373

    Hi

    While configuring the properties for the excel to use that variable select the Excelfile property instead of connection string and assaign the variable "@User::varloop" it ill solve the problem.

    Regards

    Suman

  • March 2, 2010 at 7:41 am

    #1127095

    Hi, Im getting the same error, this is the connection string in my configuration file for my ssis package:

    <Configuration ConfiguredType="Property" Path="\Package.Connections[CONN].Properties[ConnectionString]" ValueType="String">

    <ConfiguredValue>

    Data Source=MYSERVER\;User ID=sa;Initial Catalog=MYDATABASE;Provider=SQLNCLI.1;PersisSecurity Info=True;Auto Translate=False;

    </ConfiguredValue>

    </Configuration>

  • March 3, 2010 at 12:06 am

    #1127552

    I see you don't use Windows Authentication in your connection string.

    Shouldn't you provide a proper user name and password?

    (if needed by your systems security settings)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • August 17, 2016 at 10:40 am

    #1895963

    Thank you !! Solved my problem easily

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply