SSIS basics, changing a file connection location and e-mail attachment location

I've gotten past the newbie phase and working my way up to beginner in SSIS. So I'm trying to change the file location of my output file from "C:\ drive" to "E:\" drive, but it never saves my changes ! Plus in an e-mail task it won't take the same change.

I've made the change multiple times, have saved the package, exited VS, came back in, but it still remains "C:\" drive ! (I think it's mocking me . . . )

I'm sure I opened the same project I just changed and closed. The files exist in the target location of "E:\" drive.

I would simply change the location to "E:\" drive, that didn't work, then I browsed to the file, etc. Save - close - open --> "C:\" drive !!!!! *(&^%$#

So what am I missing ? I can post screen shots if you would like to see
LVL 1
Alaska CowboyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alaska CowboyAuthor Commented:
I asked two experienced developers here - both went through the same steps I did, and got the same results, so both were like, "Hmmm. I'm not sure why that's not saving. Let me think about this." And then they walked away . . .
0
DcpKingCommented:
I checked it on a copy of BIDS from SQL Server 2008 and it works for me, so ...

Click on the Flat File Connection Manager you're using and go to its properties on the right. The Connection String property tells you where the file will be written to. Go a few rows down and open up the Expressions dialog box (the "..." box at the right).

Drop down the Property list and select Connection String. Does it have a setting already? If so then that's your problem.

hth

Mike
(If you need pictures, etc. just ask!)
0
Alaska CowboyAuthor Commented:
Mike, ok, thanks. I did the simple version and have changed the properties multiple times - no luck, even after saving it reverts back to "C:\" drive . . . :-(

I checked Expressions but not sure what you are saying . . . should I add a value for Connection String in Expressions ? If so, how do I do that ? I tried ==C:\SSIS_Data\EDW\JHU_current_members.csv but it didn't like that.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Alaska CowboyAuthor Commented:
I think it's because I have a config file, which overrides my edits . . . does that sound about right ?
0
DcpKingCommented:
If the connector connection string is in the config file then yes, it will do that! You can edit the config file with Notepad and search for "C:\yourpath", change it to 'E:\yourpath", save it, open the package and see if things have changed. If so then you'll have proved that that was the problem. Be careful, though, if you find multiple occurrences of "C:\yourpath", that you change the right one!

hth

Mike
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Alaska CowboyAuthor Commented:
Mike, yep, that was it :-) Thanks !
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.