Hi, I have a SSIS Package which is stored in Db server(in msdb database). I have download the same package form server using BIDS. I made the changes in this package...after have uploaded the same package to Server. But the changes are not updated in the server. After i have tried with another way....i.e first i have built the project....then its generated a SSISDeploymentManifest file, through this also i have deployed to Server...but the changes what i have done in the package which is not updated in the server. Could you please let me know with Answers will be appreciated. Thanks & Regards, AnilThanks & Regards, Anil

did you deployed it at same position that was before? with same name?http://www.rad.pasfu.com

Yes..with the same name only..But it cannot updating BIDS itself(i mean BIDS itself, i have updated the Execute SQL Task) also. when i was trying to execute, it was failed due to the changes not updated.. Can you please help me on this... Thanks & Regards, AnilThanks & Regards, Anil

what error message you received when you tried to run on BIDS?http://www.rad.pasfu.com

Dear, The following are the error details. Information: 0x40016040 at Dbsfe_SFE_Load: The package is attempting to configure from SQL Server using the configuration string ""SAFE_SQLDB";"[SFE_Schema].[SSIS_Configurations]";"Safe-DataImport_Daily";". SSIS package "Dbsfe_SFE_Load (3).dtsx" starting. Error: 0x0 at Execute SQL Task: Incorrect syntax near '.'. Error: 0x0 at Execute SQL Task: Incorrect syntax near '.'. Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "EXEC USP_SFE_Update_Load_Time exec dbo.up_trunca..." failed with the following error: "Incorrect syntax near '.'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Task failed: Execute SQL Task SSIS package "Dbsfe_SFE_Load (3).dtsx" finished: Success. Its a syntax error... i fixed this one...but code is not updating when i tried to execute this task. Is there any properties needs to be change for this? Thanks & Regards, Anil Thanks & Regards, Anil

"but code is not updating when i tried to execute this task." what do you mean here? please elaborate more ... this doesn't make sense for me completely yet. http://www.rad.pasfu.com