And does anyone know why sometimes I see more than one row for a particular SPID. For example I have one now that has 9 rows for one SPID....

Thanks for your reply. I know there are no linked servers being used so it won't be that. I suspect the hard drive and yes the two stored...

Thanks!

I am glad you have liked my article. Please forgive me for being slow to reply to your comments. I have been busy with many personal matters but...

Well this problem turned out to be easier than the package variables problem; at least for me.

The thing I couldn't find is that I had to create an import column...

Thank you very much for pointing out what I could not see nor understand!

I have worked with DTS so much that I forgot SSIS is not DTS. In a...

I doubt I have the complete answer for you but believe that you'll have your best luck in creating the column you say doesn't exist by using the data flow...

Well, I am now able to use Package variables in an Execute SQL Task. I learned that I don't need to set the resultset to use values from a...

I removed everything from the Parameter Mapping.

Under General I switched the ResultSet setting from None to Single Row.

That made me feel dumb when that was all I needed so that...

I tried clicking on that link and the page doesn't load for me.

Here is the query I put in the first SQL Task that I mentioned in my first post....

Well I guess here I am answering my own question.

I read in the SQL Tutorial that the execution sequence for mulitple data flows (I previously called it data...

Thank you both.  I haven't worried much about my title because I didn't think it would matter but since I never spoke with anyone else I just didn't know how...

We have had DTS packages in production for 3 or more years that regularly execute the same DTS package and send in global variables to change which server the connections...

New file names are fine it will get the date right the first time.  But I will get the same file name every day with different data and I need...

I have found a way to view the file names. 

The problem now is that for some reason the creationdate is storing previous values instead of clearing them out.

For example...