Often times in SSIS you will get three or four error messages, but only one of them really sheds any light on the issue. In the progress tab, look...

john_nyasani (12/2/2011)

---

I am trying to change my career focus from batch scheduling into the BI,Data analytics area. I know that SQL is a powerful BI tool. I would like to...

What is the data source? If the source is a SQL Server table, is there a natural key you can use to do a outer join between your source...

gugan_ta (11/4/2011)

---

Hi All,

We are using SCD types in dimension loading. For this we have planned to use default SCD component in SSIS. We also found diffrent methods to handle SCD...

Take a look at Andy Leonard's Stairway to SSIS series here on SQL Server Central:

http://www.sqlservercentral.com/stairway/72494/

HTH,

Rob

I would recommend also adding annotations to your packages. A well placed note can help explain/document what your package is doing and the logic being used.

SQL Server Integration Services (SSIS) would be my tool of choice. The import/export wizard is just a specialized package (and limited) package that uses the SSIS engine. What...

Sorry I hadn't looked at the graphics in the link. But you're right if the preview works on the server, then you wouldn't think it's the ODBC driver.

Is there...

Can you connect to the Informix datasource via the ODBC using another tool (e.g. MS Access or Excel) on both your machine and on the server? Are the results...

If you're sure that FName is the field, is it just a matter of missing single quotes around...

I get this error for the below code:

Query (11, 7) Parser: The syntax for 'ORDER' is incorrect.

-- SMDX003-004 Simple Use of Order() function across columns,

-- sort descending(respecting hierarchies)...

You're going to get more out of your homework assignment if you put some of your own...

Your condition doesn't look correct; the ISNULL() returns back true or false. You want something like:

!(ISNULL(field1)) && !(ISNULL(field2) && field1 == field2

One (or more) of your fields in the conditional split expression are Null. Put an ISNULL() in there to handle this case. That should fix your problem.

Rob

winseelan (10/5/2011)

---

rgtft (10/4/2011)

---

You've got to open your .dtsx package in BIDS to do the modifications. It sounds like you're not familiar with SSIS. Take a look at Andy...