Cant find installer

I'm trying my first install of MSDE 2000 and having some
difficulty. I downloaded the package, then extracted it.
Then read the entire readme telling me all the
requirements and such. I then opened a console window,
and tried to install it. I made my changes to my .ini
file and referenced that on the command line. I'm
getting an error message however that says this. "The
installation package could not be opened. Verify that
the package exists and that you can access it, or contact
the application vendor to verify that this is a valid
Windows installer pakcage".
I went to the knowledge base and the only thing I could
find as a possible problem was that I have SQL server
running all 16 instances on my machine, but this is my
first install ever so there's no way that I have any
other instances running. Please help!
"Culbert" <anonymous@.discussions.microsoft.com> wrote in message
news:7d1301c4773e$0d033c10$a301280a@.phx.gbl...
> I'm trying my first install of MSDE 2000 and having some
> difficulty. I downloaded the package, then extracted it.
> Then read the entire readme telling me all the
> requirements and such. I then opened a console window,
> and tried to install it. I made my changes to my .ini
> file and referenced that on the command line. I'm
> getting an error message however that says this. "The
> installation package could not be opened. Verify that
> the package exists and that you can access it, or contact
> the application vendor to verify that this is a valid
> Windows installer pakcage".
> I went to the knowledge base and the only thing I could
> find as a possible problem was that I have SQL server
> running all 16 instances on my machine, but this is my
> first install ever so there's no way that I have any
> other instances running. Please help!
This may be belaboring the obvious, but you did navigate to the directory
where MSDE was extracted before issuing the install command (or, include the
fully qualified path to the install file in the command), correct?
Peter [MVP Visual Developer]
Jack of all trades, master of none.
|||
>--Original Message--
>"Culbert" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:7d1301c4773e$0d033c10$a301280a@.phx.gbl...
some[vbcol=seagreen]
it.[vbcol=seagreen]
contact
>This may be belaboring the obvious, but you did navigate
to the directory
>where MSDE was extracted before issuing the install
command (or, include the
>fully qualified path to the install file in the
command), correct?
>--
>Peter [MVP Visual Developer]
>Jack of all trades, master of none.
>
>.
>
Thank you for the reply. I figured it out, but what it
was I never though of. I downloaded a corrupt .exe
file. It was the same size, but when I re-downloaded it,
it will still the same size except it had WAY more files
this time after extracting.
Thanks!
|||"Culbert" <anonymous@.discussions.microsoft.com> wrote in message
news:9e0501c47907$84099910$a401280a@.phx.gbl...
> Thank you for the reply. I figured it out, but what it
> was I never though of. I downloaded a corrupt .exe
> file. It was the same size, but when I re-downloaded it,
> it will still the same size except it had WAY more files
> this time after extracting.
> Thanks!
Glad you got it worked out, and thank you for posting the resolution!
Peter [MVP Visual Developer]
Jack of all trades, master of none.
sql

can't execute tasks after moving .dtsx to new server

Hello.

I have two servers, A for dev and B for production.

On server A I developed a project containing a SSIS package using SQL Server business intelligence development studio. The package runs fine from the BIDS and also when I save it to SQLServer itself and run it as a scheduled job using the SQLServer Agent.

All ready to roll out to Server B I thought, so I then saved the .dtsx file to a shared network drive.

On Server B, I created a empty project with the same name as it had on Server A. I then imported the .dtsx file into the project using project > add existing item.

The package appeared to import ok but I now cannot execute any of the data flow tasks in isolation. If I right click on them, there is no option to 'execute task' as there should be, it is not greyed out, it's not there at all.

Also, if I attempt to debug the whole package I get a message saying 'This document is opened by another project'.

Can anyone help with this as my deployment to live isn't going very well to say the least!

Both server A + B are 32-bit 2005 std edition SP1 on W2003 Server std edition SP1.

Thanks.

bobbins wrote:

Hello.

I have two servers, A for dev and B for production.

On server A I developed a project containing a SSIS package using SQL Server business intelligence development studio. The package runs fine from the BIDS and also when I save it to SQLServer itself and run it as a scheduled job using the SQLServer Agent.

All ready to roll out to Server B I thought, so I then saved the .dtsx file to a shared network drive.

On Server B, I created a empty project with the same name as it had on Server A. I then imported the .dtsx file into the project using project > add existing item.

