ajagadambe (5/11/2010)

---

Hiya, I had this problem too.

The way I solved it, was by creating a folder called "Desktop" in "C:\Windows\System32\config\systemprofile\" and I was able to run it without any problems.

I...

Thanks for the suggestion... this worked for me 😀

We were trying to figure out access issue but nothing worked before I created the folder in the mentioned location.

I found the solution for this in another blog... Used replace(Param.value, "&[", "%2526[") instead of escape() and it worked 🙂

="void(window.open('"+Variables!ReportServerUrl.Value+"/Pages/ReportViewer.aspx?"+Globals!ReportFolder+"/Test+Report&rs:Command=Render&Param1='" + replace(Fields!Realname.Value, "&[", "%2526[") + "&Param2=" + replace(Fields!Username.Value, "&[", "%2526["),'_blank'))"

When I set "Use Passive Mode" in connection manager, it worked! (but FTP Task is not helpful since it's saying Password is not allowed).

Ian, Thanks for the reply.

I used ID as Key for and it works. But question is, can I use ID for all attributes (First, Last Name, Address etc...) to avoid...

Hi Dave,

Is it a good way to use Unique Id field in Key Column and actual field in Name column to avoid duplicate issue.

For example, I'm facing issue in LastName...

I'm also facing same issue while applying format under NameColumn . It's not allowing to change from WCHAR to Double... Also, if I use #,##0.00 in format string, nothing happens...

Thanks for your response.

I was trying to open the 2005 version package in BIDS 2008. It was throwing following error:

This error can occur when you try to connect to a...

Here's some more info:

Package creation ID : My User Id

OLE DB Source (DB2) : Service Account

OLE DB Dest (SQL) : Win Authentication

Package prot level ...

Elliott,

Just to add on - i'm using a service account which is same across Dev, UAT & PROD. So, it should not matter.

We have resolved the problem :-).

Solution:

We had an user variable to store the SELECT query & used as SQL Command in OLE DB Source.

When we added few more columns, it...

Can someone provide any solution for this?

More info about the server:

~~~~~~~~~~~~~~~~~

Microsoft SQL Server 2005 - 9.00.4220.00 (X64)

Apr 2 2009 18:34:24

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition (64-bit) on Windows...

the protection level is same as mentioned in your post.

We are not using SQL Agent for scheduling the job... an UNIX scheduler is in place.

And, the config file settings are correct. The package works from BIDS - Design mode...

Here's the complete error message for your reference...

*************** Thu 08/12/2010 22:32:44.55 - OK - SSIS package <<package name>> Started ***************

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.4035.00 for 64-bit

Copyright...