This is not really the way that SSIS wants you to work.

It would be better if you could create a datasource which is your SELECT query.

Then put that into a...

The fact that the data shows up OK in the data viewer suggests to me that this is not a classic Excel-datatype issue, because it seems that the data is...

Try running just the Select part of the query and look for NULLs in the subisonum column.

That should show you which records are causing the issue.

Indexing? Please explain.

So am I right in thinking that you are attempting to use an Execute SQL task to retrieve a single figure and then to store that figure in a variable...

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...