Sarah, Sounds like you are close to being on the right track. You have the right idea. What I would suggest is setting the SQL for the ExecuteSQL tasks using...

From a logical perspective, there is nothing wrong with taking case information that is public record and centralizing it in a digital format. Data is data. The interpretation and storage...

If I understand correctly, the client wants to see a character value, not the integer value. You can accomplish this by creating a lookup table that holds the text value...

Is there a reason you chose to use a list of "OR" vs CHECKSUM in your update statement? I realize CHECKSUM is not the same as CRC but it works...

Mark, I beleive this is just one step within the DTS package. What Mohan is attempting to do is to grab the "next" file in the directory.

Mohan is this your...

We have used this to enhance the export capabilities recently and the tool is a great addition to Reporting Services.

Here are some additional links that I found useful:

Article:

I do not beleive the author says the solution is clever. It is just offered as a solution to a common problem. Personally, I have used your technique as it...

Sorry for not responding before. Work was blocking notifications from sqlservercentral.com and only recently allowed them through.

You just need to set the return value of the function

Put Main = DTSTaskExecResult_Success...

Try calling myTable.Alter() after adding the column. I have a feeling the Add is in some kind of pending state and is not really part of the table object until...

Generally, when I have seen this issue in the past, it turns out to be an incorrect data type being passed to the function or a missing parameter. If David's...

What about using your LEFT in the case only once. You are evaluating the same value to be some other value so there is no need to put the full...

I have to disagree with you on your "reading data is a change". The act of reading is simply read. By looking at the data, you do not change it....

This article gives a clear defination of what drove your prior decisions. With regards to the cosmetics (Where to place parameter input and labeling of the view report button), you...

It really depends on the scope and usage of the servers. Go through the same questions you would ask yourself if you were setting up a second instance of SQL...

Cool. Figures it was a NULL. That bites me all the time.