You could potentially create a SQL Agent job to run the package and then allow the user to start that job.

Sounds like you have some corruption in your package. (Nasty! Call a doctor!...

You could try opening the package in an XML editor and looking for the offending GUID - might give you some clues.

aaron.reese (3/21/2014)

---

Depending on how strict your regression testing is, you might be better off with four separate packages and a master package that calls the four child packages. If...

elee1969 (3/20/2014)

---

Hello Gurus - I am building a package that has to output 4 flat files. Each flat file uses different tables. What is the best route to take to...

Eric Mamet (3/20/2014)

---

Yes... but I am trying to avoid putting my (Fact) table in a staging table so I would like to drop the rows straight into the destination,...

I presume this is because you may have multiple occurrences of the 'new' lookup item in your source data and you don't want to risk creating something which is already...

declare @XML as xml

set @XML = '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_GB" default-locale="en_GB"><Title language-id="en_GB">Cookies</Title></root>'

select @XML.value('(root/Title)[1]', 'varchar(50)')

Hi Andy

This thread might be relevant.

There are a few suggestions in there around DCOM permissions, SQL Server service account, repair installation ...

I am out of suggestions. It's the use of...

Is this specific to your PC or to the project (sounds like your PC, but worth making sure)? Does it work for other users?

Or, option three, does it affect all...

Do any of the other packages in the project get deployed?

When you do the deploy, are you using a Windows login or a SQL Server login. In my experience, Windows logins work better.

dattatreysurendra (3/18/2014)

---

Yes that is script component. But we are concatenating queries by using variables in Script Task. In that script task we are using same variable in multiple queries as...

dattatreysurendra (3/18/2014)

---

Hi All,

I am using Script task component for creating query (Can not handled due to 4000 Character issue) and running this query later in the package on Sybase Database...

jeni.jm23 (3/18/2014)

---

I need to create one package and i have to do upsert (update/insert) operations. I need to know how should i select fields n tables from sql devp. How...