you need to put double backslashes in all paths I've found as ssis treats a single backslash as an escape character, you double them up to aviod this.

Phil, I like...

Gangadhara MS (3/30/2010)

---

Hi David,Thanks for reply.

From where i can set EvaluateAsExpression property to true in the variable and pleas edo send me the expression as well..

as i am new...

sumon.mukherjee (3/30/2010)

---

Hi David,

Thanks a lot for your suggestion.

I have been able to figure out how to use the File System Task to rename a file. This link helped me a...

Phil Parkin (3/30/2010)

---

I do not believe that this is the most efficient way of working.

I get the impression that most people here move files to an archive folder once they...

Hi Sumon,

There is a component on the control flow called "file system task". here you can set rename file as the action and go from there

If you go to the...

Hi Gangadhar,

This can be acheived fairly simply using two variables.

Firstly Create one variable called something like DateString or similar. Set its EvaluateAsExpression property to true and enter an expression that...

Thanks for the replies guys but it was something totally different. The developer had another bit of code that ran after calling my SP that was causing this issue and...

Hi Guys, just wanted to share my solution to this issue in case it may come in use for others.

Very simply I changed my code to build an indexed...

Hi All, just wanted to close this off by saying I solved this be seperating the file imports into several different data flow tasks within the same package. This gets...

Hi, Thanks for the response. See below one of the pivot view defs.

There are circa 3.2million rows in the variable value table.

The view is re created dynamically whenever a new...

Ah sorry I misunderstood. yes technically there will be copies of the code on each server but they will be maintained from a single repository server via ssis and scheduled...

Nope just on central code db that holds a list of all servers to updated. it writes into the master db on each server and hence makes the code globally...

Not so. I've decided to go with a centralised code database and using the ssis component that transfers the code over to other DB's.

Then use a scheduled task to run...

Thanks for that Jack, it actually cleared a lot of the confusion in my mind around security.

I am unfortunatly still getting the select permission denied error. I have been over...

sorry IE had a freak out when posting. I tried to delete but didnt work