Changing Flat file destination doesn't change

  • Hi All

    I have a package with the flat file destination set to c:\ drive now i need to change the file destination to another drive but after i have done so on the connection manager and saving the package it still shows the destination still set to c:\.

    Any ideas??

    Thanks

    It's better to fail while trying, rather than fail without trying!!!

  • smthembu (9/30/2009)


    Hi All

    I have a package with the flat file destination set to c:\ drive now i need to change the file destination to another drive but after i have done so on the connection manager and saving the package it still shows the destination still set to c:\.

    Any ideas??

    Thanks

    So this is after you have changed it, what did you change it to ?

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • I changed it to d:\ with the same permissions on c:\ and folders

    It's better to fail while trying, rather than fail without trying!!!

  • 1.Check whether the connection manager retrieves value from configuration file.

    or

    2.Whether you have used variables in expression for connection manager.

  • Thanks a lot, now it's sorted:-D

    It's better to fail while trying, rather than fail without trying!!!

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

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