Business Rules Integration In SSIS

Jun 6, 2007

Similar to the BizTalk Business Rules engine does the SSIS provide any support for independent business rule management?
I would guess that through the use of Embedded CLR we can invoke the Business rules stored in the Business Rules Engine (either Biztalk Rule Engine or ILOG Rule Engine). Is there a construct in the SSIS similar to the BizTalk Call Rules Construct in the Biztalk Orchestration.

If this mechanism is not the preferred mechanism then are there any other mechanisms offered by SSIS which facilitate the use of Business Rule Engine Components within SSIS which make it easier to manage the business rules outside of the deployment.

Thanks

View 5 Replies

Organizing Business Rules In SSIS

May 30, 2006

Hi All,

I'm pretty new to SQL Server 2005 and I'm wondering how to organize my
business rules efficiently.

I'm willing to create a Package with several Data Flow Task in my
Control Flow, each Business Rule will be encapsulated in a Data Flow
task. I guess this is possible in SSIS but I can't find how my data can
be send from one data flow to another one. I definitly don't want my
dataset to be parsed completly for each business rule.

Does anyone have an idea how to implement this in SSIS?

Kind regards,

Sébastien.

View 3 Replies View Related

SSIS Calling Into BizTalk Business Rules Engine (BTS BRE)

Oct 11, 2007

Hi,
We are planning to use the BTS BRE for our business rules and calling these from a data flow transformation (e.g. for every row in a flat file during import). One way would be to use a script component.
However, the question is that the script component would have to create and destroy BRE objects (e.g. a BRE Policy object) for every row in the flat file.
Is there a way to instantiate objects and whole on to them for the lifetime of the package or a container within a package?

Any suggestions regarding achieving the above most efficiently would be much appreciated.

Regards,
TD

View 3 Replies View Related

Business Rules Table

Aug 8, 2007

Which is the best practice for Business Rules

a. Hardcoded Column Names

b. Rowwise values RuleName, Criteria
Please suggest the best method

View 4 Replies View Related

Business Rules -&&> Using Lots Of UDFs && Views

Sep 7, 2007

I am in the process of building my first "large scale" database system (after 15+ years of developing Windows Apps and Web Apps) - so I am very VERY "Green" when it comes to Database development & SQL et al.

A little context setting: I am building a multi-tier Statistical Analysis & Reporting system where the "end product" will be Reports created in Reporting Services. There are a ton of business rules that I am implementing in a Business Logic Tier (hidden from the "end user" by a Data Access Tier) comprised of SQL in the form of UDFs (scalar) and Views.

The question: I have been reading that UDFs cause a performance hit compared to things like in-line functions. Alot of the Rules (implemented as Scalar UDFs) build on each other so that the output of UDF #1 is used as input to UDF #2.

So far I am implementing the Business Logic as a hierarchy of Views (7 Views to be exact) with each view implementing multiple Rules; each Rule basically a Scalar UDF. Below is an example of what I am doing:

Example

View #1 -> Select A, B, C, funcX1(A) as ValueX1, funcY1(B, C) as ValueY1 FROM someView

Then
View #2 -> Select A, B, C, ValueX1, ValueY1, funcX2 (ValueX1) as ValueX2, funcY2(ValueY2) as ValueY2 FROM View#1

Currently I have a hierarchy of 7 views that each use UDFs to implement the Business Rules, where the value calculated from a UDF in one View is used as input to UDF in a View further down the Hierarchy.

Is there a better way of implementing all of the Rules instead of using multiple Views with a bunch of UDFs?

The "end product" dataset is then exposed as a Stored Procedure to the reports in Reporting Services.

Any help would be GREATLY appreciated.

Thanks!
- marty

View 5 Replies View Related

Business Integration Template Missing In VS 2005

Feb 7, 2007

Hi,

Business Integration Services Template is missing in my Template List of VS 2005. Can any one help me how to add this Template

Thanks,

Uma Ramiya

View 4 Replies View Related

Business Scorecard Integration With SQL Server 2000/2005

Nov 15, 2005

I was trying to install Business Scorecard Manager Server , for that i have installed SQL server 2000, Analysis services and Service Pack 4 and also have taken mixed mode of authentication . Then i have installed sharepoint portal server 2003 and extended a site .

View 3 Replies View Related

I Do Not Have The Option To Create An Integration Service Project In Business Management Studio

Jun 13, 2007

Hi,

I have installed the advanced toolkit for Microsoft Sql server 2005, with the SQL server Business Intelligence Development Studio but I don't have the option the create a Integration Service project. I only have the Report Server project option available.

Do I have to download something else to get it?

I do not have a SQL server instance installed on the machine I installed the toolkit on.

Thank you

View 4 Replies View Related

Business Intelligence Project/Integration Services Project Not Showing Up In Visual Studio 2008

Mar 31, 2008

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.

View 7 Replies View Related

Only Creator Can Run SSIS Packages In Business Intelligence Studio?

Jan 31, 2008

