Can't Excute SSIS package

So everything was working great. Now I have a few problems. The little play button is no longer available for me to puch and when I try a right click execute package a get a "Unexpected internal error: Invalid state for operation. (Microsoft Visual Studio)". Does anyone know how to fix this? Also when I try and copy tasks from within my package I get a "An error occurred while objects were being copied. SSIS Designer could not serialize the SSIS runtime objects. (Microsoft Visual Studio)"
followed by "Could not copy object 'package name' to the clipboard.
(Microsoft.DataTransformationServices.Design)" and then "Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)"

Does anyone what might be wrong

Thanks in advance

good news is I have the same problem, bad news is I don't know why :s

If that can help, the details are

Unexpected internal error: Invalid state for operation. (Microsoft Visual Studio)

Emplacement du programme :

at Microsoft.DataWarehouse.ProgrammingByContract.State.NullCheck(Object obj)
at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, DataWarehouseProjectManager manager, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DtsPackagesFolderProjectFeature.ExecuteTaskOrPackage(ProjectItem prjItem, String taskPath)

|||This seems to be a VS problem. I reinstalled Visual Studio and that fixed the problem. Well... at least it works now ;)
|||Yeah, my machine ran automatic updates and all of a sudden it came right.

Can't Excute SSIS package

So everything was working great. Now I have a few problems. The little play button is no longer available for me to puch and when I try a right click execute package a get a "Unexpected internal error: Invalid state for operation. (Microsoft Visual Studio)". Does anyone know how to fix this? Also when I try and copy tasks from within my package I get a "An error occurred while objects were being copied. SSIS Designer could not serialize the SSIS runtime objects. (Microsoft Visual Studio)"
followed by "Could not copy object 'package name' to the clipboard.
(Microsoft.DataTransformationServices.Design)" and then "Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)"

Does anyone what might be wrong

Thanks in advance

good news is I have the same problem, bad news is I don't know why :s

If that can help, the details are

Unexpected internal error: Invalid state for operation. (Microsoft Visual Studio)

Emplacement du programme :

at Microsoft.DataWarehouse.ProgrammingByContract.State.NullCheck(Object obj)
at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, DataWarehouseProjectManager manager, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DtsPackagesFolderProjectFeature.ExecuteTaskOrPackage(ProjectItem prjItem, String taskPath)|||This seems to be a VS problem. I reinstalled Visual Studio and that fixed the problem. Well... at least it works now ;)|||Yeah, my machine ran automatic updates and all of a sudden it came right.

Can't connect to the database using c# express and SQL 2005 Express

Hi

I'm trying to connect to the northwind database thats available online using c# and SQL 2005, both express editions. i used the following command

sqlcmd -S yourServer\SQLExpress -E -iinstnwnd.sql

and it connects to the northwind database. but when it comes to the part where i have to select the data source, there are only 2 available - microsoft access database file, microsoft SQL server database file. but according to the microsoft books that i'm following, there should also be a "micosoft SQL server" in the data source list. because of this i cant connect to the database.

Please help...

thank you

Please verify that you have SQL Server Installed, and it is a running service.

Go to [Control Panel], [Administrative Tools], [Services]

Look for a SQL Server service -most likely MSSQL$SQLEXPRESS

|||

hi,

all the Express version of Visual Studio only allow connections to SQL Server databases in User Instance scenario.. this is true for the VS wizards only, where you can connect to "traditional" SQL Server instance's databases via code..

regards

|||

thanks a lot guys

Can't connect to SQL Server 2005 Express from another machine

I know there have been many posts made on this subject; however, despite the resources available, I have not been able to get this to work! I've spent time working on this here and there over the last couple of months only resulting in frustration. I am finally posting to solicit help for my situation to figure out what is wrong with my SQL Server or firewall configuration.

Two machines connected to a router, one wireless, one wired. Both have SQL Server Express and the Management Studio tools installed. From either machine I can connect to its local SQL Server Express instance.

I have enabled Shared Memory, Named Pipes, TCP/IP, and VIA in the SQL Server Configuration Manager. (BTW what is VIA?)

I have added sqlsrvr.exe and sqlbrowser.exe to my Windows Firewall exceptions. I have tried disabling Windows Firewall. One of the machines is configured as DMZ in the router configuration.

Please, someone offer up some brilliant diagnostic steps I am missing to expose what is wrong in my setup and make this work... Thank you!

BTW, here is the error message. You can see why, in light of what I mentioned above, this error message is infuriating to me by now... !

Cannot connect to \\remotemachine\sqlexpress.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 5 - Invalid parameter(s) found) (Microsoft SQL Server, Error: 87)

HResult 0x57, Level 16, State 1
Named Pipes Provider: Invalid parameter(s) found [87].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

|||

Can you connect to the system by configuring an ODBC Connection from the ODBC Manager in the control panel. Doing this will help to verify where the problem is... if it goes through there is a problem in the way that you app is connecting to the database.

I see that you are connecting by names pipes... when trying the connection try by using tcpip to connect.

|||

Thanks for the response. I get the same results from the ODBC Manager as I do from the Management Studio, command line, or from an application. Can't connect, same error message.

I can't believe I forgot to mention this in my original post, but even when I try to connect to the local SQL Server instance using it's IP address 192.168.0.98 instead of 127.0.0.1... I get the error message above. Hope this sparks some ideas out there. Thanks!

|||Did you check the surface area configuration? By default, SQL Server 2005 (even if it's just express edition) is secured so you need to configure access.|||

bass_player wrote:

Did you check the surface area configuration? By default, SQL Server 2005 (even if it's just express edition) is secured so you need to configure access.

The surface area configuration shows that it is configured for local and remote connections using both TCP/IP and named pipes. Thanks though. I am baffled.

|||

Maybe this has something to do with it?

Under SQL Server Configuration Manager TCP/IP Properties, it shows IP1, IP2, IP3 and IPAll. IP3 is an old IP address from when the machine was configured to use DHCP (can this entry be deleted somehow?). IP2 is 127.0.0.1, which I can connect on. IP1 is 192.168.0.98 which I want to connect with. IP1's "Active" property seems to keep getting set to "No", even after I set it to "Yes" and restart SQL Server. What do you think about this?

|||

I connected. I am an idiot.

Once I tried with the correct freakin' IP address AND explicitly with the port, I can connect.

It's 192.168.1.98 not 192.168.0.98. That entry in the TCP/IP Properties (which was 0) was faking me out.

Woohoo! :)

Sorry folks. Thanks for the responses.

Cant connect to sql 2000 from client with all field available i.e server ip and port

cant connect to sql server 2000 from c# 2003

Hi,

Could you please post more information on the specific error and conditions? Please take a look at the following guideline:

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

In addition, how are you providing the IP address and Port? As per Books Online the format should be:

tcp:<IP Address>[\instancename],<port>

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.