What's your data source?

If it's an RDBMS of some sort, you could always change it to a query containing a UNION:

select [good stuff]

union

select [vapour stuff]

You're on the right track, I think.

But what I would do is create a try ... catch block and attempt to do the convert to date in the 'try' bit....

I'd probably leave the package exporting to a fixed file name and add a final File System Task (or Script Task if you prefer to write a bit of code)...

Oops, bad code deleted!

Have you tried using a data conversion component?

--Statement 2

select * from @Table1

where (column2 != 'AP' or column3 != 'U')

After your Excel source, add a data conversion component.

Use it to convert your problematical column to DT_STR. You will see at this point that you are able to specify the...

I would guess that you have created a column in your dataflow called 'Copy of SSN' and that the error is occurring because you have mapped this column to one...

Nice error message. What's your question exactly?

I would like to hear your reasons behind this comment. In many circumstances, a staging table SSIS solution will be one or...

The fact that you need to check all of the rows in the file before deciding whether to commit any of them makes a one-pass solution a little difficult.

I'd be...

Koen Verbeeck (1/15/2013)

---

To quote the OP:

to perform additional...

You missed the obvious question: why use a script component to do lookups when there is already a dedicated lookup component?

Have you tried the Import wizard?

kenambrose (1/14/2013)

---

If using Execute Sql task, make the sql text an expression and use variables for table names

If using oledb destination in data flow task, the data access mode property...