Hello I'm sorry if this post doesn't belong here.
I need to run a number of packages from Business Intelligence Studio but I keep getting a validation error. They work when the creator of the package runs it. I'm the only person that needs to be able to run this package. What must I do? The encryption level is encryptsensitivewithUserKey

View 8 Replies View Related

SSIS SCD Type I, Dim Table Compound Key Selection For Business Key

Apr 28, 2006

Hai,

I have been working in DW for a while, but using SSIS as an ETL tool is new for me. I worked extensively on Informatica.

Coming to my question, right now I am trying to do SCD type 1. But my dimension table has a compound key. i.e more than 1 column makes a key for the table. But SCD wizard allows to select only 1 attribute as a business key. Does any one have any suggestions on how to implement SCD if the target table has compound key.

Thanks in advance for your suggestions and answers.

Venkat

View 5 Replies View Related

Installing VS2005 And Business Intelligence Report Projects On A Vista Business Workstation

Oct 23, 2007

Does anyone have a successful prescribed sequence for installing VS2005 and Business Intelligence Reports Projects on a Vista Business workstation to be used to create reports for a server?

I've looked through everything I can find here and I don't seem to see a clear solution without a lot of trial and error.

Fact is, I've not been successful getting just the reports to install on a plain XP box. Of course, the report creation looks fine on the server but I don't want to work directly on the server.

Thank you

View 1 Replies View Related

Synchronization Of Business Contacts In Outlook With Small Business Accounting

Jun 10, 2006

Can anyone take me through synchronization of contacts within Business Contacts Outlook into Microsoft Small Business Accounts?

I run a stand alone PC with NO network. When SBA came SQL was also installed. Apparently you can synchronise Contacts within Business Contacts with SBA but both SBA & Outlook should work through the same SQL server.

Has anyone tried this?

Can someone walk me through the process?

Thanks

Debbie

View 1 Replies View Related

Any Clues Why DTExec.exe Is Slower Than Business Intelligence Studio(SSIS Shell)?

Sep 18, 2006

All,

I have a simple package in SSIS that reads approx 2.5million rows from SQL2k5 source and exports it into 4 Foxpro files.
The way I do it is as below
1) use and oledb source to read data from SQL2k5
2) use a conditional split component to divide the source into 4 streams ( I do a recId % 4 = 0, 1, 2, 3 to give 4 streams)
3) use an OLEDB destination to export to the 4 prexisting foxpro tables.

This thing runs amazingly fast when I run(F5) it from Business Inteligence studio, but it is atleast 10 times slower when rightclick the package and execute using dtexec.exe

I can't figure out why! any clues??

I would elimiate the 64 bit /32 bit problems because export to foxpro only works in 32 bit mode and my package has been configured to run in 32 bit mode.

Appreciate any insights

Thanks,
Saptagiri Tangudu
PNT Marketing Services

View 13 Replies View Related

Executing SSIS Packages From Business Intelligence Studio When Not The Package Owner

Feb 5, 2008

I created a package but someone else will be running it every day. When this person opens the project in Business Intelligence Studio they get build errors such as the following:

Error loading PackageName: Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B "Key not valid for use in specified state."
You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.

this problem is described in the article below however the only advice they offer is to "change the value of the ProtectionLevel property " however they don't specify what to change the value to. I have tried every option but it still does not work. And having them enter in a password every time is out of the question.
http://support.microsoft.com/default.aspx?scid=kb;en-us;904800

It seems there is no way for someone other than the package owner to run the package! Running them from the sql server is not an option since we don't have permission to do so. As far as I know BIS is the only way.

View 7 Replies View Related

Integration Services :: Executing Child SSIS Package In Parent SSIS

Oct 9, 2015

I want to achieve the following in (SSIS/SSDT for SQL 2012) -

I have a generic SSIS package which simply sends out email notifications using SMTP email task (this package is within its own project, and has project level input parameters).

I need to be able to call this package in the Event handler section of every package (numbering in about less than 60) that we have. These packages are within their own respective projects.

I thought I could use the "execute package task", but it turns out , using this, I cannot call a package that is part of some other project. I also cannot call a package that is stored in the CATALOG. Is there any way I can do this ?

When I call the child package , I should be able to send in parameters like - error information and package name of the Parent package.

View 8 Replies View Related

Need Help For SSIS Package Creation With INSERT,UPDATE Large Amount Of Records Through Business Intelligence Studio

Jun 1, 2006

Hi ,

How to INsert and Update Large Amount of Records (4 Lacs) into Destination Table Through Business Intelligence Studio Using SSIS Pacakge .How to Achieve this .i tryed with left outer join & conditional split but the problem its not able to insert & update records simultaneously . can any one give me a sample .
Thanks & Regards
Jeyakumar.M

View 3 Replies View Related

SSIS To SAP Integration

Sep 6, 2006

Hi All

I am new to SSIS and my first task is to find out if there are any good third party/strongly recommended connectors out there to connect to SAP.

Our goal is to get information from SAP using SSIS and run transformations on source data

Thanks

View 4 Replies View Related

Integration Services (SSIS)

Jul 25, 2007

Hi,

