dwilliscp (3/4/2013)

---

Does anyone know how to change the default package setting "ProtectionLevel" so that I do not have to set it to ServerStorage everytime I create a package. Can not...

It was indeed 🙂

What are the parameters defined as in the stored proc definition?

tota00 (3/4/2013)

---

Phil Parkin (3/4/2013)

---

Please follow the link in my signature to get details of how to post sample DDL, data and desired results to get the best response to your...

Please follow the link in my signature to get details of how to post sample DDL, data and desired results to get the best response to your question.

Are you sure that you haven't just run the package twice?

Use package configurations to control the values of things whose settings vary between environments.

Good stuff - this is the way to go.

Have you considered alternative config models?

Using an indirect XML config file to point at the location of your 'SSISConfig' database (named however you like) and having everything else reading from...

Debbie Edwards (2/28/2013)

---

Elliott Whitlow (2/27/2013)

---

I think the missing binary code is your clue. It often (usually?) means that there was a build error in your script. Open the...

This does not answer the question at all.

karthick.alangattan (2/27/2013)

---

How to convert datetime to string format (YYYYMMDD) in SSIS?

I have done using Datepart but for the date 01 to 09 it gives the values as 1 to 9....

There's more than one way that this might be done, but one which...

Sounds perfectly do-able to me, though I have some questions:

1) Does the proc always output recordsets with the same meta data?

2) What do you want your output to look like?...

sameerarjuna (2/26/2013)

---

I have a scenario , where I need to fetch data from Database 1 (on Server 1) and insert into Database 2( on Server 2) on a particular condition.

I...