.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to run Package (for WSP) without Building First; or, how to Relocate a .wsp file after it is cre

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :SharePoint
I'm attempting to automatically move the .wsp package to a separate deployment folder (like you could with WSPBuilder) after it has been created.  I can't just do a copy after a successful build (in build events) because a normal build does not cause the .wsp to be built.  Also, I've tried calling MSBuild directly in the build events and used the /t:Package call, however this automatically includes a rebuild of the assemblies, so this does not work.  Is there a way to call the /t:Package command but exclude an assembly build?  Any other ways to move around the .wsp file? Thanks.

View Complete Post

More Related Resource Links

.Net Framework zip package file

Has anyone idea about .net package files?? I seriously have no clue about this & have asked to do a POC on this. I am told that this feature has come up along with .Net Framework 3.5 but couldn't find any pointer after googling even. It would be great if somebody can explain this & its usage??

Problems running a bat file within a SSIS package

I have a ssis package which has 2 tasks, first it builds an excel sheet with data on the server from where I am running the ssis pkg and the second task (a sql process task), runs a bat. the bat file that basically copies the  excel sheet created from the first step to another server. Problem is that the ssis pkg runs succesful when i run it from BIDS, bust when I run is as ajon, it gets hung. It completes the first step, it is the sescond step that is get hung. I noticed that when i run from BIDs, it does come up with a window open file - security warning and says the publisher could not be verified, are you sure you want to run this software. why does it do that ??? the file I am asking to run is a .bat file. it should automatically use the cmd.exe app to run the bat file. Please help !!!   Thanks in advance.

if ssis package writes to excel file that might be open by a user

I have written a package that writes to an excel file to a network folder. Eventually this package will run as a job. What is the best way to handle the situation where someone opens the file or inadvertantly leaving it open while the package is running and and stop the package.? No one needs to modify or write anything to this file after it is finished

SSIS package - change Web reference's addres from Configuration file?

Greetings. The SSIS packages provide very nice options to configure them from an XML file, which allows to change credentials, database names etc w/o editing the package. This lets me, say, transfer package from one server to another or from test to production w/o any hassle - just changing the xml. Problem is, i need to acces a web service in my package, and built-in SSIS web service task is useless and just SUCKS. It fails to work even with miscrosoft's own sharepoint web service. So, i have to use scripting task. And scripting task uses "web reference" to access web services, which in turn gives no way to change it's url.  So, if i want to test and then move to production, i'll have to edit my package to change the web reference url from "testserver:5123/mywebservice" to "productionserver:81/webservices/mywebservice". And then change it again to test it again. Etc. Is there a solution to this? A way to programmatically change web reference's url from inside scripting task?

Created Package missing "[Content_Types].xml" file


I am creating a package using "System.IO.Packaging.Package" class.

when does the  "[Content_Types].xml" gets added to the created package. I am missing the xml file in the generated package.

Also in my code I am not closing the package till the end of the application and the xml is missing if the application get crashed in between only. else it is there.


"Failed to save package file" error


I receive the following error while trying to create a new project in BIDS:

"Failed to save package file "C:\Users\<username>\Local Settings\Temp\2\tmpCAD.tmp" with error 0xC020207E "The file name is not valid.  The file name is a device or contains invalid characters"

Environment is:

Windows 2008 Server SP1 (64 bit)

Visual Studio Team System 2008

Any ideas?

SSIS 2K5 - Deploy SSIS Package with C# - Error File cannot be found



I made a installer program in C# that deploy ssis package on a SQL server 2005. I have like 50 package that contain only dataflow to update a datawarehouse and create fact tables.

