This post is in the wrong forum. It should be in the T-SQL Forum, not SSIS. Ask the moderator to move it.

Is this a homework assignment?

Who created the package? What permissions did they save the package with?

It sounds like access to the package itself is restricted to a specific Username / password.

Matt,

Just found a case in code I'm doing right now that failed the check because I didn't put the conditional check field in the GROUP BY.

Create Table #Detail_REIFeed (DetREIFeedID int...

In today's economy? @=)

Actually, though, for those of you who haven't joined PASS or LinkedIn, I've been seeing a lot of job postings coming through that group on LinkedIn. None...

Prakash, look at the Summary.txt error more closely. It says your versions are mismatched. The service pack won't work if your editions are different on the cluster nodes. An example...

Please post the full text of the error. We need it in order to advise you further.

The information we posted previously should be all you need for a successful install....

Matt,

I've actually had script syntax check failures because I didn't put a field in my CASE statement in my GROUP BY. That's how I found out I needed it.

To all who have added to this post asking for assistance, please see my previous post. In order to help you, we need more information on what you have and...

I know nothing about Sybase, but... Does Sybase even use owners/schemas the same way SQL does? Does "dbo" mean anything to Sybase at all?

I was, quite a while back, but the problem seemed to fix itself.

What exactly is or is not going on? Tell us step by step what you're doing and where...

Now I feel silly. @=)

I went back through my most recent examples and found I'd re-written my code to use nested sub-queries because our BU decided they wanted different values,...

Ahh. I did not realize this was a homework assignment. That changes things, unfortunately. We don't answer homework assignments or interview questions on this board.

What I can do is give...

Okay, let's start with the first question.

What do you want to do (in English) with the results. Forget about your original post. What is the intent of gathering this...

I have to agree with Chris. I really don't think that query will get you the results you want.

But you'd have to post sample data and expected results for us...