You have to insert the early arrived EmployeeID in the employee dimension and get the generated (surrogate) id and use it in the fact table. Check this post for efficient...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

System.Math is part of mscorlib. It is the base library included in every .NET application.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

I could not think of any better approach. I was going to propose something along of what you have already implemented.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Okay, I think I know what is happening. You should not open/close the connection after every row processing. I'm not even sure you have to close the connection because connMgr.ReleaseConnection...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

It is better to send the complete script . With pieces here and there, I don't quite get the idea of what you are trying to accomplish.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

The LookupConnection is a connection setup in the sample script component. You have to setup the connection you have in use in your package. This is done in the script...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Vijaya,

You are double posting . I have already answered your question here.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

I don't know what to tell you. This is how SSIS works. This behavior doesn't look right, but there might be a good reason for it. Why don't you post...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Have you tried selecting explicitly the columns you want imported? I'm guessing your source is set with : SELECT * FROM ...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

It is not possible to read DataReader Destination in a package. Even if it was possible, it is slower compared to Raw File Source and Destination. We know it because...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Can you post as much information from the error as possible?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Implement script source component and you can customize your parsing logic as much as you want.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Yes, there is. Check out the following stored procedure:

CREATE PROC [usp_Insert] @insert_value VARCHAR(250)

AS

INSERT INTO [MyTable] ( [table_value] ) VALUES ( @insert_value );

SELECT IDENT_CURRENT( '[MyTable]' );

GO

---

This is much faster because it...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Nithya,

You have to build custom SSIS data flow component to be able to reuse the code in different projects. You can find here more information on building custom component.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Yes, it is possible. However you have to write a script to retrieve the list of worksheets and based on your requirements store in a package variable. What you have...

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/