Package Fast in VS but slow when deployed to server

I have a package which completes in 3 minutes when ran from Visual Studio but when deployed to SSIS (same machine) it rans for more than 2 hours. What could be the reason for this?

Could you describe the package content and what does it do?|||

The package retrieves data from a source via a data flow task. The result is returned to the control flow as a recordset object. I have a ForEach container in which I am looping through the recordset. For each record, I am checking if corresponding records exists in another data source via SQL Task. If it exists I use another SQL Task to update it. If not, I add it via a third SQL task.

|||I never figured out what was causing this. Ended up redesigning the whole package and removing the foreach.sql

Package Fast in VS but slow when deployed to server

I have a package which completes in 3 minutes when ran from Visual Studio but when deployed to SSIS (same machine) it rans for more than 2 hours. What could be the reason for this?

Could you describe the package content and what does it do?|||

The package retrieves data from a source via a data flow task. The result is returned to the control flow as a recordset object. I have a ForEach container in which I am looping through the recordset. For each record, I am checking if corresponding records exists in another data source via SQL Task. If it exists I use another SQL Task to update it. If not, I add it via a third SQL task.

|||I never figured out what was causing this. Ended up redesigning the whole package and removing the foreach.

Package Failure (The session was canceled)

Anyone seen this error or know what this could be? I got this when executing a package. It works on my dev machine, however failed with this error on another test machine/environment.

The session was canceled. (Exception from HRESULT: 0x800700F0) (Microsoft Visual Studio)

Program Location:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at Microsoft.DataWarehouse.VsIntegration.Interop.NativeMethods.ThrowOnFailure(Int32 hr, Int32[] expectedHRFailure)
at Microsoft.DataWarehouse.VsIn

any idea anyone?

OWA over proxy server

Exchange machine uses local address. OWA is doing fine localy. But if i
wanted to make OWA available outside my company i had to do something. I
used apache server as proxy and in it i redirect all requests to internal
exchange address. Problem is tha users cannot login. I get response from
exchange but only logins make my life living hell.
Can somebody help me?
regards,
daliborSORRY WRONG GROUP
"Dalibor Cvijetinovic" <dalibor@.ice.si> wrote in message
news:%230RF1TMtDHA.2136@.TK2MSFTNGP10.phx.gbl...
> Exchange machine uses local address. OWA is doing fine localy. But if i
> wanted to make OWA available outside my company i had to do something. I
> used apache server as proxy and in it i redirect all requests to internal
> exchange address. Problem is tha users cannot login. I get response from
> exchange but only logins make my life living hell.
> Can somebody help me?
> regards,
> dalibor
>

Override Identity Column using Datatable

I need copy a table from a remote (hosted) SQL 2000 database server to my local machine. I don't have access to backups and am unable to correctly configure my local machine to add a linked server. So I plan to retrieve the data to a datatable, copy it in code and save it to my local server. But the table contains an identity column which I will need to insert the values manually so they match the original.

Can anyone tell me how I can set the datatable's save to use my manual values instead of the autonumber value?

Thanks.

there are two options

1. First remove the constraint on identity column, then import the data, after that apply the constraint on iidentity column.

2. Add another column for it,

|||

SET IDENTITY_INSERT {YourTableName} ON

INSERT INTO {YourTableName} ....

SET IDENTITY_INSERT {YourTableName} OFF

|||

Thank you for the response Motley, but I don't want to have to create SQL statements; I want to do this directly in code using a datatable. Do you know how to do that?

|||

If you do not want to write sql query, then I suggest to go for answer1, turn off identity feature, import the data and turn it on.

|||

You would use the "SQL Statements" I gave above in a sqldataadapters's updatecommand.

|||

Hi,

Actually the code is also calling the SQL statements to do the update. So you will always need some SQL Statements for updating.

I suggest you use the way Girijesh has provided. Turn off the identity contraint off and import data.

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!