Keyboard not working (backspace and arrow keys) when viewing 2000 DTS packages from 2005 (ba

I know my problem is not directly associated w/ SSIS, so please forgive the post here. I figured this would be the "most" appropriate place to post this challenge.

We're attempting to edit a 2000 DTS package in Design mode from within the 2005 SQL Management Studio. To do this we downloaded/installed the following packages from the MS download site:

Microsoft SQL Server 2000 DTS Designer Components
Microsoft SQL Server 2005 Backward Compatibility Components

We're able to open the package in design mode from the Management Studio (Server > Management > Legacy > Data Transformation Services > DTS Package Name). But, when the DTS designer is open, the backspace and arrow keys won't respond in the Management Studio. They begin responding when we close the DTS designer. There are no error messages when we close the DTS designer.

Does anyone know of a fix or a workaround? Any help would be greatly appreciated.

Thanks, Mike

Do you have the Logitech MX5000 BlueTooth keyboard/mouse? I encountered this problem just yesterday and assumed it was my bluetooth connection going in and out.

That is very strange...

|||Nope, I have a wired Compaq keyboard. My colleague has the same problem w/ a different brand of wired keyboard.|||If you do a search there are a lot of people that have had problems with this component. It hosed enterprised manager on my machine and one of my co-workers. Even when it installed correctly a bunch of us still got errors opening packages. So far the only solution I've heard is to grin and bear it.|||

Thanks for the feedback, this was identified as a bug and was fixed. The fix will be in the next release after SP1

wenyang

|||

Is this fix out yet?

|||

I saw a reference to this recently which indicated it was fixed in SP2, or the associated feature pack. That is currently released as a CTP, so you may wish to risk it. I cannot find the source niow, which is rather annoying...

Download details: Feature Pack for SQL Server 2005 SP2 CTP
(http://www.microsoft.com/downloads/details.aspx?FamilyID=7A9AD90F-7F95-4369-A206-E84053D63FD3&displaylang=en)

|||

Thanks,

but unfortunately, the same behavior is happening with the CTP version of the dts designer :(

Kerberos delegation don''t work with SSIS ?

Hello,

I have configured Kerberos delegation for several web services. One of the web service calls SSIS packages, but the packages don't run with the expected impersonate user : the package starts with the imporsonate user, but continue with ASPNET user (which is not allowed to execute SSIS and connect to DB).

If the web service is called directly (no delegation), SSIS packages run with the correct user. It looks like than there is an autenthicate issue, but kerberos is configured and web services can run from one to another with the impersonate user. The issue occured only when I call SSIS packages.

Here is a extract of the SSIS log file :

Code Snippet

<dtslog>
<record>
<event>PackageStart</event>
<message>Beginning of package execution.
</message>
<computer>WKS-GE-BRAZILIA</computer>
<operator>WKS-GE-BRAZILIA\Pascal.Brun</operator>
<source>ImportMonthlyCSV</source>
<sourceid>{D053CB99-FDE4-492D-83BC-821E1B34704B}</sourceid>
<executionid>{EA9C1929-4131-4FDD-A6FC-560E01A65536}</executionid>
<starttime>09.08.2007 17:31:02</starttime>
<endtime>09.08.2007 17:31:02</endtime>
<datacode>0</datacode>
<databytes>0x</databytes>
</record>
<record>
<event>OnError</event>
<message>SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Data Warehouse" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
</message>
<computer>WKS-GE-BRAZILIA</computer>
<operator>WKS-GE-BRAZILIA\ASPNET</operator>
<source>Import CSV</source>
<sourceid>{284D3166-F372-4B03-86C1-75A4D8DC9A5C}</sourceid>
<executionid>{EA9C1929-4131-4FDD-A6FC-560E01A65536}</executionid>
<starttime>09.08.2007 17:31:02</starttime>
<endtime>09.08.2007 17:31:02</endtime>
<datacode>-1071611876</datacode>
<databytes>0x</databytes>
</record>
...

Any help is required.

Thanks in advance.

You might take a look at this thread, which discusses the issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1044994&SiteID=1

|||

This post show workarround to this issue. This can help me temporary, but I configured Kerberos delegation on my application. This post explain why SSIS packages call by ASP.Net is considered as double-hop, but double-hop should not be a problem when delegation is enable.

Why Kerberos don't work with SSIS ?

|||

If you take a close look at the thread, you'll see that the problem is that the initial thread does impersonate the account, but subsequent threads that SSIS creates internally do not. That is why it doesn't work.

If you would like to suggest a change in this, you should create a defect/request on connect.microsoft.com.

Keeping SSAS Projects in the dark ?

The feature with SSIS packages to "keep them in the dark" with configurationfiles and the use of variables. How does or does that apply for SSAS projects ?

Since we keep dev, test and production sepperate, the cubes datasource differ according to witch enviroment they are running on. Is there a way to fix this, or what is best practice on this front ?

Whe you talk about "keep them in the dark" are you referring to the following article : http://www.sqlmag.com/Articles/ArticleID/47688/pg/2/2.html ?

I guess this is not widely accepted terminology.

For being able to change some project properties while deploying you can take a look at the Deployment Wizard utility. It gives you abilty to change connection strings during deployment.