Hi

Thanks for the reply.

DDL

AddedPoints: CardId INT, TransDate DATETIME, PositivePoints INT

SpentPoints: CardId INT, TransDate DATETIME, NegativePoints INT

Sample Data:

AddedPoints:

123 2012-01-01 12:24:59 ...

HI

Thanks for the reply. Could you reply with some example please?

Hi,

I tried but I am getting error "The Parameter is incorrect [0x80070057]

Hi

Thanks for the reply. Double click has started the service. How can I set the Log On as NETWORK SERVICE?

Currently it is Local System. When I tried to set to...

Hi,

I have removed the cleansing task and just captured the error description(Log the error).

But, after execting onerror event handler(showing green), dataflow task fails(Red) not proceeding to...

Hi

Thanks for the reply.

The EventHandler(OnError) will truncate the same table which is trying to insert into that has failed. I think dead lock occured. How do I release...

Hi

Thanks for the reply. OnError event handler will log the error details to a table.

I forgot to tell you, I had OnTaskFailed event handler also enabled on DataFlow task.

Got the answer. Its now working. I dont know why its not working previously.

Hi all,

Thanks for the replies. We dont know the schema of the new system yet.

What I mean is how do we model the extract, staging bla bla.

What could...

Hi

Thanks for the reply. I solved it. Its due to NULL value in @TestRunId

Hi

Thanks for the reply. This is the actual code

CREATE PROCEDURE usp_AutoApprovals

@TransactionIdINT,

@PartnerIdINT

AS

BEGIN

DECLARE @TestRunId INT

DECLARE @InvoiceRules TABLE(ID INT IDENTITY(1,1), RuleId INT, RuleName VARCHAR(100), RuleProcedure VARCHAR(200))

DECLARE @EventData NVARCHAR(MAX)

INSERT INTO @InvoiceRules(RuleId, RuleName, RuleProcedure)

SELECTar.RuleId,

ar.RuleName,

ar.RuleProcedure

FROM Rules...

Hi,

Thanks for the replies.

No, I can't do using simple flat file source coz it is a csv file and delimited("). The column value also contains commas and double...

Hi,

Thanks for the replies. No complaints from the users. We are importing data from external systems using SSIS packages. The data import is slow.

How can I analyze...

Hi,

The URL is good and gives lot of information.

Thanks

Hi,

I have different columns in excel sheet. I want to import only the first column data.

So, its grabing NULL values. So like to get non null values. I...