|
Hi,
Is it possible to compare two excel sheets ie column names in each sheet by using SSIS package?
Need some urls or some examples
Notify user when there is no matching in column names and exlude that file and pick the next excel file placed in server.mappath.
Thanks
Guhananth.S
|
|
|
|
|
Stop posting and read the guidelines
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi,
In SSIS is possible to check
a) Excel template check ie comparing the column names of each sheet with another standard sheet
The SSIS must check if the uploaded excel is matching the standard excel.
b)The SSIS must pick any excel sheet placed in server.mappath ie able to pick any excel file names.
c)Also the SSIS must read the excel sheets and port data to respective tables.
How to do?
How to do these tasks in SSIS package.
If we deploy this,will the package check excek sheet format and notify admin,if any things goes wrong.
Thanks
S.Guhananth
|
|
|
|
|
|
Please read the guidelines[^] and don't use capitals for your entire message. Also please clarify what your quesstion has to do with the .NET framework.
It's time for a new signature.
|
|
|
|
|
HI,
How to create SSIS package in VS 2010
which option we need to choose
guhananth.S
|
|
|
|
|
You cannot create an SSIS package in VS 2010. The installation of SQL Server 2008 can install the Business Intelligence Development Studio (BIDS) which is a variant of VS 2008. BIDS provides the templates and capability of creating and deploying SSIS packages
|
|
|
|
|
I'm not sure this is the right place to ask this question. We are currently using Visual Source Safe and VS 2002/2003. We are looking to upgrade to Visual Studio 2010. I need to know if Visual Source Safe will work with VS 2010 or do I need to move to Team Foundation Server? And does Team Foundation Server come with VS 2010? And what are the pros and cons of using one over the other?
And before any one suggest a different version control software package, that is not an option. I work for a university and with our licensing agreement I have to go with one or the other.
Thanks,
Carolyn
If you can’t have fun at work, then why go to work?
|
|
|
|
|
VS2010 will work with VSS. TFS does not come with Visual Studio, it is a separate server that VS connects to via the Team Explorer.
As for the pros and cons of each, that would entail a long and, for some, hated debate. There is plenty of information available that describes TFS. Essentially though if you have a small team of developers, three or less, then VSS will probably work best for you. However, if you want to including continuous integration builds, work item tracking, etc. then TFS is the tool.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Will VSS need to be upgraded? The version is probably as old as my VS. This was the setup when I came on board a couple of years ago and I'm just now getting the okay to upgrade so I want to get everything that possibly needs done at once. It'll probably be another six or eight years before they upgrade again. This department is not very good about being on the cuttng edge or even at the front of the pack.
Thanks for replying.
Carolyn
If you can’t have fun at work, then why go to work?
|
|
|
|
|
VSS should be fine, it hasn't been updated in years anyway. Given that it may be a very long time until you have budget to upgrade again I would certainly go with TFS. In another few years VSS probably won't be supported or won't meet your needs. TFS is very extensible so it can keep pace with you. Also, there are feature that you will probably find very useful, if not now, certainly in the future.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
I'll take a further look as TFS then. Thank you for your assistance.
Carolyn
If you can’t have fun at work, then why go to work?
|
|
|
|
|
|
Cruise Control works and nAnt work with VSS.
|
|
|
|
|
Get TFS. I agree it's overkill for small teams, but given your microsoft only constraint and the fact that VSS is slated to be obsolete in 2011, you might as well bite the bullet and get TFS. I admit, it's not the easiest beast to learn (especially coming from SVN), but if schedule 2 weeks for learning as part of the upgrade, you'll become a master.
|
|
|
|
|
PMFBI but I can offer some thoughts as one who manages a small development team, and has used TFS and VSS for several years. We use VS2008 Team System for developing and maintaining a fairly large project (>1million lines of C# code) and VSS for maintaining 'legacy' projects, because that's where they started off.
TFS brings much more than source control. On that feature alone it is far superior to VSS (I can't speak for CVS, SVN etc because I haven't used them). In my experience VSS is fine for smaller projects, and where you can ensure that only one developer at a time ever works on a file. With a big project that is often inconvenient and not easy to regulate (and why should you have to?) and TFS's far superior checkin/merge facility helps manage that relatively safely. Given the chance, of the two I would use TFS source control for any non-trivial project employing more than one developer.
TFS also brings programmed testing (MSTest unit testing and we also use Selenium), test code-coverage, integrated bug and task tracking, integration with Sharepoint for project documentation control and publishing, and the biggie for me is automated builds. It took us a while to get to where we are today, but I wouldn't be without our CI and nightly build/test/document process. Several times a day and every morning I get an email confirming that all is well, or early warning that something has unexpectedly broken. It's not perfect because you can never have enough tests, but I sleep much better at night as a result.
That is not to say that TFS and VS20008 are without their problems. Check-in merges (and branch merges) can get confused and you have to keep your eye on the ball when you do it, but you do get the option to select individual differences if you want complete control. I have found that frequent 'gets' to keep the local copy up to date together with frequent check-ins of changes is a good way to proceed with multiple developers on the project. In other words don't let server and local code drift too far apart, to keep the risk small. The bug/task tracking facilities could be usefully improved (reporting, especially, is a bit clunky - was it designed by the office junior?). VS2008 itself struggles with largish applications and can often 'lose' the various tools such as call-stack, watch windows etc, which for no apparent reason will be blank panes. Frequent restarts of VS2008 are essential, we find, to correct this. It seems to be a memory thing, and we are at the 4Gb limit already on our workstations, with dual core processors. In this respect it's a typical MS beast, sad to say.
TFS lacks the ability to insert version history into the source code in the way that VSS can, but frankly, I've never missed that and find the code is neater without endless pages of check-in history comments. The separate check-in history viewer that VS2008 makes available seems, to me, to be quite elegant, especially as it is integrated with changesets so you can easily see and view all the changes that were made, as a group, and you can do this from a bug report too, drill down and see all the code changes that relate to that particular fix. Neat.
TFS itself can be very slow at times - again for no apparent reason, even though we have a dedicated server which is, in network terms, practically in the same room. Some or all of these shortcomings may have been addressed in VS2010 Team System - upgrading isn't an option for us, given the huge cost, so I haven't bothered investigating.
But for all that I would say it's much superior to VSS for source control, and brings a lot of extras that, once you have them, you would probably never wish to be without.
I have to say I find it sad that your university is restricting you to proprietary software (or so your remarks suggest). You'd think they would be gagging to save money wherever they can. Have the suits truly taken over the asylum?
HTH
Neil
(Disclaimer: this was written in my personal capacity and does not necessarily reflect the views of my employers)
|
|
|
|
|
I'd strongly urge looking at other (often free) alternatives like Subversion.
Subversion has strong support in Windows - Tortoise SVN provides explorer shell integration and Ankh SVN provides Visual Studio integration.
|
|
|
|
|
I'll second the vote for SVN. My limited exposure to TFS is that it attempts to incorporate source control in the karma of the large team. If you only have a few developers, it's serious overkill.
<ducking> - am I wrong?
Read about VSS' limitations. Sometimes they won't hurt you.
Charlie Gilley
<italic>You're going to tell me what I want to know, or I'm going to beat you to death in your own house.
"Where liberty dwells, there is my country." B. Franklin, 1783
|
|
|
|
|
Perhaps you didn't read the OP closely enough,
"And before any one suggest a different version control software package, that is not an option."
Your answer is a useless waste of time.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Your answer is deep seated bile and you deserve the dark fate that awaits all those who refuse logical thought as the basis of decisions with long term consequences.
|
|
|
|
|
But SVN is free. I can't see how any kind of licensing agreement could forbid you from using free stuff.
|
|
|
|
|
Free doesn't mean it won't cost. Some organizations don't allow these tools because of the maintenance and support headaches that come along with them, often a dedicated resource is maintained to support these "free" tools. Some don't allow open source because of security restrictions. Further still some organizations are locked into an agreement where by they get discounts on other products for using another from that vendor.
Your comment is very naive. Free isn't always better or the answer to everything.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Your comment is a strawman. I never said it was better or the answer to everything. I am just suggesting that it is probably not against any license agreements to use SVN. And if it is, I would seriously reconsider said agreement.
I don't know anything about the security restrictions at the OP's university. I do know that SVN is approved for use where I work, which has an extremely restrictive security policy (Government related). I thought your original flaming comment and a 1 vote was quite the over-reaction for what seemed to be a legitimate attempt to help. In the context of the OP's post (selective quoting notwithstanding), sugesting an open source, free alternative wasn't a "useless waste of time".
I have used VSS and SVN. I like them both and find they have very similar features.
|
|
|
|
|
Rick Shaub wrote: I am just suggesting that it is probably not against any license agreements to use SVN
Of course using open source is not against any license agreement, it would be illegal. However, vendors do push for exclusive contracts that prohibit the use of other tools. You again appear naive in relation to such matters.
Rick Shaub wrote: I don't know anything about the security restrictions at the OP's university.
Then you really can't comment and a reference to your organization is an irrelevant attempt at self-importance.
Rick Shaub wrote: sugesting an open source, free alternative wasn't a "useless waste of time".
When the OP expressly stated using another tool was out of the question, then yes, suggesting one is a waste of time. Since the response did not provide any useful information and did not comply with the OP's request is was a bad answer and the vote is justified.
Thanks for playing. Run along now.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|