I'd actually point you to BOL (Books On-Line). Based on your post, that would be the best place to start.

😎

The other question I have, is the data being imported a one for one match on columns? If so, and you load the data into a staging table, identifying...

You may also want to read this article about how to ask for help: http://www.sqlservercentral.com/articles/Best+Practices/61537/

😎

I also use UltraEdit at times, especially if I am working with large files. I find it easier to format my SQL code, and it has syntax highlighting. ...

I would use the SQL Server 2005 tools (SSMS, BIDS).

Which is also why we keep asking to see the query.

I just looked at one of my SSIS packages that has a Script Task, and I am using the & to concatenate strings.

😎

This is the code in my script.

Public Class...

Or they could be nightmares! Actually, at this point I'd say it is a good sign.

😎

Try the FileSystem task. I use it in several SSIS projects.

This article should be a must read. It doesn't apply to this post, but in the future you may ask for help where it does:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

😎

K Currie, You should read this article: http://www.sqlservercentral.com/articles/Best+Practices/61537/. It will help when asking for help as people can test their suggestions prior to posting them.

😎

Bob, EXCEPT and INTERSECT won't work here (if the post is in the correct forum) as this is SQL Server 7, 2000. EXCEPT and INTERSECT are new to SQL...

There are a lot of good books out there. I'd hit Borders to start with and just start looking at them. I'll put together a list of books...

You may also want to read this article: http://www.sqlservercentral.com/articles/Best+Practices/61537/

It would help if you posted your code, provided the DDL for the tables involved, and some sample data.

😎

Also, it would help if you could provide the DDL for the tables and some sample data. This would allow us to test what we come up with.

This article...