Using SQL, this demonstrates what GSquared was giving you:

create table dbo.MyData (

IntVal int

)

insert into dbo.MyData (IntVal)

select 123

union all

select 4567

union all

select 987654321

select

IntVal,

...

Much cleaner and avoids loops and unnecessary temporary tables.

The best way, create a new column as a datetime column. Run a query to insert data into the new column, converting the data from the existing column into...

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