The package appeared to import ok but I now cannot execute any of the data flow tasks in isolation. If I right click on them, there is no option to 'execute task' as there should be, it is not greyed out, it's not there at all.

Also, if I attempt to debug the whole package I get a message saying 'This document is opened by another project'.

Can anyone help with this as my deployment to live isn't going very well to say the least!

Both server A + B are 32-bit 2005 std edition SP1 on W2003 Server std edition SP1.

Thanks.

The easiest way to redeploy SSIS Packages to a different server is to use the Deployment Utility: http://msdn2.microsoft.com/en-us/library/ms141190.aspx|||

Hi bobbins,

Thoughts / suggestions:

The 'document is opened by another project' error is interesting. First, make sure Business Intelligence Development Studio(BIDS) is shut down on your first server. Instead of creating a new empty project and importing the package, try copying the entire project folder to your shared drive and opening it from the BIDS on your second server. This sounds more like a file locking issue to me.

Hope this helps,

Andy

|||

Thanks for the replies.

I copied the entire project folder to the new server and it is ok. The only issue that arises is that some of the connection managers lose their login information, these are ADO.NET ODBC connections to an Ingres database, so I suspect this is just normal behaviour anyway.

Thanks again.

Can't Execute Package from BIDS Solution Explorer Post SP2 Install

Yesterday, SQL Server 2005 SP2 was installed on our DEV Server (Windows 2003 SP1 x86) and now I cannot right-click a package in the Solutions Explorer window in BIDS and Execute Package. When I do, I get the following error

===================================

Object reference not set to an instance of an object. (Microsoft Visual Studio)

Program Location:

at Microsoft.DataTransformationServices.Project.DtsPackagesFolderProjectFeature.ExecuteTaskOrPackage(ProjectItem prjItem, String taskPath)

I know I could do this yesterday morning pre SP2. I've attempted this with a couple of different packages and solutions, so it is probably not a corrupt package (unless now they are all corrupt). I can execute in debug mode if I open the package first and then hit Start Debugging. However this is not always an optimal solution because I sometimes have many connected packages and sometimes what gets executed is not what is expected.

Your thoughts would be appreciated.

I'm having the identical problem. If I create a new package, it will work for a short period of time. I didn't measure the time precisely, but it is within 15 minutes and an hour or so. I appreciate your run-in-debug solution, but it is still not a clean fix.sql

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 Design a Script

I've placed a Script Task in a package, but the "Design Script..." button only closes the dialog and nothing happens. I've tried a Script Task in an empty package, too.

This is a vanilla 2003 virtual PC. No previous beta/CTP versions installed. RTM bits of SQL 2005 and VS.NET 2005 Pro. I can edit macros in VS.NET, so I'm sure the VSA environment is around. No event log entries. Typically run as non-admin, but tried as admin, too.

Anyone ever seen this?

Yeah, it happens sometimes. Reboot your machine.

can't decrypy the child package?

I had a child package AAA

The ProtectLevel of AAA is "EncryptAllWithPassword" and PackagePassword is "passtest"

now I put a Execute Package Task on Control Flow TAB of Package BBB

in this task I want to Execute package AAA,after set Password "passtest" of Execute Package Task ,I execute package in command line

DTExec.exe /F BBB.dtsx

I get error message,

can't decrypt package AAA

Where can I set the PackagePassword of AAA in Execute Package Task.

i haven't attempted to do this, but have you tried using a parent variable? http://msdn2.microsoft.com/en-us/library/ms345179.aspx|||

I didn't use any parent variable in child package,

the password protected child package can't be executed in parent package,how can I set the child's password in parent package?

|||

ycjj wrote:

I didn't use any parent variable in child package,

the password protected child package can't be executed in parent package,how can I set the child's password in parent package?

i understand that you aren't now using a parent variable. i am suggesting that you try using a parent variable and set it to the the child package password. then you should be able to use this variable when the parent package executes the child package.|||

thank you for the answer.

I will try it.

|||

thank you!

you are right, it works after I set the parent variable

Can't debug Script tasks

After upgrading to CTP16 (Sept.), I can't seem to debug my script tasks. Everytime I run the package with a breakpoint in script task I get following error: "SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for the inconvenience. "

