I was in the same predicament, with people in this forum being nasty and not helpful.

Here is some code you can use, needs tweeking but worked for me.

SSIS VB 2008...

This script worked for me, here is what I changed:

Added:

Imports System.Net

and changed the following line:

Dim creds As New NetworkCredential("username", "password")

After I made those changes and put in the appropriate credentials,...

Sorry guess i was wrong

SSCrazy is just a rank based on questions of the day answered or points earned for posting.

I don't see a reasonable use for Check Constraints. I have pre-process validations I perform before doing major processing, I will mark records as error if the fields in...

Well here you go:

select Convert(VarChar, GETDATE(), 101)

Yep I use it but sometimes people get carried away with their posts...Don't really care when other people wake up or go to bed...

Try this:

select A,B, '' as C from table1

where id in (select id from temp table)

Union

select A, B, C from table 2

where id in (select id from temp table)

Thanks for the clarification Kevin, I would definitely agree with your assessment.

So what you are saying is his coding stinks and he should buy your books?

Rochester, NY Here

GO BILLS...

I say take the Red Pill and get it over with.

This is the hardest question I have ever seen...Is there a solution?

Could there be Line Feeds or Carriage returns within some of the fields?

If each record has different columns, how do you identify which columns for each record go where, presence of data?

AND

if this is the case, you will need to probably import...