excluding a package from the build process

There is some way to exclude a package from the build process of a SSIS project ?

Cosimo

cosimog wrote:

There is some way to exclude a package from the build process of a SSIS project ?

Cosimo

I don't think so. it would be nice though wouldn't it? Try submitting the request at http://connect.microsoft.com/sqlserver/feedback

-Jamie

Exchanging data over the internet

Hi All,
In a couple of weeks, after finishing my current project, I'll start a -for
me- quite challenging project, so I'm already starting to do some research.
Since I had a little bump in with Aaron some time ago, when I asked for an
easiest solution, I'll just ask for some pointers this time ;-)
There are 2 companies involved. One is a school. The other one does the
examination of the school's students. On both ends, the software will be
developed in VB .NET, with -for starters- MSDE as the datastore. When a
student starts a course, his/her data will be entered in the school's
database. This data has to be send to the examination institute. After the
student has taken an exam, the results have to be send back to the school.
On both ends, they need their own database, since only part of the data will
be shared among the companies. As I said, they will both be running MSDE
2000 and they are both connected to the internet through DSL (with fixed
IP-adresses).
All pointers to exchange data this way are welcome. I'm not new to SQL
Server/MSDE, but still bit of a novice. I've read something about the
'famous' port 1433. But as far as I've understood opening that one might not
be a good idea, security-wise. I've also read something about webservices
(or something like that).
I'm quite stuck here. Please help me out a bit.
Thanks,
Willem
I would tier your system and create a .Net web service on both ends to send
and consume data. Creating web services in .Net is rather easy and VS .Net
comes with some sample projects to start from.
Jim
"Willem van den Broek" <willem@.chsd.nl> wrote in message
news:%23qamZc8NEHA.268@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> In a couple of weeks, after finishing my current project, I'll start
a -for
> me- quite challenging project, so I'm already starting to do some
research.
> Since I had a little bump in with Aaron some time ago, when I asked for an
> easiest solution, I'll just ask for some pointers this time ;-)
> There are 2 companies involved. One is a school. The other one does the
> examination of the school's students. On both ends, the software will be
> developed in VB .NET, with -for starters- MSDE as the datastore. When a
> student starts a course, his/her data will be entered in the school's
> database. This data has to be send to the examination institute. After the
> student has taken an exam, the results have to be send back to the school.
> On both ends, they need their own database, since only part of the data
will
> be shared among the companies. As I said, they will both be running MSDE
> 2000 and they are both connected to the internet through DSL (with fixed
> IP-adresses).
> All pointers to exchange data this way are welcome. I'm not new to SQL
> Server/MSDE, but still bit of a novice. I've read something about the
> 'famous' port 1433. But as far as I've understood opening that one might
not
> be a good idea, security-wise. I've also read something about webservices
> (or something like that).
> I'm quite stuck here. Please help me out a bit.
> Thanks,
> Willem
>
|||Thanks Jim. I was already afraid that would be the answer. I was hoping
there would be a solution without having to use IIS...
Willem
"J Young" <thorium48@.hotmail.com> schreef in bericht
news:OK2HMi9NEHA.3012@.tk2msftngp13.phx.gbl...
> I would tier your system and create a .Net web service on both ends to
send[vbcol=seagreen]
> and consume data. Creating web services in .Net is rather easy and VS .Net
> comes with some sample projects to start from.
> Jim
> "Willem van den Broek" <willem@.chsd.nl> wrote in message
> news:%23qamZc8NEHA.268@.TK2MSFTNGP11.phx.gbl...
> a -for
> research.
an[vbcol=seagreen]
the[vbcol=seagreen]
school.[vbcol=seagreen]
> will
> not
webservices
>

Exception Has been thrown by the target of an invocation

Getting this error "Exception Has been thrown by the target of an invocation" when trying to create Integration Services Project. Any ideas what can be wrong?

Thanks.

I am receiving the same issue... were you able to solve this?|||In our case the problem was related to the installation image we used to setup our computers (every PC that used that image had the problem).

Exception Has been thrown by the target of an invocation

Getting this error "Exception Has been thrown by the target of an invocation" when trying to create Integration Services Project. Any ideas what can be wrong?

Thanks.

I am receiving the same issue... were you able to solve this?|||In our case the problem was related to the installation image we used to setup our computers (every PC that used that image had the problem).

Exception Has been thrown by the target of an invocation

Getting this error "Exception Has been thrown by the target of an invocation" when trying to create Integration Services Project. Any ideas what can be wrong?

Thanks.

I am receiving the same issue... were you able to solve this?|||In our case the problem was related to the installation image we used to setup our computers (every PC that used that image had the problem).

Excel to Crystal Report

I wish to create a crystal report from an Excel workbook that contains many sheets. Each sheet contains data regarding a one project each. All sheets are of the same format in displaying data. How do I create a crystal report from this workbook, so that the data in the crystal report is displayed as treeview of which the project data itself can be expanded and minimised? Finally this has to be installed in the client's computer. Should I create an addin? You experts out there, please suggest and help me.

ThanksPlease help. No gurus?|||Create a new Report
When selecting Datasource choose the option Access/Excel
Then Choose Database type as Excel
Then Choose name the Excel file
Do the normal procedure thereafter|||Thanks. I will try that.
Thanks|||Did the prior answer to your question help? It seems that you don't need to go from Crystal to Excel but to format a Crystal report to match an Excel spreadsheet. Is that correct?

I have a similar problem. I am trying to convert to Crystal Reports a very complicated Excel worksheet that integrates with a tool that directly pulls data from an Oracle db. With Excel, they "cherry-pick" which accounts they want on any particular row.

In Crystal, you have some control over placing groups and naming them. This approach may work (Group->specified order) but it would be (1) extremely tedious as there are hundreds of lines, (2) I may exceed its capacity, (3) it would be hard for client to support, and (4) it may not work!

Have you found anything that might help?

Thanks!