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...

What...

Moving to SSIS 2012 is a good solution, if your scope extends that far. You'd be able to make good use of 'environments' within the new SSISDB 'Integration Services Catalog'...

Please define what you mean by 'dynamic input generator'.

sk.ruhulla (3/10/2014)

---

[font="Comic Sans MS"]Hi

Iam working on sql server and performed some queries and got required tables as results.

Now I want to Export the table to a CSV file USING...

vijay.sap1255 (3/7/2014)

---

Hi Exerts,

I am trying to schedule the SSIS job which is creating a problem. am currently using Sql server 2008 and client and server. When i schedule the job...

shannon.proctor (2/27/2014)

---

I solved my issue. I created an Execute SQL Task that generates a temp table. In the event the Data Flow process fails, I have another SQL...

Have you considered using an IF ... ELSE block?

if @Extract = 'Yes'

BEGIN

select stuff

END

ELSE

BEGIN

select other stuff

END

What do you mean by 'Select SQL command'?