If I remove the breakpoint the scrip task runs successfully. So my question is how do I debug a script task with CTP 16?
As per my knowledge, there was no debugging support for script component.
So, you are left with few options like MessageBox.Show or rowcount etc.

Don't know if debugging support is there in sept/nov versions.

hth,
Nitesh|||No he said script task not script component and the script task does indeed support debugging.

As for the problem, do you get any error information in the error pane or progress pane. Do you get a minidump in 90\shared\ErrorDumps?

Thanks,
Matt|||Thank you for you reply Matt. No. I do not get any error info in error pane, output windows, or errordumps folder. I just get a dialog box with the error message listed above.

My Script task is set to Precompile and all the other properties are deafulted. I was under the impression that I would only get the error when there was syntax or logic problem, however, that's not true since I can take the breakpoint out and the script runs successfully.|||

If you set precompile to false then open and save the script does that make the breakpoints work or do you still get the same problem?

Thanks,
Matt

|||I have tried setting the precompile to false and it does break. However, it's not consistant. I guess CTP16 still has debugger issues hope they fix it in sql 2005 rel.

Can't Debug a script task

After upgrading to CTP16 (Sept.), I can't seem to debug my script task. Everytime I run the package with a breakpoint in script task I get following error: "SQL Server Integration Services Script Task has encountered a problem and needs to close. We are sorry for the inconvenience. "

If I remove the breakpoint the scrip task runs successfully. So my question is how do I debug a script task with CTP 16?

This should be posted to SQL Server Integration Services. Please acknowledge and I'll move the thread to the appropriate group.

Can't create new SSIS package in VS 05

Is there anyone out there that can help me - please! I'm about to put my head through a wall.

I used to be able to create SSIS packages in VS 05. It's been a while since I've done it, but when I went in the other day, it would let me - all I can do is get errors. It tells me an "error prevented the view from loading" when it opens in control flow (blank packages and ones I created before all this started) and I get this error :

"Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (System.Windows.Forms)"

If I go over to the Data Flow tab and there are no errors until I click "Click here to add a new Data Flow task", then I get this :

"Object reference not set to an instance of an object. (Microsoft.DataTransformationServices.Design)"

So... here's what I've tried.

Uninstalled and reinstalled VS 05 and SP1 (this was before I realized the problem was with SQL).

Uninstalled and reinstalled Office 2003 Web Tools.

Made sure all the MSXMLs were registered.

Uninstalled and reinstalled all SQL Servers and Tools/Components.

Made sure all SQL Services were running under Local Account

Made sure Integrated Services service was running.

Applied all SQL patches.

I cannot get this to work and I need to be able to create packages. The only other step I can think of is wiping my computer and I don't want to have to do that.

Please please can anyone help me? I've been scouring the internet and working on this for 1 day and 1/2.

Miraculously - it's started working again. All I've done since then is go to the MS Update website and tried to add SQL 2005 SP2 again. It failed again, but this time when I opened my SSIS project, it opened ok.

