If you want to use SSIS just use the caret as the column delimiter for the input file. It will not show as an available choice from the drop down...

This was my solution to my original issue and has been working very good for almost a year and a half now. Note that my package is stored on the...

I did not use a trace in DTA. I submitted each query, one by one, from every stored proc we have. That is how I wound up with so many...

Yes, I can undo the work the DTA made, but exactly what you do you mean by upgrade?

Want to thank everyone for their insightful replies and suggestions. However, attending a seminar is not a viable solution to my immediate needs. I have performance issues that need to...

Mike,

Never mind, I found the task. For some reason it does not show up when using the Maintenance Wizard. Thanks again for you help.

Mike,

Thanks for your quick response. I do not see "delete maintenance plan files" as a an available task when I am creating a maintenance plan using the Maint Plan Wizard?...

The "select all" checkbox was removed with SP1. See following link for more info and a workaround.

http://nickbarclay.blogspot.com/2006/04/ssrs-disappearing-select-all-parameter.html

Thanks Wesley and Zubeyir. I never even noticed the report button on the summary screen. There is a wealth of information there. That will help me trace sp changes as...

Thanks for your quick response and help but I apoligize I left off part of the update query. Here is the complete query.

UPDATE TBL1

SET...

Take a look at the AdventureWorks Stored Procs such as uspUpdateEmployeeHireInfo.

Jo,

Thank you for your quick reply as I am in a time crunch. Yes it looks like the scripts will work well for the database, tables, and SPs. But I...

Thank you for your reply. I finally figured it out.

The value of my row count variable is 0 for some reason. If I set up a data viewer right after my Row Count transformation, my row count variable isn't...

Sorry, I meant it is dying after I process 32,000 records. The flat file is variable length and has 111 fields. Average record size is about 400 bytes. The Oracle...