Is the leading zero required? If it is and you are using a template excel file and not a new file then set that field as text in your template...

I am not sure how I missed this solution but here is a link to a page that handles this.

http://stackoverflow.com/questions/606621/reporting-services-parameter-constraint

The last option does infact prevent the query from...

It just happened to occur to me that I was not very clear on what I had actually tried. Some of you actually likely thought I was crazy when...

I had thought of that and basically I would allow them to enter the startdate as normal and then populate a list of possible ending dates that do not exceed...

But where in SSRS do you tell it what to do with that error. The dataset expects certain fields to be returned from the stored procedure if the SP...

not to turn this into a gripe thread but I know exactly what you are saying. I had to write an SSIS in 2005 that wrote totals from different...

welcome to the bizzare problems of working with Excel in SQL. I have had many problems getting the two to play nicely. The most bizzare of these was...

I am extremly happy to say that I am now a full time DBA! That was not always the case. In my previous job I was Local IT support,...

If this is 2005 or above you can use the row_number function if you are fimilliar with it. you would have to chage you from to a select query...

A trigger will still only fire once per statemnet though is that not correct?

If I am understanding your post correctly then it ties into a responce I just posted for another thread.

the trigger will only fire once per update so during mass updates...

HEre is a link to one of the threads on this subject.

http://www.sqlservercentral.com/Forums/Topic730493-338-1.aspx

Based on what I have read an I apologize becuase I don;t know that I have had direct expierence with this but it is my understanding that Sql server does...

yes we do have active databases on the Intergration server boxes.

Thank you so much again.

No it is also 2000 but the SSIS will deffinetly be running on a 2005 box so my thought is to just use the 2005 box as the source with...