Its certainly something to put forward when I do some further testing on this. Thanks for that!

Debbie

Integration Services.

Hmmmm I shouldnt think its permissions. I have all the right permissions set on all the folders the job needs to access. But I could be wrong. Im going...

Thanks for that!

Im still standed trying to get files from one lot of folders to another at the moment. This section is the icing on the cake. Once I get...

As you can see from the last message Im not even at this stage yet but...

Phil Parkin (5/20/2013)

---

I think you might be overdoing the looping.

If your source folder structure looks...

I'm having issues just doing an initial test at the moment. I decided to just do a much smaller version before attempting anything bigger

File System Task Access to path is...

Still no where close to coming up with even a starting point for this.

Ive gone for the basic option and created a small example folder structure. So I have 3...

Phil Parkin (5/20/2013)

---

Debbie Edwards (5/20/2013)

---

Ahhh, C# skills arent up to much.

I could possibly figure it out if I had an example to work from.

Is C# the only way to go...

Ahhh, C# skills arent up to much.

I could possibly figure it out if I had an example to work from.

Is C# the only way to go on this?

Debbie

Sorte it.... Its SELECT CAST(REPLACE(LTRIM(RTRIM(Full_Time_Equivalent_Salary)),',','') as decimal(10,4))

Yes Im happy that Excel is on the machine and that the right version is being used.

I also went through this documentation

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/8b52557b-cd13-4db6-87b6-230b7e051a9e/

http://www.microsoft.com/en-us/download/confirmation.aspx?id=227

Ok so I am further on with it now I have clicked build.

I have added some more script around the code I already had

' Microsoft SQL Server Integration Services Script...

As an extra on this...

I went back to the original error in the Integration Services script package

The Binary Code for the script is not found. Please open the script in...

Thanks for that. I wouldnt go for the second option, Its way beyond my capabilites.

There are lots of docs on the internet saying you can add a script task in...

Phil Parkin (3/6/2013)

---

Debbie Edwards (3/6/2013)

---

Im horribly close to having to sign this off as a no can do at the moment which is really dissapointing.

From what I can gather I...

Im horribly close to having to sign this off as a no can do at the moment which is really dissapointing.

From what I can gather I possibly need to execute...