Error: Could not get a list of SSIS packages from the project.

Hello,

I have a SSIS package and I am trying to build it using devenv.com from command line. It gives me this error:

Error: Could not get a list of SSIS packages from the project.

However if I open the project in Visual Studio it builds properly. In project property I have set CreateDeploymentUtility=true.

This is what I do from command line:

devenv.com MySSIS.sln /Build "Development|Default"

Any idea what I should do ?

Thanks

Deval

Hello,

There is no solution to it as far as I know if we set CreateDeploymentUtility=true. If you uncheck it then it will work fine.

Thanks

Deval

ERROR: A variable may only be added once to either the read lock list or the write lock list.

Hi,
I have set of 2 DTS packages, one of which calls the other by forming a command-line (dtexec) using a Execute Process task.

From the parent package-> Execute Process Task->
dtsexec /F etc... /<pkg variable> = "servername"

Each of the parent and the called package have a variable: "User::DWServerSQLInstance" which is mapped to the SQL server connection manager server name property using an expression. The outer package has the above variable and so does the inner called package (which gets assigned through the command line from the outerpackage call to inner)

I "sometimes" get the following error:

OnError,I4,TESTDOM\Administrator,ACDWAggregation,{A1F8E43F-15F1-4685-8C18-6866AB31E62B},{77B2F3C7-6756-46EB-8C01-D880598FB4B3},5/22/2006 5:10:28 PM,5/22/2006 5:10:28 PM,-1073659822,0x,The variable "User::DWServerSQLInstance" is already on the read list. A variable may only be added once to either the read lock list or the write lock list.

Help would be appreciated!

I have seen other posts on this but, not able to relate the solution to my scenario.

Do you have multiple tasks (in the same package) executing in parallel, and using same variable, e.g. in property mappings?

If yes, I think this problem is fixed by this post-SP1 fixes collection:
http://support.microsoft.com/Default.aspx?id=918222

Alternatively, you may change the package so the tasks are executed sequentially by creating precedence constraints.|||

Hi Brian,
The child Package uses the User Variable: DWSQLInstanceName mentioned above to initialize 4 SQL Server connections (2 OLEDB & 2 ADO .NET) -- Only <<Server Name>> property using expressions.

I also checked that this error seems to be only on Multi-proc machine. Don't get the same on my laptop.

I cannot seralize the tasks since, the error is coming @. package level while evaluating the package expressions (i.e. for the connections) when the package starts.

What is the best way to still use expressions for connection server names but, get around this error?
Is this what is fixed in SP1?

Also, it seems that the packages does not fail when it encounters the error which I am getting. I have MaxErrorCount = 1 for Package. The package goes ahead.

|||I believe the issue with connections sharing the variable is fixed in the commulative hotfix package I've mentioned above. It should be installed on top of SP1: first, install SP1 then install all the component packages from the hotfix package in the order they are listed in the article.

http://www.microsoft.com/downloads/details.aspx?FamilyId=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC
and then
http://support.microsoft.com/Default.aspx?id=918222|||This was indeed a bug and the post SP1 hotfix "fixes" it.

However, you can still create the bug. It's harder but stil there...|||

Thanks Michael and Crispin for the help on this!

I think we will need to upgrade to SP1 and install the Hotfix bundle for SP1. I think this should fix the issue which I am facing i.e. use of same variable for setting connection "Server Name" - Property in the expressions.

Thanks,
Gaurav

Error while executing nested DTS Packages...

Hello
We ran into a peculiar problem. We copied all of our DTS packages
from one server to another server (both of which run SQL 2000 and are
on the same Service Pack 3/3a). When we execute an embedded DTS
package from within anothe DTS package, we get the following error:

Error Title: Server Busy
Error Description: This action cannot be completed because the othe
program is busy. Choose 'Switch To' to activate the busy program and
correct the problem.

Buttons Available: Swith To..., Retry
Buttons Disabled: Cancel

Does any one know about this error and what to do about it?

Thanks
Jagannathan Santhanam (Jags)"Jagannathan Santhanam" <jags_32@.yahoo.com> wrote in message
news:605df08e.0309081332.73615acb@.posting.google.c om...
> Hello
> We ran into a peculiar problem. We copied all of our DTS packages
> from one server to another server (both of which run SQL 2000 and are
> on the same Service Pack 3/3a). When we execute an embedded DTS
> package from within anothe DTS package, we get the following error:
> Error Title: Server Busy
> Error Description: This action cannot be completed because the othe
> program is busy. Choose 'Switch To' to activate the busy program and
> correct the problem.
> Buttons Available: Swith To..., Retry
> Buttons Disabled: Cancel
> Does any one know about this error and what to do about it?
> Thanks
> Jagannathan Santhanam (Jags)

I've no idea what causes the error, but a search on Google found a few
similar cases. They seem to be related to ActiveX DLL problems. That's not
much to go on, but it might be something to investigate:

http://groups.google.com/groups?hl=...ram&sa=N&tab=wg

Simon

Error While DTS Execution from ASP

I ahve created a DTS package & was able to execute it
from backend but while trying to execute DTS Package
created in local Packages in sql client gets error.
Error Number 2147287038T
Error Description :The system cannot find the file
specified.
package Name :FSPETLISASUpload_DevServer1
Code used
set objDTSPackage = Server.CreateObject("DTS.Package")
on error resume next
objDTSPackage.LoadFromSQLServer "Moody", "fspapp", "w4wmm"
,
DTSSQLStgFlag_Default, "", "", "", "FSPETLISASUpload_DevSe
rver1"
Response.Write err.number & err.Description
Thanks in advance
As a test you may want to try the script (change the obvious variables),
contained at the following link:
http://support.microsoft.com/default...b;en-us;252987
Steve
"Aparna" <nandi_aparna@.yahoo.com> wrote in message
news:02d201c49aa1$d1cef530$a401280a@.phx.gbl...
> I ahve created a DTS package & was able to execute it
> from backend but while trying to execute DTS Package
> created in local Packages in sql client gets error.
>
> Error Number 2147287038T
> Error Description :The system cannot find the file
> specified.
> package Name :FSPETLISASUpload_DevServer1
> Code used
> set objDTSPackage = Server.CreateObject("DTS.Package")
> on error resume next
> objDTSPackage.LoadFromSQLServer "Moody", "fspapp", "w4wmm"
> ,
> DTSSQLStgFlag_Default, "", "", "", "FSPETLISASUpload_DevSe
> rver1"
> Response.Write err.number & err.Description
>
> Thanks in advance
>