From what I have been reading, the ADO.Net components are only available in SSIS 2008. I used the process in the following article and have successfully moved data into...

I am also interested in hearing a response to this. I do not have ADO.NET objects under Data Flow Sources or Data Flow Destinations. I am using CS 2005...

My initial thoughts are that @id is not incrementing as I intended, or concatenating @itemid is not working properly. Is the following flawed logic in regards to TSQL:

SELECT @itemid...

As far as the columns in the join, I would only need to included the column from the table searching for the match, not the originating table?

I see what you...

I would also be up for any generalized tips when creating indexes.

Thanks Jeffrey, EM now displays the appropriate space information. From what I have read, admins may have to run this when updating to SQL 2k5, but should not after...

Update-

Just for the two databases in question, Enterprise Manager shows 0.00 space available, but when you go to shrink the db's in EM and click to show files, there is...

Both are in Full recovery mode and the transaction logs are backed up every hour. I plan to keep an eye on the db sizes, and will also grow...