I want to insert datas from a txt-file into a sql-table.
Therefor i would use a xml-file for the structure!

How can i refer this xml-file to a measurement insertion task?

Tanks for your help and sorry for my bad english :rolleyes:

View 1 Replies View Related

SSIS Integration / Deployment

Apr 12, 2006

I'm very new to the use of SSIS in a real enterprise environment. I've used DTS in the simplistic method of import/export but little else. As myself and a few others new to the tool are working through some things two questions have come up.

1.) What is the best way to execute an SSIS package using Java?

2.) Is it possible to deploy an SSIS package to a server that does not have SQL Server installed? I've read a few things that suggest that embedding the SSIS runtime environment in an application is possible but definitely not a beginner type operation.

Any quick guidance you can provide would be greatly appreciated.

View 3 Replies View Related

MS Office Integration && SSIS

Dec 4, 2006

Using SSIS, every month/week I have to generate serveral excel files. I need to find a way to automatically format these excel files (Bold, Headings in Different color etc.). Is there a way to integrate MS Office excel task in SSIS?

Thanks

Shafiq

View 5 Replies View Related

SQL 2000 And SSIS Integration

Mar 15, 2007

I have two computers one has SQL 2000 and 30 DTS package. The other computer has a new default install of SQL Server 2005 with SSIS.

All SQL related services on both computers are configured to run under localsystem.

I am planning on moving the DTS packages from SQL 2000 to SSIS. I want to do this by copying records between the MSDB sysdtspackages tables. The problem is I cannot access the SQL 2000 server from SQL 2005.

I am sure it is because I am running under the localsystem account. Assuming I had to run under that account, how can I access the system tables in SQL 2000 from SQL 2005?

View 3 Replies View Related

Using SSIS With EConnect For GP Integration

Jan 11, 2008

I am looking for a solution to help integrate an older ERP system with Great Plains. Data needs to go in both directions. For example vendors will be created in either system and will need to update the other. Mostly invoices will get pushed to Great Plains. Is there a way to use SSIS with EConnect so that our accountants, who are somewhat comfortable with simple SSIS packages can see the data made available with EConnect and play with transformations?

Does anyone have a solution like this?

Or am I going down a known wrong track?

Thanks in advance.

David.

View 5 Replies View Related

Integration Services :: How To Use UDF In SSIS

Oct 23, 2015

I want to use UDF in SSIS where function accept 4 parameter value and return 1 value.

How can i achieve that. I need workflow.

View 13 Replies View Related

Integration Services :: If Condition In SSIS

Apr 30, 2015

How to achieve the below condition in ssis

if person_id is like '123%' or '124%'
then details='xyz'
else details='yxz'

View 7 Replies View Related

Address Cleansing Integration With SSIS

Apr 1, 2008

Hi

How could I find a vendor of address data cleansing tool integrated into SSIS pipeline?
I need to remove duplicates,

correct zip 5+4 code and
add Lon/Latitude information for a zip.

Many thanks,

OB

View 9 Replies View Related

Integration Services :: SSIS CPU And RAM Sizing

Oct 20, 2015

if there is any way to accurately size a single server using SSIS. The server will be a virtual machine. The data being loaded will be approximately 200 MB per load with loading to a 150 GB database on a separate server.

View 3 Replies View Related

SSIS And Visual Basic Integration

Aug 30, 2007

Hello,

I am looking for a way to start an SSIS-Package from Visual Basic. Does anyone know how to do this?

Thank you
M-l-G

View 3 Replies View Related

Integration Services :: SSIS Job Schedule

Aug 31, 2015

I have scheduled SSIS package through Sql Agent and when I right click on job start job as step package runs successfully but when I schedule job it dosent run.

View 12 Replies View Related

SQL Server Integration Services(SSIS)

Nov 14, 2007

Can anyone help regarding the SQL server integration Services(SSIS), ETL
We have requirement like this:
We have Live Database( LIVE_DB ) and Reports Database (REP_DB)
I want to trasfer the few tables data from LIVE_DB into the REP_DB for end of the day using SSIS
If any new records are added, updated or deleted in LIVE_DB, these should reflect in the REP_DB, Our requirement is not to delete the old data, we should append or delete or insert the new transaction data in REP_DB.

Thanks in advance, if anyone help me in resolving this issue.

Regards,
Bhushanam.

View 3 Replies View Related

Data Integration Challenge. Will SSIS Help?

Sep 21, 2005

Hi,

View 8 Replies View Related

Integration Services :: SSIS Failed At Last

Apr 20, 2015

I have a maintenance plan which consist db full backup and log backup ( in two subplans), I execute both on SQL agent, and both failed.The DB Log Backup : DB FULL BACKUP LOG:

View 14 Replies View Related

Integration Services :: Use Windows Authentication In SSIS

Jun 17, 2015

I have a ssis package with an oledb connection using windows authentication. i want to understand when i promote this package to the server and add it to a job, then a user login to the server with sql server authentication and run this job. Which/what windows authentication this package gonna to use to connect to the server ?

View 3 Replies View Related