This is the connection string

="Data Source=" & Parameters!ServerName.Value & ";initial Catalog=" &Parameters!db.Value

and the starting default values of both these parameters are valid values.

If, by Connection Object, you meant something else...

Nevermind the 100 servers. I am truly not concerned about how many servers can the code connect.

If it works for one, it will work for rest.

The key issue for me...

Attached is the code.

Thanks.

Hello,

Were you able to find a solution to this?

I have the exact same situation but the difference being, my report works in preview but when deployed,the dynamic connection string doesn't...

Ok may be I did not clear the situation enough.

1.The code and the entire report works 100% fine in SSRS preview.

2.Integrated security is working as well since when I try...

Thanks for the reply.

What about the fact that the SSIS package is working fine in the enterprise edition but failing in the standard edition ?

Reason for making a non-clustered unique index is that the source table can have loads of redundant data so I wanted to handle this on a database level instead of...

Alrighttttttttt heres how I got this to work....

In my original query I did a cast(.. as VARCHAR(339). For some reason it might have been throwing some trailing spaces. Casting into...

Ok I replicated exactly what you did but instead of SQLCMD I used OSQL. The result:

1st line :"Single space1111111...till 340th character" --- 339 1s in this line

2nd line :"Single Tab1"...

Unfortunately, I can't post the query since it is a tax related query with certain rules/logics involved.

The query is concatenation of 45 fields whose total width when selected as single...

In my case it is not breaking the data in multiple line. It does shows the 340 characters correctly and in one single line. But on top of that it...

Steve,

Thanks for the prompt reply.

The SQL server agent can't be given access to that DB because the DB should have a limited access and the server (which happens to be...