Thanks for the prompt reply, but I do not have the SA password and whenever I do run the job it runs under my user name. I have added all...

I'm having this error:

Option "Source=GAMBIT;Initial" is not valid. The command line parameters are invalid. The step failed.

I have created a credential and a proxy that gives access...

The code below works for what you are asking, if you are converting an entire column that has data like '143825' just replace the '143825' with the column name and...

You're right, we all know that Microsoft products tend to be very particular to how you treat them :laugh:

Hi,

Thanks for your reply, but I figured it out, it was a really weird error. I fixed it by saving the package and then enabling everything and it started working...

I actually was able to figure this out by using powershell, I know its not the neatest way but the code is below:

$Now = Get-Date --grabs today's date

$Days = “30”...

Hi,

When testing out this code I keep getting an error underneath all the "Dts." with the error saying "reference to a non-shared object requires an object reference", is there something...

thanks for the help tmc, but I have a question about the link (dont know if you know the answer), but I was wondering in that code is there a...

Thanks for help Opc, once again you know what you are talking about. Oh yeah that package that I was working on before has taken on a life of its...

Thanks for the video, it was quite helpful when using it for other situations; but in short i'm still having the same problem. The issue is with the xml file...

Its working now John, it was a mistake that i made and didn't double check, thanks a lot

thanks for your reply, but it was a mistake that i did, i am now reinstalling it. If a problem does come up i will definitely re-post it because i...