This is really a question for MS. Will the VS2005 project types for SSIS projects be installable in VS2008.
A lot of work has gone into VS2008 to allow developers to develop .net2.0 - .Net 3.0 applications in the same environment. It would be a same if us data folk have to keep VS2005 around to support SSIS 2005 projects.
Here's hoping
Simon
I installed SQL Server 2008 R2 and Visual Studio 2008. However, after several installations and un-installations. I could no longer use the SSIS to create New Projects. I cleaned out the registry with a Registry cleaner from Wise. I deleted the SQL Server and Visual Studio folders as well.
When I create a New SSIS Project, I immediately get an error as follows:
"Microsoft Visual Studio"
"An error prevented the view from loading."
"Additional information:"
"Specified Module cannot be Found. (Exception from HRESULT: 0x8007007E)"
"(System.Windows.Forms)"
What this means is that I cannot create any new SSIS Projects.
I have visual studio 2005 and sql server 2005 with integration service installed on my machine. Couple of days ago, I installed visual studio 2008 professional. When I go to create SSIS project I dont see it in visual studio 2008. What do I have to do to make it appear in visual studio 2008 so that I can create SSIS projects.
Thanks.
For some reason in a Team Foundation Team Project that has multiple project types (SSRS, SSIS, WebSite, C# Business DLL...), the SSIS project makes itself the startup project to the team project. If I explicitly set another project as the startup project to the team project and then select an SSIS package in the SSIS project in the team project, the SSIS project becomes the startup project automatically.
I am using Visual Studio 2005 SP1.
I have a Visual Studio 2005 solution which contains a Sql Server Integration Services (SSIS) project.
In this solution I have explicitly set a Web application project as startup project, but whenever I edit a DTS package within the SSIS project, VS automatically sets the SSIS project as startup project and the package I edit as startup object.
Needless to say, this may cause some really unwanted incidents when running the solution - thinking that you're about to run the Web application project (that was explicitly set as startup project), but instead, you run the edited package in the SSIS project.
Is there any way to avoid having the SSIS project automatically setting itself as startup project, any workaround here at all? :)
Thanks.
in order to maintain a deployed project into an Integration Services Catalog I'd like to know if it is possible to import it into a new project inside SSDT.
View 5 Replies View RelatedI've got an SSIS solution file with project deployment model in VS 2013 and would like to deploy that to SSISDB on different environments.All these days I followed the regular way to create a project in SSISDB and deploy it to that. Now want to find out if i can automate this process and so got some questions
1. Can we automate the process of creating a project on SSISDB based on our SSIS project name? This will be like when we do a deployment it should check if the project exists or not on SSISDB based on our SSIS project name, if the project exists we just deploy the packages in the project and if the project does not exists in SSISDB it will create that project and deploy the packages.
2. Can we also automate the process of creating environments? In traditional way we manually create the environment variables under environment tab of SSISDB, but can we make that also as part of deployment? Like when we are releasing to Dev server we look if that particular Dev variable exists on that server, if it exists we just update the existing stuff and if it does not exists we just create it.
Hi all
I am working as Production DBA (SLA based),I want Project matrix samples
Could you some body help me by sending Project matrix.
Any advice or Sample appreciated
When trying to use the report editor in VS 2008, I noticed that there is no longer an option to use an XML data source (either a file-based or URL-based source). This is a major omission given that so many services nowadays are exposed via REST-style interfaces.
Please advise if I'm missing something! I'm using the February CTP.
Thanks,
Rick
Same issue in VS 2005. Using a setup project (or ClickOnce) there seems to be a limit to how large a content file can be. I'm cross-posting in setup and ClickOnce, but thought that other SQL CE developers may have had this issue.
---------------------------------------------------------
I cannot find a reference to this in the online help, and find no answer here. I have some SQL CE databases that are marked as 'content' in a project. One is less than a mb, the other is over 600mb. The larger one will always break the setup build if I leave it marked as content. Also will break a 'clickOnce publish' build.
How does one use the MS Visual Studio tools for setup when a file size is too big?
What is the max file size limitation?
I need to deploy with ClickOnce, but find it difficult to determine the directory that my large file will need to be copied to afterwards since a ClickOnce install uses such a confusing path to install to. So, if the workaround is to fire a script post install, it would be a problem to discover the path for that file to be copied to.-----------------------------------------------------------------
I've created a simple application that uses a SQLCE 3.5 database. When I debug it SQLCE 3.5 is deployed to the emulator. However, I made a "smart device cab project" for my application and copied the cab file to my windows mobile 6 device and it does not deploy SQLCE 3.5. I don't see a way to specify the prerequisites of the "smart device cab project" like you can in a normal setup project. How can I get SQLCE 3.5 to deploy with my application...or even just get it on my device? I've tried installing it on my desktop with the device connected via active sync, but it doesn't install on the device like the compact framework did.
View 3 Replies View RelatedDear all,
We started to develop a datawarehouse solution for client back in December 2008 based on SQL 2008.
We are convinced that we can use some of the new feature included in the new version which is the reason we we chossed to go down this path.
Due to the delay of the next version we have some question that I would like to hear you opinion on.
The estimatet "go live" date is during spring (march/april)
Is it wrong to contiue the development on the 2008 version?
We would need to run Release candidate at the customer site until the product is released. Is there any major changes coming up that are already known?
So far in the development we have had no big problems with releasecandidate.
Thank you for you feedback.
I could not find The Reporting Service Project Template with Visual Studio 2008. It was available with Visual Studio 2005.
How i can add the reporting service project into VS2008?
any post will be appreciated.
thanks
I have a solution that contains SQL Server Reporting Services 2005 project. I upgraded the solution to VS 2008. The report project shows that it is not loaded. Trying to load it gives me the error - "cannot be opened because its project type (.rptproj) is not supported by this version of visual studio". Okay, so I do I convert it?!
View 14 Replies View RelatedHi
I want to manage my servers from a central location and have the ability to manage my packges too. Unfortunatley my servers are across domains which means I have to use SQL Server Login, which isn't a bad thing. However for some bizzare reason I can't connect to Integration Services using this method, only windows authentication which is a complete pain in the butt from a management stand point as I have to copy packages to various servers rather than add them from a central point.
Does anyone know if this bug/feature or what ever Microsoft is calling it will be fixed or know of any workarounds.
Thanks
Is there a way to include, edit, and organize the scripts to create functions, stored procedures, and views in an Integration Services project? If not, does anyone have suggestions on how to organize all the code that would surround a SSIS solution?
View 14 Replies View RelatedWhen I connect to an Excel 2007 workbook using the new Microsoft.ACE.Oledb.12.0 provider in SSIS 2005, I notice that any tables that I've created in the worksheet are not recognized in SSIS.
In the OLE DB data source component (using the "Table or View" data access mode) the any table(s) I've created are nowhere to be found in the drop down list. Similarly, when I constuct a simple SQL query on the workbook, such as "SELECT * From MyTable" it returns the error:
Microsoft Office Access Database Engine
Hresult: 0x80004005
Description: "The Microsoft Access database engine could not find the object 'MyTable'. Make sure the object exists and that you spell its name and the path name correctly."
I know I have the name right -- I can use structured references to my named table in the worksheet without any problems.
Does the new ACE provider not support Excel 2007 tables? Am I stuck with using "overlapping" cell references to capture data from tables in my worksheet?
Hi,
I have created SSIS project that imports .csv file into sql server 2005.
SSIS package is saved successfully but now i want the table created in sql server 2005.
So, how to get the imported data in sql server 2005.
Can any1 help me out?
Thanx n Regards,
Ruja :)
I am trying to move an entire SSIS project from one machine to another (with a different directory structure) in a Development environment. In addition to the packages themselves I have Data Sources and Data Source Views defined. I also have connection managers for Excel and SQL Server that use those data sources, and connection managers for flat files for my error logs. Finally, I have saved my package configurations in an XML file.
I've followed the steps in the following post to move my packages:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=817897&SiteID=1
What else exactly do I need to do, though, to move my complete project. My objective is to start up BIDS on the new server, File -> Open -> Project/Solution and point it to the new <project>.sln file and have it work. I know I need to edit my config XML file, but other than that, how do I properly move/recreate the data sources, data source views, and solution files in the new location. I've tried several things, but with no luck.
Thanks!
Is there any use of creating an SSIS Setup project? Since the Package Installation Wizard already does a good job of it?
Which brings up a question - why dont SSIS Packages compile to a dll just like any other .NET project? It seems interpreted from the .dtsx file except for the Script Tasks of Components which are pre-compiled.
Why did MS change the design language all of a sudden?
But please answer - is there any use of creating an SSIS Setup project?
How do I create an SSIS Project in BIDS?
I installed BIDS, but I don't see any SSIS projects to create.
When I click File - > New Project
I see the following options under "Business Intelligence Projects" section.
1. Report Server Project Wizard
2. Report Server Project
No where do I see anything about SSIS or integration services projects. Am I missing something? Did I not download something?
I have
Windows XP SP2
Visual Studio .Net 2005
SQL Server 2005 Express
SQL Server Management Studio Express
Installed Business Intelligence Development Studio
My company has a SQL 2005 server that I connect to in which I want to run SSIS projects off of.
I'm sure I'm just missing something small. Can someone point me to the right direction?
Thanks,
UAT environment : SQL Server 2008 R2 SP3 Enterprise Edition
SANDBOX environment : SQL Server 2008 R2 SP3 Standard Edition
I have a database backup (.bak) that was taken from UAT environment that has CDC enabled on some tables. I want to restore that database into my SANDBOX environment which does not support CDC (because of standard edition). The restore process fails due to this incompatibility. Is there any way to restore without CDC (I dont CDC enabled on my SANDBOX; just my data from the backup) ?
Can somebody please help answering this question?
I'm planning to consider writing a SSIS package for a new project that requires downloading large chunk of data and transform into the diverse databases such as MS SQL or Oracle depending on the Client's Datbase.
For the clients having SQL Server installed at their end, i had no issues in deploying this package on their server and run it in their licensed instance.
What should be the case for others having Oracle database? Wouldn't installing the SQL 2005 client tools install the necessary run-time services for running SSIS packages? What i understood from the MSDN library (http://msdn2.microsoft.com/en-us/library/ms403355.aspx) is that there's no run-time support available for running the SSIS packages (unlike DTS run-time support) in production environment!
Would that mean that it requires a SQL Standard edition, at minimum, (as Integration Services is OOTB from Standard Edition onwards) to be installed at the production site to run this package?
If so, the client wouldn't be ready (which is fair too) to buy the new license just to run this package. Is there any work-around/suggestions for this case?
If not, can somebody please point me to the right location where i can download the run-time support for running SSIS packages?
Any thoughts on this is highly appreciated.
Thanks for your time.
~Sagar
When I start a new project the BI environment cannot open the DTSX package and I get only one tab with the message:
"microsoft visual studio is unable to load this document. Object reference not set to an instance of an object".
I tried uninstall and install of BI Development Studio as well as a repair install of Visual Studio 2005. None of which helped. Please help me to get this fixed.
Kind regards,
Neeva
Not sure if this is the right place to ask but I'll try...
I have to execute an integration service package in an .adp project. In other words, click of the button on the adp window has to start a package or a job.
Can that be done? And if yes, how? I've been searching the Web but without success.
Thanks for your help.
Our team has the following problem:
I create a SSIS project in VS and add it to Team Source Control. When the project and all it's files exist on a machine and I want to open the project from Source Control, everithing works fine, but when another developer, who doesn't have the files on his machine, wants to open the project from Source Control he is required to check out the project file.
I've investigated the problem and found out that each project has a database file (with .database extension) and project file contains a reference to it. Once the user opens from Team Source Control a project that isn't presented on a target machine, the VS creates a new database file on a local machine and insists to change the reference in the project file.
Does anyone have a workaround for the problem?
Thanks
Hi,
I have been working on an SSIS project for sometime now. The project files are located on a remote server. Suddenly I am not able to open the solution I get a lot of error messages and all the data flow taks are gone. I later found out that SSIS encrypts packages, so that other users will not be able to see them. Fine, but I have been using the same windows user account for months now. What could be the problem?
This is what I get when trying to open the solution:
There were errors while the package was being loaded.
The package might be corrupted.
See the Error List for details.
And the error list also contains messages saying "Could not load from xml".
Any pointers will be much appreciated.
TIA
In solution explorer under SSIS Packages there are many packages. I name them specifically so that they should be ordered with their names, but no the solution explorer shows them in the order I added them, I couldn't figure out a way but removing all the packages and adding them in the right order to fix that problem. I have to kinda redo this if I want to add a new package not to the end.
Any ideas?
I have written package which goes through a directory and load all the files with certain criteria. I have set the package to run using package configuration. It does work fine.
View 4 Replies View RelatedCan you execute a SSIS project from an ASPX page? Or do you have to wrap it into a SQL job and run that?
Does anybody have a code snippet to do this?
In my local client installation of the BI tools, I get the following error when simply creating an SSIS project and the default empty Package tries to display on the screen.
Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
I can use the Reporting Services designer with no problems, and I can use SSIS from the client tools on the server. It is just on my local PC that I get this error. I have completely uninstalled all the tools and reinstalled with no luck.
PLEASE HELP!
I have a report with multiple datasets, the first of which pulls in data based on user entered parameters (sales date range and property use codes). Dataset1 pulls property id's and other sales data from a table (2014_COST) based on the user's parameters. I have set up another table (AUDITS) that I would like to use in dataset6. This table has 3 columns (Property ID's, Sales Price and Sales Date). I would like for dataset6 to pull the Property ID's that are NOT contained in the results from dataset1. In other words, I'd like the results of dataset6 to show me the property id's that are contained in the AUDITS table but which are not being pulled into dataset1. Both tables are in the same database.
View 0 Replies View RelatedIs it possible to export the environment variables for an SSIS 2012 project? And if so how is it achieved?
View 2 Replies View Related