Aargh, Farrelled again! 😀

From what you say, it sounds like you want a completely flexible number of parameters (from your "..all dates in the last 2 months" comment).

Have you thought about setting up...

Use a conditional split to redirect the unwanted lines to an unused output as part of your data flow.

One easy way is to put your dataflow inside a Foreach (file) container - using the input file's name as the filespec. Then it will not execute if the file...

Gangadhara MS (6/3/2011)

---

Dear All,

I have a table with 5 column out of which one column datatyp is "Datetime"

ID,Country,Dateruled Isactive

Ex: 1,India,Rural,2008-05-15 18:30:00.000 ACTIVE

The datatype for the Dateruled column is of...

No problem - but you'll need a dataflow for each one.

You can't easily do this dynamically, if that's what you're thinking of.

Sriram.RM (6/2/2011)

---

found a work around..... thought might be helpful to others.

Add an empty result set at the top with the same structure as the select statement, this will return the...

quasar_phoenicis (6/2/2011)

---

Koen Verbeeck (5/31/2011)

---

quasar_phoenicis (5/31/2011)

---

Hi,

I have a parent package with 2 execute packages tasks that are connected through a "success"contraint. Execute SSIS package 2 should not run until execute ssis...

I see your point.

Another option is to use an Execute SQL task to log start and end dates to a job status table - so you can track when the...

Interesting.

My first thought is to move the scheduling logic to a new script task at the beginning of the package, which executes the subsequent tasks if the conditions are...

Did you manage to automate the FTP part? How did you do it?

awaisahmad435 (6/1/2011)

---

can any one reconstruct my query with INNER JOIN...

I WANT TO ELIMINATE IN CLASS.... IS THAT POSSIBLE

update TBL_DEGREE_COURE_MASTER

set flag = 'FREE', flagtime = 'Application Crashed'

where SYSTEMID IN

(select b.systemid

from sys.dm_exec_connections...

For those who have trouble with SQL in plain text, here it is again with formatting:

CREATE PROCEDURE Refresh_Lock

AS

DECLARE @AccountID VARCHAR(100)

DECLARE @getAccountID CURSOR

SET @getAccountID = CURSOR FOR

SELECT TABLENAME

FROM DBO.TMP

OPEN @getAccountID

FETCH...

I would try putting package 1 in a sequence container and then adding the constraint from that to package 2.

..and if you access 2005 packages using 2008, you will have to upgrade them before they can be amended. Once they've been upgraded, they will no longer open in 2005.