I made also one package that call all the other packages. When I try to deploy the packages on the SQL server with the command SaveToDtsServer, I receive an error BUT only on the package calling all the other SSIS package ?? All the other SSIS packages are deployed but the package that call other packages failed to deploy. Whats strange is that when I use the domain controler to deploy the package (I use Impersonation in my C# code) its all working fine, but if I use another user (like the computer admin account), I got the error only on the package calling other packages ???

Can anyone help me on that ? I really don't know whats happening ?

The error that i have is : The file can't be found. But like I said, when using the domain controler user for impersonation, its working ???



    imp = new Impersonation(session["DBMASTER"], session["DBMASTER_PWD"]);


While building my excel file, do an ajax call



I'm in trouble here because of a little problem.

In fact, in my MVC project, I have a controller which build a Excel file and the return value is a FileResult.

for now, I'm using this like that :

<form id ="TransacExportForm" method="POST" action="/theproject/thecontroller/theaction" style="display:none;">


With the javascript :


As I expected, after 25 seconds, the browser send the window popup to download the file (which is what I want)

It works perfectly, but it's so long... It's why I would do some ajax calls in order to have a "loading gif", and when the file is "created", the browser send the message to download the file.

I tried a loooot of things (get, ajax, etc...). The file is created but the browser don't send any message to download the file.

If someone could give me an answer, it would be very great :D !

Create Excel file dynamically in SSIS package and fill it by resultset data returned by Stored proce


Hello Every One,

I have a scenario in which i am executing a Stored Procedure which returned a result set.

I want to create a Excel file [name_date_time] dynamically, and fill result set data into Excel file. And then finally sent Excel file to Specific user[Email ID].

Point is that the excel file should have unique name so i want to give name as name_date_time.

So every time when package run new file is created with unique name.


Can any one suggest me who to create Excel file and fill result set data into Excel file.

And then finally send that Excel file ?







Package configuration file with multiple connection strings


I am using the configuration file to read the connection string in the SSIS packages. In one of my packages i have to use two different connection strings. If i specify the second connection string in the config file, then the current package works well but other packages fails during validation saying the second connection manager does not exist in the package. Is it not possible to have multiple connection string in a single config file?

SSIS: Error in the package when the data in the flat file source is modified


Hi All,

I have a package which loads data from a flat file source to an OLEDB destination, which is executed successfully and data is loaded perfectly.

But later when the data in the flat file source is modified i.e. if an extra column gets added to the text file, the package is throwing an error because it is unable to detect the extra added column.

How can i avoid this error??? I need my package to execute successfully ignoring the changes(added columns) happened in the flat file source.

Please provide me wth your suggestions and solutions....

Thanks in Advance!!

can we run .bat file in cab.ddf file of solution package in sharepoint 2010???


can we run .bat file in cab.ddf file of solution package in sharepoint 2010

bcoz i have created 1 batch fiel which create the hierarchy of folders and move all the images to specific folder so if .bat ll run in my solution package then my problem will solve

help me out



SSIS package is not reading from the configuration file in job step configuration tab

Hi everyone,

I have the following question. I have an SSIS package and it has in SSIS in BIDS 'Enable package configuration' and a full path to a file. The packages works ok and reads from this file.

 If I invoke the same package from sql agent as a job step and apply another configuration file in the job step (in tab COnfigurations), the package still uses the one in BIDS. Shouldn't this new config file overwrite the one from BIDS or?

Thank you





I want to import values of current_time, name, and age from the XML file below. Then I will export those values into sql.

by using "xml source" I can recieve values from name and age, but not from current_time.

my question is, how to get

Error creating package - Failed to save package file



I have Windows Server 2008 R2. I had just installed SQL 2008 SP1 Dev Ed. on my box and got an error message when I tried to create a package using the BI IDE. But the project was created regardless without any packages. When I tried to create a new package in the project, I received the same error again. 

Following is the text of the error details:


Error creating package (Microsoft Visual Studio)


Failed to save package file "C:\Users\<UserName>\Local Settings\Temp\2\tmp8C4E.tmp" with error 0xC020207E "The file name is not valid. The file name is a device or contains invalid characters.".

Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events)
   at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.SaveToTempFile(Package package)
   at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.AddPackageToProject(Package package, String itemName)
   at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.CreateAndAddPackageToProject()
   at Microsoft.DataTran

Building a query into a SSIS package


I have a simple package that imports data from an excel file to a 2008 R2 database.

here is a sample of the excel file

54            Siobhan Kennedy               Health

22            Peter OChahan                  Education

31            Ryan Harkins                     Finance


My table in the database looks like this:


CREATE TABLE [dbo].[Employee](

[EmployeeID] [int] NULL,

[FirstName] [nchar](50) NULL,

[LastName] [nchar](50) NULL,

[Department] [nchar](50) NULL)


I want to import the data into the database, splitting the name column into firstname and lastname using the SSIS package.

So far (on the data control tab) I have an 'Excel Source' Box and an 'OLE destination' Box.

I think i need to pick an option from the 'Data Flow Transformations' menu in the toolbox. Is this correct?




How to Create multiple flat file import package?

Hello Everyone,

I am an absolutely beginner to SSIS and need to perform the following task.

  • Need to import Master data from (semi colon) ; delaminated flat files into separate tables in SQL Server
  • Each file will create a separate table in SQL Server
  • While importing I need to perform validation on each file and only extract data that is valid e.g. CNIC column must be numeric and 13 digits long.
  • Any data that is not valid will be sent to a separate table with same TableName_bad suffix
  • After the data is extracted I will extract the details data of only those records that have been extracted in master table before

I know about basic data flow controls etc but I don’t know which control will be better for which task. Please tell me what will be the procedure to fulfill my requirements. I will be extremely thankful.



Syed Afraz Ali


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend