Biztalk vs SSIS as an ETL tool - Microsoft SQL Server

Similar topics

Receive biztalk request sample aspx please

by: Daniel Rimmelzwaan | last post by:

I want to send a biztalk document to an aspx page, and I need to see some sample code, because I just can't make it work. I have a port with transport type HTTP, pointing to my aspx page, something like http://myserver/mypage.aspx. From there it gets blurry, because I just can't figure out how to do the rest. Does anybody have a sample page...

C# / C Sharp

1403

Tool similar to BizTalk Schema Editor?

by: BigDave | last post by:

For a previous employer, I did a lot of BizTalk 2004 development, but am no longer doing so, and do not even have BizTalk installed. One of the things I miss is the BizTalk Scheme Editor, and how it displayed elements in a vertical tree. (Visual Studio 2005 Schema Editor and XMLSpy seem to want to display elements in a horizontal tree,...

ASP.NET

5282

MF DB2 Stored Procedure Call from SSIS 2005

by: stant | last post by:

I am trying to call a mainframe cobol DB2 Stored Procedure from an SSIS 2005 SQL Task in BIDS. I believe that privileges and the number of parameters (6) are fine. I've tried casting and still have no luck. The error is SQL0440N. I am running with DB2 Client 8.2.4. The sql call in BIDS looks like... call ODW.ODWCY002 ('TN',cast...

DB2 Database

1818

need help in SSIS ETL development

by: AMAN | last post by:

Hi all, I am a newbie to SSIS.Need a solution to couple of issues I am currently facing while developing ETL in SSIS 1) Under SSIS Package Folder I have defined mappings for 17 dimensions. 1st Dimension say Account has been Set up as a startup object. Now when I run the package ir runs only my account dimension and loads the target,other...

Microsoft SQL Server

2365

Does anyone use SSIS for database schema maintenance?

by: Ben | last post by:

We currently use SSIS to build DTS packages in which we store changes to our database schema, as well as scripts that need to be run upon each release. This works well for small sets of changes that never need to be updated or for architectures with only one database. We store each of the changes included in the package in separate files,...

Microsoft SQL Server

1650

Attention All GURUS: Importing Mulitple MDBs in SQL Server 2005 Using SSIS

by: Silly Milly | last post by:

Calling ALL SSIS GURUS I am trying to import identical MDBs (Access Database) columns into SQL Server 2005 using foreach loop in SSIS. The data and file name of the MDBs are not the same; however the structure (column) is. I do need to capture part of the file name and insert it into the destination column (i.e. Year). I've used the foreach...

Microsoft SQL Server

10489

ssis EXEC command

by: gelangov | last post by:

I have 2 variables, one is the column name of the table and the other one is the table name and I need to write this in the "Execute SQL task" of a "For each loop" container in a ssis package like this: Truncate table <tableName> Insert into <tableName> Exec (' select from '+ ?) It gives me error message when I try run the ssis. ...

Microsoft SQL Server

6090

SSIS is pathetic with ODBC connections ...

by: jags_32 | last post by:

We have spent days trying to perform a proof of concept and I am dissappointed with SSIS to say the least. We are trying to connect and fetch data from a Double Byte Progress database and the "DataReader Source" using a ADO .NET ODBC provider does not work! I understand that SSIS is a totally rewritten version of DTS. What annoys me is that...

Microsoft SQL Server

19643

SSIS and HEX conversion.

by: TonFrere | last post by:

Hello, I must convert a CSV file which is simply hexadecimal words. There is a SSIS function to convert from decimal to hex but none for either hex to decimal or hex to ASCII. Here is what my file looks like: 3032;3631;3031 3032;3631;3032 Here is what it should give: 026101 026102

Microsoft SQL Server

7912

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7839

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

8202

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

8338

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

6614

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5390

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

2345

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1449

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1180

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General