Hi Phil.

Thanks, I had already come to this same conclusion.

Tim

Hi Phil.

Not sure how the final solution will pan out at the moment as everything is moving over to AWS, so lets say development will be done on the users...

In my last job we had multiple developers and everything was saved to Team Foundation Server, so we had use Don't Save Sensitive, but we rarely had problems like...

I have since found the solution to this problem. The server I was deploying to was not on the same domain so I could not use the deployment wizard. This...

When I deploy the package it does not contain any sensitive information, that's the whole point of having sensitive parameters. When you deploy by Project Deployment the Deployment Wizard changes...

If you data flow is complaining because it can' determine the Meta Data from the stored procedure then you could use:

exec p_MyProcedureName WITH RESULT SETS ((myID INT NOT NULL, myField1...

Steve Jones - SSC Editor (8/8/2016)

---

tim.ffitch 25252 (8/8/2016)

---

Until recently I was responsible for the transaction replication of an 86 GB database that contained 580 articles spread over about 20 publications....

Until recently I was responsible for the transaction replication of an 86 GB database that contained 580 articles spread over about 20 publications. The connection bandwidth was 10 Mbit per...

rocky_498 (6/20/2016)

---

Hi Guys,

I am pulling a data from XML To SQL through SSIS (Using XML Source). Source field in XML has data type xs:duration and value are as an example...

Thanks Eirikur, I knew about the protection level having to be the same. The build fails anyway if they are not set the same at the solution and package level.

Hi.

Thanks for the reply. It's working now. I deleted the entire solution and set it up again from scratch and it seems fine now. There must be a glitch in...

Why not use a script task. Using vb.net this would be

Dim MyDate as string

MyDate = date.now().ToString("yyyyMMdd HH:mm:ss")

Then pass this out to a package variable

Dts.Variables("User::VariableName").Value = MyDate