We do have the trasaction levels of the components used. yet i don see the rollback happening in the case of a exception in the package.

Problem solved,...

i was unaware that the connection string could be changed using th eSQL task script. Would it be possible for you to brief about how to do this?

I think u have misunderstood my question. I do understand what u r trying to say, but i want to know if there's a way to change the destination table...

Its just a simple VB script...

Dim myCharArray() As Char

Dim myChar As Char

'populate the...

Sorry about the delay...

I used a script component which got the particular field which has to be checked for the existence of special characters as input and also added another...

Please let me know if this is not a good approach

Thanks for the reply. I resolved the issue by writing the records to a recordset and then i use the recordset to find the parent records moved.

Problem solved. The posts were really helpful. Thanks to all those who replied

I'm looking for a way to detect and redirect rows that contain special characters

Thanks for your suggestion Michael. We are not in a position to go for jobs right now as it would involve a lot of other reworks. We solved the problem...

Hi Paul,

Sorry to say taht I am not able to overcome my prob with the code snippet u've attached. When i try to execute the code, the package is not...

Also, when i tried to run the packaged using xp_cmdShell after switching the connection strings from WIndows Authentication to SQL server authentication (i changed the authentication as i was getting...

Yes. i am using xp_cmdshell to call the package.

DECLARE

@BranchIDINT

,@LOBIDINT

--Variable Declaration Section

DECLARE@CALLnVARCHAR(2000)

SELECT @BranchID = 28, @LOBID = 1

--Interface call

SET @CALL ='dtexec /SQL "\PickupBridge" /SERVER CHNMCT90315 /SET \package.variables[BranchID].Value;"'+CONVERT(varchar(16),@BranchID)+'" /SET \package.variables[LOBID].Value;"'+CONVERT(varchar(16),@LOBID)+'"'

EXEC...

The UI is not going to look into millions of records if proper filters are provided to the SP. But if no filters are provided, the UI will have to...