This is not directly supported, as far as I know.

One thing you could try is to set an SSIS variable to 'Exit' (or whatever) and then use precedence constraints within...

If you use a SELECT as the source of your SQL data, you could CAST the BIT to INT as part of the select and then everything should happen just...

Michaelro (7/4/2011)

---

Koen Verbeeck (7/4/2011)

---

I'm afraid not, SSIS is strongly typed about its metadata.

On a sidenote: isn't a dataflow with 50 flows a little too big? Can't it be split into...

Sachin4all (6/30/2011)

---

u can create a execute sql task and create a variable to pass input value and also assign the variable to the parameter using the parameter mapping

in the...

How does your proc execute the package?

opc.three (6/29/2011)

---

Phil Parkin (6/28/2011)

---

You could try returning the columns from a stored proc and using that as the source for your data.

You'll need to include a dummy select as the...

Why do users need any sort of SSIS privileges?

Please try re-reading this & maybe you'll realise why I don't know...

Citiinvestor (6/29/2011)

---

Hi Phil Parkin Thanks for Ur response , I was also thinking something like this , but how will naming convention help me ?

lets suppose if...

glen.wass (6/29/2011)

---

That error sounds like somting your calculating has a null value so you need to find out what and eliminate the null.

Do you have any representative data we can...

If the source data is in SQL, a simple query will do this.

I don't think you'll get any better, in terms of the number of digits returned to the right of the decimal point, than FLOAT. I am interested to know why...

How do you know that Excel file 1 and FTP file 1 belong together? Is there some sort of file-naming convention?

You could try returning the columns from a stored proc and using that as the source for your data.

You'll need to include a dummy select as the first line of...

Would be useful. But a quick look at your query suggests that this

Select RandomCol from TableA where UserID = @user-id...