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'?

Good choice, for me you can go further and remove the words 'all but'. It's usually too slow as...

Is that the source or target table? This table contains duplicates and (therefore) I am guessing that it has no PK.

As an aside, Day_Month_Year is not a good choice for...

compufreak (2/26/2014)

---

Hi phil

I have a ID column which is the primary key of my table.

the ID Column can be used to capture a record for the same ID as many...

compufreak (2/26/2014)

---

Hi everyone

if possible , can I create a package to send an email that will only show the new records that has been added to my table.

once the new...

Nice work, well done!

You asked for suggestions ...

I would have loaded the condition data into an array rather than named variables. It's much easier in code to loop round an...

Or, rather than ColumnName, use ordinal position for direct access to it in subsequent code.

Dave R (UK) (2/20/2014)

---

Thanks again Phil,

that is sort of where I have got to, the problem I am having though is using a variable for the found condition....it si getting...