Viewing 15 posts - 1,081 through 1,095 (of 1,117 total)
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...
November 7, 2008 at 11:57 am
System.Math is part of mscorlib. It is the base library included in every .NET application.
November 6, 2008 at 12:51 pm
I could not think of any better approach. I was going to propose something along of what you have already implemented.
November 5, 2008 at 4:46 pm
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...
November 5, 2008 at 10:06 am
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.
November 5, 2008 at 8:07 am
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...
November 4, 2008 at 4:04 pm
Vijaya,
You are double posting . I have already answered your question here.
November 4, 2008 at 9:27 am
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...
November 2, 2008 at 7:43 pm
Have you tried selecting explicitly the columns you want imported? I'm guessing your source is set with : SELECT * FROM ...
November 2, 2008 at 7:03 pm
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...
November 1, 2008 at 7:46 am
Can you post as much information from the error as possible?
November 1, 2008 at 7:34 am
Implement script source component and you can customize your parsing logic as much as you want.
November 1, 2008 at 7:33 am
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...
November 1, 2008 at 7:30 am
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.
October 31, 2008 at 7:04 am
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...
October 30, 2008 at 9:20 am
Viewing 15 posts - 1,081 through 1,095 (of 1,117 total)