I think even you store the password, in SSIS password is not stored in the connectionstring. You can check the property value fir the connection.

Use SSIS Configurations for SQL server...

Gyanendra

You mentioned that everything is going in error log or lookup is failing.

I think there may be some different issue that is causing records to be errored out.

Is it...

If you are iterating through comma delimited string, get the full row set of ID's and Iterate over it using FOR LOOP. 😉

Nilesh,

Can you tell what exactly you are trying to achieve?

I think it is a data issue. If you are sure that it’s not a foreign key issue then check for...

You are right. You have to use XML configuration.

Check this

http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

If you see the actual error is “The value violated the schema's constraint for the column”

This means that, there is foreign key violation in the destination.

Column: "COLUMN NAME" (728):...

You mentioned that, The package is running for more than an hour and you ran profiler as well..

did you see any processID or SPID with -2 value in profiler?

🙂

Check your mail. I have sent you the updates

provide me thee password for package.

I am unable to open it as it is password protected

Use OleDb connection

sarang_bobde@yahoo.com

If possible send me structure of both the tables I will try it out.

Try following

1) Create Variable of the datatype "object"

2) In Execute sQL task Editor set property to resultset to FullResultSet

3) In resultset Section,

1) Resultset Name = 0

2) VariableNAme = ...

"OLEDB Command" does not require destination.

I have used it in my all packages to updates the records.

If you are getting error can u please post the error or snapshot...

Please post the uery

Just use Import EXport wizard.