You choose "Rename file" from the dropdown menu?

File System Task

Populate a variable with an expression that calculates the new filepath (directory + filename). Use this variable in the File System...

For moving and renaming at the same time, you can use the Rename option of the File System Task.

Usually it's better to start a new thread for a new question.

First result from Google:

SSIS -...

I think the work around is to put the textbox in a tablix and set the visibility of the tablix.

Your question is not really clear. Can you post the table DDL, sample data and desired output?

Do you mean checking if an index is used?

How to get index usage information in SQL Server[/url]

The basics I guess. Writing CRUD statements, how do PK and FK work, maybe a bit about normalization.

Maybe more important to check out if he can find solutions on his...

It might take a while.

The SQL Server team has the tendency lately to release more and more cumulative updates, and less service packs.

For SQL Server 2012, there's still only sp1.

Waiting...

Misread the question and thought the data type was supposed to store negatives as well...

Need more caffeine.

Eirikur Eiriksson (5/5/2014)

---

Further on what Koen said, you will have to test explicitly for the existence of the config file, common method is to have a variable with lets say...

I still get nervous for every new job/client/project.

It keeps me on the edge 🙂

Check out this article:

Continuing a Loop After an Error[/url]

What's the actual error?

SSIS packages don't error out if a configuration is not found. They just give a warning and move on with the values specified during design time.

Just some friendly advice: if you didn't know the answer to those questions, you might want to look for junior positions.

You have some catching up to do.

prakashr.r7 (5/5/2014)

---

I am very sure, that they asked me like that. Because , I asked them twice to make sure that I heard what exactly they asked.

I told them...