Just another 2 cents, although SQL Server 2005 Express Edition is free, spending the extra $50.00 for SQL Server 2005 Developers Edition is (in my opinion) well worth while. ...

It would help us help you if you provided the DDL for your tables, some sample data, and what your epected output would look like based on the sample data.

Take...

I'm still working on the list. Between taking kids to church last night and a production issue on one of our servers, I got side tracked. I will...

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.