thanks so much. Yes, that's the problem! I need to pull into excel and assign columns, rows, and let excel do pivoting on the units by month And...

are you suggesting that instead of Unique Index I make the column a Primary Key? I understand PKs enforce uniqueness and SQL Server will in response automatically create a...

Much gratitude for understanding what I was attempting to say. Difference between physically ordering the query results (ORDER BY) and optimizing (with Index) retrieval of time ranges pertinent to...

I'm viewing this thread to educate myself on how to identify and resolve deadlocking. The links provided are great but for older (2005 and 2008) versions of SQL Server....

Fully Qualified eventually worked. I had to rebuild the package....so I must have had something else wrong as well.

Thanks for standing by. At least I knew it had to be...

Fully Qualified eventually worked. I had to rebuild the package....so I must have had something else wrong as well.

Thanks for standing by. At least I knew it had to be...

Thanks Phil. Yes I have and neither way has it worked. I understand the Fully Qualified pulls the path + filename into the variable, where as just Name...

Actually, that's what I meant. I have nothing in the CollectionString property. I should not have said that I added the variable to the ConnectionString property, rather I put...

Yes, I selected the quote tag when responding, and I guess I should have added more start and end tags for each section I was replying to. ...

I did answer Montana Life's questions. Not like me not to. Oh Oh Phil, Do you need to have your eyes checked? 😛

For now I've removed the EID field...

I installed BIDS 2012 but I think it just integrates Visual Studio 2010 within it's shell, and in my case it detects my 2010 packages but when I try to...

Montana Life (1/11/2014)

---

I tried to replicate the issue as you described and did not have the problem using 2012. Keep identity should be unchecked and is by default. ...

I didn't think about the simple approach. I immediately conjured the problem to involve complex nesting of substring and pathindex functions. Thanks David and Happy New Year!

I too am getting:

Msg 9002, Level 17, State 4, Line 10

The transaction...

Hi, I've attached screen capture.

The only place there are two groupings, one for 2008 and one for 2012, is under Network Configuration, no where else.

Will someone look at the...