Clearly I should stick to SSIS questions and leave this stuff to people who know what they're talking about 🙂

Of course. Set breakpoints and run interactively in BIDS.

Debugging a Script Component is not so easy ...

Just a single stored proc with four input parameters should be fine. Deal with the fact that some will be NULL in the logic of the proc.

If you will only...

Here is more detail. Some superb new features.

Merlin strikes again! 😀

Sometimes you just have to shrug your shoulders and get on with it rather than try to figure out why. I doubt...

Perhaps you could also try a system restore to when your system was working well - assuming you have a suitable restore point, of course.

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