Maybe the best way of doing that is reading line one of the file and looking for field headings that you know should be there if the file is valid...

Matt Miller (#4) (7/7/2011)

---

one big difference:

SET @thevar = ( SELECT TheID

FROM ...

dmenin (7/7/2011)

---

Hi Phil!

Yes I used a script and assigned the result of a "sql task" (that runs a proc) to a variable and I chec the variable. The only problem...

You'll have to define what you mean by 'validate' please.

Text file columns do not have data types. If your destination is SQL Server, the data types are pre-defined and therefore...

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.