DataSource Controls :: SSIS And SSRS Practical Use?
May 13, 2010want to know about SSIS,SSRS and what is the use of them,how to use them practically
View 3 Replies
Similar Messages:
SQL Reporting :: SSRS And SSIS Interview Question Or Links?
Jun 8, 2010forward me the SSRS or SSIS Interview Question or Links, I have search in google but i did not got much information on that.
View 2 RepliesDataSource Controls :: Executing Code In SSIS?
Jan 28, 2010I have a web project that sends out a customized email after certain user events (like a status change). I also have an SSIS package on the database that pulls in data from one database and updates another database with that data. I want to be able to compare the data and if a particular field's data for that record is different between the two databases is different, I want to be able to use the dll I created for the web app to send the appropriate email.
View 2 RepliesDataSource Controls :: Load By File Name (SSIS)?
Mar 22, 2010What's the best approach for loading a flat flat according to its name? A Mainframe job places a file on a server for me and it always beings with MISA and I load the file monthly. After loading the file I'd like to move it into a History folder on my server.Should I use a Script Task or the Foor Loop Container to accomplish this? Keep in mind I only want to load files that begin with "MISA".
View 4 RepliesDataSource Controls :: SSIS: RetainSameConnection And Variable Locking?
Jun 8, 2010I am modifying a rather large ETL package using BIDS. It builds a datawarehouse, so there are many sources and a single destination. There are quite a few data flow tasks, and their connection strings are read into variables from an encrypted source. All the data flow tasks are arranged serially because of variable locking issues - occasionally two DFTs attempt to simultaneously lock the variable and it fails. I realize there are script solutions out there, but I am looking for perhaps a more elegant (easier) solution than to apply scripted solutions to tons of packages over something so trivial.
I came across the "RetainSameConnection" connection property, and I have a hunch this could be the solution. My reasoning is: If there's only one connection to a data source, there should only be one read operation from the variable. At least, it makes sense when SOURCING.As for destinations, I'm not sure if it's a good idea to have data from multiple sources flowing in through a single connection.This is my first week working in ETL so I don't know all the nuances of databases, ETLs, connections, etc.
DataSource Controls :: Executing SSIS Package Through Asp C# Application
Jun 23, 2010i am having a problem in executing the SSIS package through an asp.net application. i'm using c#. every time i run the package through web, i think the package is not disposed properly so until and unless i stop the application the package won't execute...i am not able to dispose or unload the package. i'm geeting errors like
'WebDev.WebServer.EXE' (Managed): Loaded 'C:WINDOWSassemblyGAC_32CustomMarshalers2.0.0.0__b03f5f7f11d50a3aCustomMarshalers.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. The result of the expression ""EXEC " + @[User::vRowData]" on property "SqlStatementSource" cannot be written to the property.
The expression was evaluated, but cannot be set on the property. : Package Execution results: {0}
here is my code
Application app = new Application(); //Package package = app.LoadPackage("D:ChipRewards_WorkingFolderChipRewardsCodebaseHeathPlanCommonTrunkSSIS PackageETL_WorkFlowETL_WorkFlowDataImport.dtsx", null); //package.ImportConfigurationFile("D:ChipRewards_WorkingFolderChipRewardsCodebaseHeathPlanCommonTrunkSSIS
PackageETL_WorkFlowETL_WorkFlowETLConfig.dtsConfig");
[Code]....
DataSource Controls :: SSIS Package Not Reading Configuration
Mar 2, 2010The short story is, I'm developing an SSIS package to select from a remote Oracle database (read: no Windows Authentication) and store into an SQL Server db. I can execute the package just fine in development and after importing, but when I run it as a scheduled job, I get an ora-01017 error (bad un/pw). The details are, I built this package and tested in in BIDS but came across the problem that BIDS really doesn't save the password I'd set for the Oracle connection. After poking around a bit, I found this
[URL] which showed how to create an XML configuration which the package could then read. Fiddled around with that, got it working in BIDS. Connected to Integration Services on the server on which I want to run the package, imported it, right-clicked and did the "Run Package" option as a test, it works great. However, when I connect to the same server's Database Engine to create and schedule a job, I cannot connect to Oracle. For some reason, it seems as if the package is not reading the configuration when run in schedule.
I've tried removing the job and re-working it, thinking maybe it didn't pick up the new version when I re-imported the package. A new job had the same problem. Next, I tried re-naming the .dtsConfig and doing the "Run Package" option as a test. Failed with the same error. A bit surprised, I thought I'd get some kind of file error and we wouldn't get as far as trying to talk to Oracle. Anyway, thinking maybe it's permissions on the configuration, fixed the .dtsConfig name and gave full access to Everyone. That ought to let the Agent see it. Scheduled up the job, still can't talk to Oracle. So it seems as if the scheduled version is ignoring the configuration. Anyone have any idea what I'm missing, that scheduling an SSIS package makes it act differently than running it manually? BTW, the instance under which we're running the package is VS 2005. BIDS 2005 to build the package.
DataSource Controls :: SSIS Can't Copy Configuration With UNC Reference?
Mar 9, 2010In my initial cycle, I put the package configuration on a shared drive. This works great for my dev box and the dev db box, as they have the drive mapped in the same way.Unfortunately, the proposed production server has E mapped elsewhere. "Easy," I thought, "I'll just change to use the UNC version of that path."When I attempt to run the package on my development box, I get an error in BIDS that says it can't copy to the deployment utility output directory.This is wrong, as I delete the file, start the package, and it magically appears in my deployment/bin directory. Itdoes, in fact, copy the file, then has this error.I changed my reference back to the mapped drive, and the build works.
View 2 RepliesDataSource Controls :: Programmatically Modify The SSIS Package?
Mar 16, 2010how to modify the destination database in SSIS package using c#?
View 3 RepliesDataSource Controls :: How To Implement SSIS With VS2010 And SQL Server 2008
Oct 31, 2010I am new with SSIS, what I need is to search on a specific column in a table.
I am using asp.net with C#, and I dont have a cluw how to start and implement this.
DataSource Controls :: How To Deploy SSIS Packages From SQL Server 2008
Feb 26, 2010I have a number of existing SSIS packages on SQL Server 2008 and want to deploy them to another server. What is the easiest way to deploy multiple packages to another server?
View 1 RepliesDataSource Controls :: Migrating SSIS Package From SQL Server 2005 To SQL Server 2008
Jun 17, 2010Migrating SSIS package from SQL Server 2005 to SQL Server 2008
View 1 RepliesDataSource Controls :: Installing (sql Server 2005) SSIS Packages On SQL Server 2008?
Feb 25, 2010Previous developers have developed a .SSISDeploymentManifest file (SQL Server 2005) to install SSIS packages which prompts a Package Installation wizard. I tried to install it on SQL Sever 2008 (it works on SQL Server 2005), but it failed with the error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
How do I install 2005 SSIS packages on SQL Server 2008? I have all the .dtsx files, not sure how to install them?
DataSource Controls :: SSIS Job Failed With Error Error Code: 0x80004005 OLEDB Error
Jun 6, 2010Error:
Executed as user: MACSTEELUSA.COMsa. ...9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:17 PM Error: 2010-06-02 20:00:18.56 Code: 0xC0202009 Source: CRM_ORACLE_ARSUMMARY Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle client
and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.". End Error Error: 2010-06-02 20:00:18.58 Code: 0xC020801C Source: Data Flow Task Source - Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireCon... The package execution fa... The step failed.
Tasks Taken:Went to this folder checked for tnsnames.ora file but it is in good shape.
C:ORACLEproduct11.2.0client_1
etworkadmin
Practical Limit Of A Textarea?
Jan 14, 2011Using IE6+, what is the maximum amount of text you can POST with a <textarea> before something breaks?
Edit: The answer I'm hoping for is "there's no way you could actually type something meaningful and unmallicious into a textarea and crash Internet Explorer."
SQL Reporting :: Convert .rdl Files From Ssrs 2000 To Ssrs 2005?
Nov 10, 2010I have a number of .rdl SSRS 2000 files that I want to convert to SSRS 2005 .rdl files.
I have installed BIDS 2005 and have opened the project in BIDS 2005.
When i open any file individually I get about 200 error messages.
Does anyone know what I need to do to convert the .rdl files to SSRS 2005?
Practical Application Of Convention Vs Configuration
Apr 18, 2010but here's a case in point that I'd like to share and get input on. Below are two entities, coded like normal.
Csharp Code:
using System.Collections.Generic;using SharpArch.Core.DomainModel;namespace Venue.Core{public class Category : Entity{private virtual IList<Forum> forums = new List<Forum>();public virtual int Sequence { get; set; }public virtual string Title { get; protected set; }public virtual string Description { get; set; }public virtual bool Enabled { get; set; }public virtual bool Visible { get; set; }public virtual IEnumerable<Forum> Forums { get { return forums; } }public void AddForum(Forum entity) { forums.Add(entity); }public void RemoveForum(Forum entity) { forums.Remove(entity); }public Category(string title){Title = title;}}}
[code]...
Practical Advantages Of Precompiling A Website?
Mar 15, 2011What are the practical advantages of precompiling a website?
View 3 RepliesC# - Binding A Datasource To A Rdl In Report Server Programmatically - SSRS?
Mar 2, 2010I've done a asp.net application to generate reports over a particular data. Initially i created local reports (.rdlc) to generate reports. I created separate .xsd for each rdlc and designed the reports. I build the dataset programmatically and bind it to the rdlc. I used the following code for binding the datasource to the reports -
rptMyReport.LocalReport.ReportPath = Server.MapPath(srdlcName);
rptMyReport.LocalReport.DataSources.Add(rds);
Now i have converted all the rdlc to rdl following this msdn article and i've published the reports to the report server.
rptMyReport.ServerReport.ReportServerUrl = new System.Uri("http://ReportServer/ReportServer");
rptMyReport.ServerReport.ReportPath = "/ReportFolder/ReportName";
Now how can i set the datasource to the reports programmatically?
ADO.NET :: Practical Technique For Dealing With Null Entities?
Feb 27, 2011In my new ASP.NET EF4 project, I find myself having to do a lot of maneuvering around null entities. For example, I may have a Project Entity with a related User Entity exposed through an Assignee property. Suppose I need to send an email to someone indicating who the Assignee is, I need to say:string x = "The Assignee is: " + TheProject.Assignee.Name;but I'll get an exception if there is no Assignee as the property is null (I want nulls by design) and I can't fetch the .Name property on that null.
View 4 RepliesDatabases ::asp.net 2010 And Mysql Are Practical For 10 Million Records ?
Aug 12, 2010I am developing a large e-commerce system.
I am using asp.net 2010 with mysql database. Is it practical for large amounts of data ? say 10 million records ? cuz some people said to me that using this combination, i'll be having performance issues as database grows.
SQL Reporting :: Ssrs 2008 Reports Datasource Error In Test Server?
Oct 18, 2010i Have upgraded my Reports from Report server VS 2005 to VS 2008 .
My reports works fine in local, development & test server.
After Ugrading to 2008 it works fine in local server & devlopement serverr.
When i deployed to Test server i am trying to access my reports i am getting below errors,
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..
i checked the Datasource conncetion properties..its pointing to correct Test database only..
My reports are windows integrated...
Now it works in srs 2005 developement & test server. For same properties it works in dev server, it doesn't works in srs 2008 test server.
Data Controls :: Impact Of EnforceConstraints Property On Dataset While Working With SSRS
Apr 28, 2013I was working with SSRS in windows application,when I got this error "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." I have made the property of Dataset(.xsd) EnforceConstrints to False and error gone. Whether it will impact anywhere in the application in the future or it wont have any impact.
View 1 RepliesSQL Server :: How To Use XSD,XSL Over XML In VB.Net In SSIS 2005
Dec 21, 2010I am migrating a project from C#.Net (Console Application that acts as a server) to SSIS 2005 based one as the task involves around Database. I can able to use only VB.Net in SSIS 2005 version. The problem is, the C# code has XSD, XSL operations over XML along with XML processing such as XML creation/generation, compressing the file, and saving the file into DB. As it looks like the above operations are not achieved without using VB.Net in SSIS, I am blindly converting into VB.Net inside SSIS.
Also, I would like to know how to import/create XSD files in VB.Net in SSIS. It is not like Visual Studio to add a new XSD file and design the same that allows generating the appropriate code.
For your information, I am using Typed DataSet.XSD file in C# which needs to be converted into VB.Net in SSIS. There is no provision to add Typed DataSet XSD files into VB.Net in SSIS 2005.
SQL Server :: Import From CSV In SSIS?
Sep 27, 2010i am trying to create a import package to import data from a CSV file. When I create a flat file source and take a look at the preview I see that the fields are mixed up. Some fields are ok, but quet a few arent. When I open the CSV in excel or a other program it looks good, all rows are ok. When i import the CSV in access it is also ok. So I'm a bit confused where the problem lies. all the settings are standard. The strangest thing is that when i replace al the semicolons to for instance tab's the problem keeps.
View 4 Replies
