Script component

or use a derived column(note that this will not work if numbers use leading 0's):

Result = !ISNULL([Col]) && ((DT_STR,20,1252) [Col] == ((DT_STR,20,1252) (DT_I4) [Col] )) ? (DT_I4) [Col]...

You complete me :hehe:

Alvin Ramard (11/2/2010)

---

SQL 2005 packages can be easily upgraded to 2008 but will then no longer run on SQL 2005. There is no downgrade option to convert 2008 packages...

There isn't backwards compatibility between 2005 and 2008. You can upgrade a SQL Server 2005 package to a SQL Server 2008 package with a wizard. Typically the only...

A couple of things could cause this issue that I've run into...

-A blocking issue...perhaps inserting to the same table that you are extracting from as your source

-Commit size on the...

Business rules change. Always code it as if in a month the process will start inserting two records at the exact same time.

Installing both 32 bit and 64 bit drivers/providers on the server has helped resolve this issue in the past at clients. (BIDS uses 32 bit, but Job Agent uses 64...

One idea:

-Loop through D1.txt, D2.txt, and D3.txt files in D:\data. Instead of trying to move and append using the File System Task, use a Data Flow Task and extract...

Can you not use the datediff function as a part of your extraction query?

I've used the SCD component, lookups on Type1/Type2 columns to determine new/inserts/updates and hashbytes. There is simply no comparison in performance when dealing with large data sets. Hashbytes...

There are typically a few attributes in the date dimension that are custom made and specific to that particular organization. These attributes include fiscal calendar columns and holiday/workingday indicator...

vineet1234 (6/18/2010)

---

5) This way we get the non-matching rows in the error out put. These are the new records coming in.

Among the matching rows we can use a Conditional Split...

I use Hashbytes.

1) Cast any non-string data to string values

2) Use Hashbytes function(create in either a VB script or extract query) and create a HashByteType1 value stored in a HashByteType1...