SSIS in Visual Studio 2008 Question

Question

SSIS in Visual Studio 2008 Question

Ken Tot

Old Hand

Points: 395
More actions
July 6, 2015 at 12:28 am

#318830

Hi there I have a problem. I have a DTS in visual studio 2008. I want to insert this script and if flagvalue = 1 then it will call or process the DTS else quit the SSIS process.
If (select FlagValue from
(select
Case When (MONTH(dtePrevDate) <> MONTH(dteValueDate)) then 1 else 0 end as FlagValue
from TBLSTARTUP)Temp
)='1' then "call my DTS"
else
quit this process
So there's like 2 nodes. the first node is an execute SQL task. Second one is a transfer database task (DTS). They are connected to each other. I hope I explained it right. Thank you.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110640 More actions · Answer 1

You could use an EXECUTE SQL Task with the destination of the data being a variable instead of some kind of recordset destination. Then you can test the variable before proceeding.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Ken Tot Old Hand Points: 395 More actions · Answer 2

sgmunson (7/6/2015)
You could use an EXECUTE SQL Task with the destination of the data being a variable instead of some kind of recordset destination. Then you can test the variable before proceeding.

Yes I'm using an execute sql task. How would I do what you are talking about?

Terence Keys Ten Centuries Points: 1140 More actions · Answer 3

Hi

This link might help:

http://blogs.msdn.com/b/mattm/archive/2006/10/30/using-expression-based-constraints.aspx

Ken Tot Old Hand Points: 395 More actions · Answer 4

Terence Keys (7/6/2015)
Hi
This link might help:
http://blogs.msdn.com/b/mattm/archive/2006/10/30/using-expression-based-constraints.aspx

Thank you very much for this. I will try today. Thanks, again.

Ken Tot Old Hand Points: 395 More actions · Answer 5

Hi everyone. I need different approach in solving my problem. This is my current script in EXECUTE SQL TASK node.

select Cast(FlagValue as bit) as [bFlagValue] from

(select

Case When (MONTH(dtePrevDate) <> MONTH(dteValueDate)) then 1 else 0 end as FlagValue

from TBLSTARTUP)Temp

Then there should be something like if it is 1/true then it will go to or run my DTS node. If 0/false, then do nothing. I've tried what someone referred above me but it doesn't work. I'm missing something.

Ken Tot Old Hand Points: 395 More actions · Answer 6

Ken Tot

Old Hand

Points: 395

July 7, 2015 at 7:26 pm

#1810830

bump. help please