I think there is something incorrect with your text file at that particular row. I just created a table with half a billion rows, exported that into a text file,...

It is Never a good idea to store the age in a column. Because you would have to perform an update everyday to update anyone with a birthday today. It...

Thanks Cadavre

That one works really efficiently also. I will keep that code handy.

Greatly appreciate it

Andrew SQLDBA

Thanks DWain

That is exactly what I was after. Works very fast also. Got to Love that part.

Andrew SQLDBA

I always use stored procedures for all of my SSIS Execute SQL Tasks. This makes modifications and troubleshooting so much more simple. Only one place that things can go wrong...

Thank You Micky

I was trying to use a CASE statement, but I had it in the wrong place.

Greatly appreciate your assistance

Andrew SQLDBA

Thank You to everyone that gave their code, comments and suggestions. They all worked really well.

How would I add a bit column and fill it with a 1 if the...

Yes, "inActive" means they are "greyed out" I can select them, but I cannot do anything. They will not drop onto the work area.

I have figured it out though. It...

I mean that all the tools in the Toolbox and the SSIS Toolbox are InActive. They cannot be selected.

Andrew SQLDBA

Sounds like there is absolutely no error checking in the SSIS Package. You should have multiple cleansing and staging tables to work thru before sending the data to the Destination....

Jim

You know that you run multiple instances on the same box. You can even run different versions, with multiple instances on the same box. It may be easier and better...

I would suggest that you not use all the variables, just type out the connection string as a whole. Start off by logging into the database, via SSMS using the...

Exactly Right Gail

Run while you can before your name gets tar on it.

What was also funny about that true story I told in my post. The school board contacted both...

Tell them that is not the job of a Developer. I am not a Developer, because I am a DBA. I would not hire a painter to build my house....

This is by no way a Database error, this is a front-end error. And since you did not bother to tell what the front-end is, I am taking a shot...