I also just realized that I disabled the antivirus on my computer in an attempt to upgrade to SP2 again (although I haven't tried to upgrade the second time), but the antivirus is still off - When I reboot, I'll try to open it again - of it fails it must be the antivirus.

|||

Well, it wasn't the antivirus, because I've rebooted and it's still working - with the antivirus running. So if anyone else is running into this issue and is reading this thread for help - sorry - don't know what to tell you or how it fixed itself.

All I know is - you live by Microsoft, you die by Microsoft.

Can''t create a SQL Server package configuration

I've created the table [SSIS Configurations] and have added a dummy row to this with "XYZ" in the filter name.

When I use the package configuration wizard I can see that offered as a filter - so I know my connection is seeing the server ok.

The problem I get is when I get through to "Finish" and insert the configuration to the table - I get this error message and I can't find any help on it:

Cannot insert configuration information into the configuration table. (Microsoft.DataTransformationServices.Wizards)

Could not complete wizard actions.

I'm connecting as system administrator and am just foxed as to why it won't insert ... Anyone got any pointers?

Many thanks

Matt

have you used SQL Profiler to watch what is being sent to the server?|||

*bump*

I am getting this error too.

Any ideas? Nothing odd in profiler.

|||

that is weird. If you are choosing a row that already exists in the configuration table; I think the wizard prompts you whether you wan to re-use the exiting row or not...do you see that prompt? what are you selecting?

|||

I've resolved my issue.

It was to do with a property value (an SQL string) that was too long to fit in the default configuration table data column (254 characters.)

I have moved to using an external xml file instead for the SQL statements.

I also tried making the column larger, but ultimately I think the more appropriate option for us is going to be external xml files.

Can't create a SQL Server package configuration

I've created the table [SSIS Configurations] and have added a dummy row to this with "XYZ" in the filter name.

When I use the package configuration wizard I can see that offered as a filter - so I know my connection is seeing the server ok.

The problem I get is when I get through to "Finish" and insert the configuration to the table - I get this error message and I can't find any help on it:

Cannot insert configuration information into the configuration table. (Microsoft.DataTransformationServices.Wizards)

Could not complete wizard actions.

I'm connecting as system administrator and am just foxed as to why it won't insert ... Anyone got any pointers?

Many thanks

Matt

have you used SQL Profiler to watch what is being sent to the server?|||

*bump*

I am getting this error too.

Any ideas? Nothing odd in profiler.

|||

that is weird. If you are choosing a row that already exists in the configuration table; I think the wizard prompts you whether you wan to re-use the exiting row or not...do you see that prompt? what are you selecting?

|||

I've resolved my issue.

It was to do with a property value (an SQL string) that was too long to fit in the default configuration table data column (254 characters.)

I have moved to using an external xml file instead for the SQL statements.

I also tried making the column larger, but ultimately I think the more appropriate option for us is going to be external xml files.

Can't create a setup project for project referencing Microsoft.SqlServer.ManagedDTS

I have a very small project written in VB.Net 2005 using the SQL Server 2005 SSiS DTSx package.

I took a SQL Server 2000 dts package and using the SQL Server 3005 legacy tools migrated it so I could still use the package withing SQL 2005 until I can build one using BI/SSIS.

Anyway,I added the reference Microsoft.SqlServer.ManagedDTS so I could then use the Microsoft.SqlServer.Dts.Runtime so I can execute the commands:

Dim oApp As New Application
Dim oPkg As New Package
oPkg = oApp.LoadPackage(g_DTSx_Directory & "AOC copy Generic1 CSV to AOC_verify_file_1.dtsx", Nothing)
Dim oResults As DTSExecResult
oResults = oPkg.Execute

Ok. That works fine. Executes without a hitch. So now I try and create a setup project for this and I use the setup wizard.

During the creation of the setup project I get a message that states:
The following files may have dependencies that cannot be determined automatically. Please confirm that all dependencies have been added to the project.
C:\windows\system32\msxml6.dll

OK. The dll is part of the reference I mentioned above and I have no idea what other dependencies it may have.

How do I find this out?

Has anyone else created a project like this and experenced the same?

I am on a clean build running WinXP Pro with SP2 - VS2005 with SP1 and the SQL Server 2005 tools.

Thank you.

I received the answer to the above problem here:

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

Can't create a setup project for project referencing Microsoft.SqlServer.ManagedDTS

I have a very small project written in VB.Net 2005 using the SQL Server 2005 SSiS DTSx package.

I took a SQL Server 2000 dts package and using the SQL Server 3005 legacy tools migrated it so I could still use the package withing SQL 2005 until I can build one using BI/SSIS.

Anyway,I added the reference Microsoft.SqlServer.ManagedDTS so I could then use the Microsoft.SqlServer.Dts.Runtime so I can execute the commands:

Dim oApp As New Application
Dim oPkg As New Package
oPkg = oApp.LoadPackage(g_DTSx_Directory & "AOC copy Generic1 CSV to AOC_verify_file_1.dtsx", Nothing)
Dim oResults As DTSExecResult
oResults = oPkg.Execute

Ok. That works fine. Executes without a hitch. So now I try and create a setup project for this and I use the setup wizard.

During the creation of the setup project I get a message that states:
The following files may have dependencies that cannot be determined automatically. Please confirm that all dependencies have been added to the project.
C:\windows\system32\msxml6.dll

OK. The dll is part of the reference I mentioned above and I have no idea what other dependencies it may have.

How do I find this out?

Has anyone else created a project like this and experenced the same?

I am on a clean build running WinXP Pro with SP2 - VS2005 with SP1 and the SQL Server 2005 tools.

Thank you.

I received the answer to the above problem here:

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