Add a script task and have it print out (MessageBox.Show) the SQL statement that you are building. Does everything look okay? Break it down a step at a...

What happens if you try:

SELECT

CASE

WHEN LEN(COALESCE([Closing Memo Date], '')) = 0 THEN NULL

ELSE [Closing Memo...

Mick Opalak (8/29/2011)

---

I need to update a table from an external file using SSIS but without loading the file (Excel, flat file, whatever) into a temp table in the database....

imani_technology (8/25/2011)

---

With Informatica, you graphically trace a particular column from source, through various transformations, all the way to the destination. You can also go backwards. Is there a...

You've got a mess that looks like it came from Access. Here is the general format for an UPDATE statement:

UPDATE table1, table2, table3

SET table1.field1 = 'abc',

table1.field2...

Put the same WHERE clause on your UPDATE statement as on your SELECT statment.

imani_technology (8/24/2011)

---

I have been using SSIS for a few years and I have recently been hired as a Senior ETL Architect. We are going to replace our SQL Server...

We use Redmine (http://www.redmine.org/); and this works well for us. There are quite a few decent open-source issue packages that have community editions (read: free) which is important for...

Would it be possible to do a checksum on the fields you're interested in on both source and DW; if they're different, then you need to do an update or...

durga palepu (8/22/2011)

---

Hi rgtft,

Its a master data mart table which contains source, destination tables and respective primary key columns.

The requirement is to transfer data from source table to...

durga palepu (8/22/2011)

---

A SQL Server table has columns source, destination tables and Primary Key where source and destination tables have same structure. How to transfer data from source to destination...

New Horizons (8/19/2011)

---

I'm relatively new to SQL Server. In fact I have little experience. I've used the training kit with little success. The test was a bit hard, so I...

shew (8/18/2011)

---

I am in the process of cross training a DBA. At this point, he has very little knowledge of ERwin 7.2 and data modeling in general. Can anyone recommend...

The error...

I've only got access to dev and test; here are the results of the above script:

Dev:

TableName ...