Post reply

Question on Configuration file

  • September 24, 2010 at 6:25 am

    #143475

    I have a SSIS package but i wanted to change the name of the source file....If i go and manually change the name at the connection manager it doesn't save......So to change the name of the file do i have to manually edit the configuration file or is it okay to delete the configuration file and recreate the file

    Thanks,

    Pradeep

  • September 24, 2010 at 6:51 am

    #1226921

    Either approach will work. It would probably be easier to manually edit the config file.

  • September 24, 2010 at 10:42 am

    #1227121

    One more question i know the configuration file doesn't store the Username and Password information of the connection string but i guess if u select the option Encrypt sensitive data with password should save the password information so that i dont have to enter the connection string password information everytime i open the package but it seems it didn't save the password information even if i select the option....Did anyone have the same issue before???

    Thanks in advance

  • September 24, 2010 at 1:19 pm

    #1227191

    PradeepVallabh (9/24/2010)

    One more question i know the configuration file doesn't store the Username and Password information of the connection string but i guess if u select the option Encrypt sensitive data with password should save the password information so that i dont have to enter the connection string password information everytime i open the package but it seems it didn't save the password information even if i select the option....Did anyone have the same issue before???

    Thanks in advance

    You have to manually add the password to the file yourself. That's by design, not because of a problem.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

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