Opening SSIS package without validation

Is there a way you can open an SSIS package without validating it?

The reason is - when I take a package from PROD and open it in DEV - initially all settings-variables are wrong - and the validation takes heck of long time in that case. And then I need to change the variables and reload the package. And bloody hell - if I forgot to change a variable - I sometimes have to validate package 3 times. And sometimes - I only need to get visual look of package - so why do I always need to wait for validation...Set BIDS to work offline.

SSIS Menu -> Work Offline|||Nice - thanks mate, this will save me a lot of time

I wish they would add a feature to right click a package and say "Open package in offline mode" for dummies like me |||

TheViewMaster wrote:

Nice - thanks mate, this will save me a lot of time

I wish they would add a feature to right click a package and say "Open package in offline mode" for dummies like me

Sounds like a good idea. You know where to request it right?

-Jamie

|||https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=282357|||

Cool. I voted 4.

-Jamie

open up 32bit SSIS package in 64 bit machine ( 64bit sql server)

I have designed a packege using my local machine ( 32bit) and am trying to deploy this package to 64bit machine and open it up.. are there any issues that I need to aware of? 32 bit ssis and 64bit ssis are comparable each other?

If you are using connections that only have 32bit drivers you will have some issues when you try to execute the package (ie: excel). Other than that you won't see any differences, besides performance gains (most likely).

|||

Hi safd*,

Apart from that,

We do have list of Oracle Connectivity issues we need to be aware of, Indeed an adventure to some, see here .

I've summarized the settings we need to be aware of in my blog .

For detailed information download Connectivity and SSIS.doc from Microsoft official site.

Thanks

Subhash Subramanyam

|||I have developed 32bit SSIS package and trying to deploy in 64bit machine ( 64bit sql server 2005). Are there any know issues that i need to aware of? are they fully comparable?|||

I'm confused, you posted the same question three days ago and you marked the reply I gave you as answered. Are you have some issues?

|||

Anthony Martin wrote:

I'm confused, you posted the same question three days ago and you marked the reply I gave you as answered. Are you have some issues?

safddddddddddddddddddddd ,

Double posting questions does not do any good to the dynamic of the forum. I am merging this thread to the original one.

Thanks Anthony, for pointing that out.
|||

All,

I am trying to execute a ssis package that has OLE DB orale connection( 32bit) in SQL server 2005 machine ( run as a package )...

I've tried

"D:\Program Files\Microsoft SQL Server (x86)\90\DTS\Binn\DTExec.exe" /FILE "C:\SSISPackage\test3.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

to run the package in 32bit mode.. but still getting

Description: The connection manager "oracleconnection" will not acquire a connection because the package OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired. End Error Error: 2007-09-20 13:47:12.61 Code: 0xC020801C Source: Data Flow Task OLE DB Source [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "oracleconnection" failed with error code 0xC0014019. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2007-09-20 13:47:12.61 Code: 0xC004701A Source: Data Flow Task DTS.Pipeline Description... Process Exit Code 1. The step failed.

can you please help!!!

|||The last time we encountered this, reinstalling the SQL client

workstation tools fixed the issue.

|||

thanks jwelch..

Is there any way you can tell me the step by step procedure that I have to take to make OLE DB for oracle work? I have read a couple of posts and it made me more confused..

what kind of drive do i really need, what kind of patch do i have to apply .. and what configurations do i have to change?

|||Unfortunately, it's been a while, so I don't really have step by step documentation.|||

i understand i need to usine 32bit DTExec.exe to run the pakage that has oracle ole db data source..

i've tried .. but it still giving me an error... whatelse should i try ?

|||If you are still getting the "work offline" error meesage, first make sure the package isn't set to Work Offline. If it isn't, then reinstalling the client tools is the only resolution I am aware of.|||

thanks Jwelch..

where do i set the "Work offline" property in package?

|||Under the SSIS menu in BIDS, there is an option that says "Work Offline". Make sure it isn't checked.sql

open up 32bit SSIS package in 64 bit machine ( 64bit sql server)

I have designed a packege using my local machine ( 32bit) and am trying to deploy this package to 64bit machine and open it up.. are there any issues that I need to aware of? 32 bit ssis and 64bit ssis are comparable each other?

If you are using connections that only have 32bit drivers you will have some issues when you try to execute the package (ie: excel). Other than that you won't see any differences, besides performance gains (most likely).

|||

Hi safd*,

Apart from that,

We do have list of Oracle Connectivity issues we need to be aware of, Indeed an adventure to some, see here .

I've summarized the settings we need to be aware of in my blog .

For detailed information download Connectivity and SSIS.doc from Microsoft official site.

Thanks

Subhash Subramanyam

|||I have developed 32bit SSIS package and trying to deploy in 64bit machine ( 64bit sql server 2005). Are there any know issues that i need to aware of? are they fully comparable?|||

I'm confused, you posted the same question three days ago and you marked the reply I gave you as answered. Are you have some issues?

|||

Anthony Martin wrote:

I'm confused, you posted the same question three days ago and you marked the reply I gave you as answered. Are you have some issues?

safddddddddddddddddddddd ,

Double posting questions does not do any good to the dynamic of the forum. I am merging this thread to the original one.

Thanks Anthony, for pointing that out.
|||

All,

I am trying to execute a ssis package that has OLE DB orale connection( 32bit) in SQL server 2005 machine ( run as a package )...

I've tried

"D:\Program Files\Microsoft SQL Server (x86)\90\DTS\Binn\DTExec.exe" /FILE "C:\SSISPackage\test3.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

to run the package in 32bit mode.. but still getting

Description: The connection manager "oracleconnection" will not acquire a connection because the package OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired. End Error Error: 2007-09-20 13:47:12.61 Code: 0xC020801C Source: Data Flow Task OLE DB Source [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "oracleconnection" failed with error code 0xC0014019. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2007-09-20 13:47:12.61 Code: 0xC004701A Source: Data Flow Task DTS.Pipeline Description... Process Exit Code 1. The step failed.

can you please help!!!

|||The last time we encountered this, reinstalling the SQL client

workstation tools fixed the issue.

|||

thanks jwelch..

Is there any way you can tell me the step by step procedure that I have to take to make OLE DB for oracle work? I have read a couple of posts and it made me more confused..

what kind of drive do i really need, what kind of patch do i have to apply .. and what configurations do i have to change?

|||Unfortunately, it's been a while, so I don't really have step by step documentation.|||

i understand i need to usine 32bit DTExec.exe to run the pakage that has oracle ole db data source..

i've tried .. but it still giving me an error... whatelse should i try ?

|||If you are still getting the "work offline" error meesage, first make sure the package isn't set to Work Offline. If it isn't, then reinstalling the client tools is the only resolution I am aware of.|||

thanks Jwelch..

where do i set the "Work offline" property in package?

|||Under the SSIS menu in BIDS, there is an option that says "Work Offline". Make sure it isn't checked.

open up 32bit SSIS package in 64 bit machine ( 64bit sql server)

I have designed a packege using my local machine ( 32bit) and am trying to deploy this package to 64bit machine and open it up.. are there any issues that I need to aware of? 32 bit ssis and 64bit ssis are comparable each other?

If you are using connections that only have 32bit drivers you will have some issues when you try to execute the package (ie: excel). Other than that you won't see any differences, besides performance gains (most likely).

|||

Hi safd*,

Apart from that,

We do have list of Oracle Connectivity issues we need to be aware of, Indeed an adventure to some, see here .

I've summarized the settings we need to be aware of in my blog .

For detailed information download Connectivity and SSIS.doc from Microsoft official site.

Thanks

Subhash Subramanyam

|||I have developed 32bit SSIS package and trying to deploy in 64bit machine ( 64bit sql server 2005). Are there any know issues that i need to aware of? are they fully comparable?|||

I'm confused, you posted the same question three days ago and you marked the reply I gave you as answered. Are you have some issues?

|||

Anthony Martin wrote:

I'm confused, you posted the same question three days ago and you marked the reply I gave you as answered. Are you have some issues?

safddddddddddddddddddddd ,

Double posting questions does not do any good to the dynamic of the forum. I am merging this thread to the original one.

Thanks Anthony, for pointing that out.
|||

All,

I am trying to execute a ssis package that has OLE DB orale connection( 32bit) in SQL server 2005 machine ( run as a package )...

I've tried

"D:\Program Files\Microsoft SQL Server (x86)\90\DTS\Binn\DTExec.exe" /FILE "C:\SSISPackage\test3.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

to run the package in 32bit mode.. but still getting

Description: The connection manager "oracleconnection" will not acquire a connection because the package OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired. End Error Error: 2007-09-20 13:47:12.61 Code: 0xC020801C Source: Data Flow Task OLE DB Source [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "oracleconnection" failed with error code 0xC0014019. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2007-09-20 13:47:12.61 Code: 0xC004701A Source: Data Flow Task DTS.Pipeline Description... Process Exit Code 1. The step failed.

can you please help!!!

|||The last time we encountered this, reinstalling the SQL client

workstation tools fixed the issue.

|||

thanks jwelch..

Is there any way you can tell me the step by step procedure that I have to take to make OLE DB for oracle work? I have read a couple of posts and it made me more confused..

what kind of drive do i really need, what kind of patch do i have to apply .. and what configurations do i have to change?

|||Unfortunately, it's been a while, so I don't really have step by step documentation.|||

i understand i need to usine 32bit DTExec.exe to run the pakage that has oracle ole db data source..

i've tried .. but it still giving me an error... whatelse should i try ?

|||If you are still getting the "work offline" error meesage, first make sure the package isn't set to Work Offline. If it isn't, then reinstalling the client tools is the only resolution I am aware of.|||

thanks Jwelch..

where do i set the "Work offline" property in package?

|||Under the SSIS menu in BIDS, there is an option that says "Work Offline". Make sure it isn't checked.

Open SSIS project error: Unable to cast COM object of type

When I open up my existing SSIS project, I always get this error. Does anyone know what was wrong ?

TITLE: Microsoft Visual Studio

Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{FC4801A3-2BA9-11CF-A229-00AA003D7352}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).

Did you get a solution to this problem? If so could you please post it? I'm having the exact same problem on my development server.

Sincerely

Svein Terje Gaup

|||

I have the same problem as well, anyone know how to solve it?

Many Thanks.

Warren

|||

i got it fixed without knowing how to fix it. it is kind of rediculous.

Can anyone from SSIS team or any SSIS guru answer this ?

Steve

|||

I've no idea but it seems some realated with the apartment for a COM object, maybe STA which is being used

in another thread.

My wonder is why BIDS needs to make a RCW between managed code and unmanaged code when you're going to open it.

|||

Have seen this error several times opening BIDS.

Just close BIDS and open it up again, error gone. Don't know why. I think it happens when I'm a little bit impatient and try to open a recent project while BIDS is not fully up and running yet.

It's a bit annoying, but I don't think it's a serious problem.

Pipo1

|||Have this problem too - any fixes?|||

It seems SQL 2005 does not do a good job to tell us what the error is...

Not sure if you guys did the same task I did, I got the same error when I tried to add a Maintenance Plan. I tried to find the reason/solution but no luck.. and I fixed it not because I found the answer and it is all about security...

My story is...

I set up two clustered SQL 2005 servers and tried to add a maintanience plan by using sa account authentication. However, sa account is not a network account but a SQL account. So I kept getting the error no matter I close/open how many times. And unfortunately SQL 2005 does not report this error "precisely" to me to identify where the problem is... So instead of using my local Management Tools and sa accoutn authentication, I logged in to another server on the same network domain as those two clustered servers. Then I used Management Tool installed on it and Window Authentication account which is the admin account of two clustered servers, and hahaha, it just works like I want it to.

Hope this helps,
Jet

Open SSIS project error: Unable to cast COM object of type

When I open up my existing SSIS project, I always get this error. Does anyone know what was wrong ?

TITLE: Microsoft Visual Studio

Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{FC4801A3-2BA9-11CF-A229-00AA003D7352}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).

Did you get a solution to this problem? If so could you please post it? I'm having the exact same problem on my development server.

Sincerely

Svein Terje Gaup

|||

I have the same problem as well, anyone know how to solve it?

Many Thanks.

Warren

|||

i got it fixed without knowing how to fix it. it is kind of rediculous.

Can anyone from SSIS team or any SSIS guru answer this ?

Steve

|||

I've no idea but it seems some realated with the apartment for a COM object, maybe STA which is being used

in another thread.

My wonder is why BIDS needs to make a RCW between managed code and unmanaged code when you're going to open it.

|||

Have seen this error several times opening BIDS.

Just close BIDS and open it up again, error gone. Don't know why. I think it happens when I'm a little bit impatient and try to open a recent project while BIDS is not fully up and running yet.

It's a bit annoying, but I don't think it's a serious problem.

Pipo1

|||Have this problem too - any fixes?|||

It seems SQL 2005 does not do a good job to tell us what the error is...

Not sure if you guys did the same task I did, I got the same error when I tried to add a Maintenance Plan. I tried to find the reason/solution but no luck.. and I fixed it not because I found the answer and it is all about security...

My story is...

I set up two clustered SQL 2005 servers and tried to add a maintanience plan by using sa account authentication. However, sa account is not a network account but a SQL account. So I kept getting the error no matter I close/open how many times. And unfortunately SQL 2005 does not report this error "precisely" to me to identify where the problem is... So instead of using my local Management Tools and sa accoutn authentication, I logged in to another server on the same network domain as those two clustered servers. Then I used Management Tool installed on it and Window Authentication account which is the admin account of two clustered servers, and hahaha, it just works like I want it to.

Hope this helps,
Jet

|||Hello

Does anyone have the solution to this issue?
Everytime I open a new SSIS package, i get the error
"Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type
'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'. This operation failed because the QueryInterface call on the COM component for the interface...failed due to the following error: Interface not registered."

Which interface do I need to register?

Doesnt happen for other packages, only SSIS.

Thanks!

Open SSIS project error: Unable to cast COM object of type

When I open up my existing SSIS project, I always get this error. Does anyone know what was wrong ?

TITLE: Microsoft Visual Studio

Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{FC4801A3-2BA9-11CF-A229-00AA003D7352}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).

Did you get a solution to this problem? If so could you please post it? I'm having the exact same problem on my development server.

Sincerely

Svein Terje Gaup

|||

I have the same problem as well, anyone know how to solve it?

Many Thanks.

Warren

|||

i got it fixed without knowing how to fix it. it is kind of rediculous.

Can anyone from SSIS team or any SSIS guru answer this ?

Steve

|||

I've no idea but it seems some realated with the apartment for a COM object, maybe STA which is being used

in another thread.

My wonder is why BIDS needs to make a RCW between managed code and unmanaged code when you're going to open it.

|||

Have seen this error several times opening BIDS.

Just close BIDS and open it up again, error gone. Don't know why. I think it happens when I'm a little bit impatient and try to open a recent project while BIDS is not fully up and running yet.

It's a bit annoying, but I don't think it's a serious problem.

Pipo1

|||Have this problem too - any fixes?|||

It seems SQL 2005 does not do a good job to tell us what the error is...

Not sure if you guys did the same task I did, I got the same error when I tried to add a Maintenance Plan. I tried to find the reason/solution but no luck.. and I fixed it not because I found the answer and it is all about security...

My story is...

I set up two clustered SQL 2005 servers and tried to add a maintanience plan by using sa account authentication. However, sa account is not a network account but a SQL account. So I kept getting the error no matter I close/open how many times. And unfortunately SQL 2005 does not report this error "precisely" to me to identify where the problem is... So instead of using my local Management Tools and sa accoutn authentication, I logged in to another server on the same network domain as those two clustered servers. Then I used Management Tool installed on it and Window Authentication account which is the admin account of two clustered servers, and hahaha, it just works like I want it to.

Hope this helps,
Jet

sql

Open SSIS project error: Unable to cast COM object of type

When I open up my existing SSIS project, I always get this error. Does anyone know what was wrong ?

TITLE: Microsoft Visual Studio

Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{FC4801A3-2BA9-11CF-A229-00AA003D7352}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).

Did you get a solution to this problem? If so could you please post it? I'm having the exact same problem on my development server.

Sincerely

Svein Terje Gaup

|||

I have the same problem as well, anyone know how to solve it?

Many Thanks.

Warren

|||

i got it fixed without knowing how to fix it. it is kind of rediculous.

Can anyone from SSIS team or any SSIS guru answer this ?

Steve

|||

I've no idea but it seems some realated with the apartment for a COM object, maybe STA which is being used

in another thread.

My wonder is why BIDS needs to make a RCW between managed code and unmanaged code when you're going to open it.

|||

Have seen this error several times opening BIDS.

Just close BIDS and open it up again, error gone. Don't know why. I think it happens when I'm a little bit impatient and try to open a recent project while BIDS is not fully up and running yet.

It's a bit annoying, but I don't think it's a serious problem.

Pipo1

|||Have this problem too - any fixes?|||

It seems SQL 2005 does not do a good job to tell us what the error is...

Not sure if you guys did the same task I did, I got the same error when I tried to add a Maintenance Plan. I tried to find the reason/solution but no luck.. and I fixed it not because I found the answer and it is all about security...

My story is...

I set up two clustered SQL 2005 servers and tried to add a maintanience plan by using sa account authentication. However, sa account is not a network account but a SQL account. So I kept getting the error no matter I close/open how many times. And unfortunately SQL 2005 does not report this error "precisely" to me to identify where the problem is... So instead of using my local Management Tools and sa accoutn authentication, I logged in to another server on the same network domain as those two clustered servers. Then I used Management Tool installed on it and Window Authentication account which is the admin account of two clustered servers, and hahaha, it just works like I want it to.

Hope this helps,
Jet

Open SSIS project error: Unable to cast COM object of type

When I open up my existing SSIS project, I always get this error. Does anyone know what was wrong ?

TITLE: Microsoft Visual Studio

Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{FC4801A3-2BA9-11CF-A229-00AA003D7352}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).

Did you get a solution to this problem? If so could you please post it? I'm having the exact same problem on my development server.

Sincerely

Svein Terje Gaup

|||

I have the same problem as well, anyone know how to solve it?

Many Thanks.

Warren

|||

i got it fixed without knowing how to fix it. it is kind of rediculous.

Can anyone from SSIS team or any SSIS guru answer this ?

Steve

|||

I've no idea but it seems some realated with the apartment for a COM object, maybe STA which is being used

in another thread.

My wonder is why BIDS needs to make a RCW between managed code and unmanaged code when you're going to open it.

|||

Have seen this error several times opening BIDS.

Just close BIDS and open it up again, error gone. Don't know why. I think it happens when I'm a little bit impatient and try to open a recent project while BIDS is not fully up and running yet.

It's a bit annoying, but I don't think it's a serious problem.

Pipo1

|||Have this problem too - any fixes?|||

It seems SQL 2005 does not do a good job to tell us what the error is...

Not sure if you guys did the same task I did, I got the same error when I tried to add a Maintenance Plan. I tried to find the reason/solution but no luck.. and I fixed it not because I found the answer and it is all about security...

My story is...

I set up two clustered SQL 2005 servers and tried to add a maintanience plan by using sa account authentication. However, sa account is not a network account but a SQL account. So I kept getting the error no matter I close/open how many times. And unfortunately SQL 2005 does not report this error "precisely" to me to identify where the problem is... So instead of using my local Management Tools and sa accoutn authentication, I logged in to another server on the same network domain as those two clustered servers. Then I used Management Tool installed on it and Window Authentication account which is the admin account of two clustered servers, and hahaha, it just works like I want it to.

Hope this helps,
Jet

Open SSIS project error: Unable to cast COM object of type

When I open up my existing SSIS project, I always get this error. Does anyone know what was wrong ?

TITLE: Microsoft Visual Studio

Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{FC4801A3-2BA9-11CF-A229-00AA003D7352}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).

Did you get a solution to this problem? If so could you please post it? I'm having the exact same problem on my development server.

Sincerely

Svein Terje Gaup

|||

I have the same problem as well, anyone know how to solve it?

Many Thanks.

Warren

|||

i got it fixed without knowing how to fix it. it is kind of rediculous.

Can anyone from SSIS team or any SSIS guru answer this ?

Steve

|||

I've no idea but it seems some realated with the apartment for a COM object, maybe STA which is being used

in another thread.

My wonder is why BIDS needs to make a RCW between managed code and unmanaged code when you're going to open it.

|||

Have seen this error several times opening BIDS.

Just close BIDS and open it up again, error gone. Don't know why. I think it happens when I'm a little bit impatient and try to open a recent project while BIDS is not fully up and running yet.

It's a bit annoying, but I don't think it's a serious problem.

Pipo1

|||Have this problem too - any fixes?|||

It seems SQL 2005 does not do a good job to tell us what the error is...

Not sure if you guys did the same task I did, I got the same error when I tried to add a Maintenance Plan. I tried to find the reason/solution but no luck.. and I fixed it not because I found the answer and it is all about security...

My story is...

I set up two clustered SQL 2005 servers and tried to add a maintanience plan by using sa account authentication. However, sa account is not a network account but a SQL account. So I kept getting the error no matter I close/open how many times. And unfortunately SQL 2005 does not report this error "precisely" to me to identify where the problem is... So instead of using my local Management Tools and sa accoutn authentication, I logged in to another server on the same network domain as those two clustered servers. Then I used Management Tool installed on it and Window Authentication account which is the admin account of two clustered servers, and hahaha, it just works like I want it to.

Hope this helps,
Jet

Open SSIS project error: Unable to cast COM object of type

When I open up my existing SSIS project, I always get this error. Does anyone know what was wrong ?

TITLE: Microsoft Visual Studio

Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{FC4801A3-2BA9-11CF-A229-00AA003D7352}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).

Did you get a solution to this problem? If so could you please post it? I'm having the exact same problem on my development server.

Sincerely

Svein Terje Gaup

|||

I have the same problem as well, anyone know how to solve it?

Many Thanks.

Warren

|||

i got it fixed without knowing how to fix it. it is kind of rediculous.

Can anyone from SSIS team or any SSIS guru answer this ?

Steve

|||

I've no idea but it seems some realated with the apartment for a COM object, maybe STA which is being used

in another thread.

My wonder is why BIDS needs to make a RCW between managed code and unmanaged code when you're going to open it.

|||

Have seen this error several times opening BIDS.

Just close BIDS and open it up again, error gone. Don't know why. I think it happens when I'm a little bit impatient and try to open a recent project while BIDS is not fully up and running yet.

It's a bit annoying, but I don't think it's a serious problem.

Pipo1

|||Have this problem too - any fixes?|||

It seems SQL 2005 does not do a good job to tell us what the error is...

Not sure if you guys did the same task I did, I got the same error when I tried to add a Maintenance Plan. I tried to find the reason/solution but no luck.. and I fixed it not because I found the answer and it is all about security...

My story is...

I set up two clustered SQL 2005 servers and tried to add a maintanience plan by using sa account authentication. However, sa account is not a network account but a SQL account. So I kept getting the error no matter I close/open how many times. And unfortunately SQL 2005 does not report this error "precisely" to me to identify where the problem is... So instead of using my local Management Tools and sa accoutn authentication, I logged in to another server on the same network domain as those two clustered servers. Then I used Management Tool installed on it and Window Authentication account which is the admin account of two clustered servers, and hahaha, it just works like I want it to.

Hope this helps,
Jet

Open File - Security Warning

The publisher could not be verified. Are you sure you want to run this software?
This is my first SSIS package and the first for my employer. Under DTS we run some overnight tasks that bin with a .Net console application that downloads data. Several of these run in parallel.

Looked to me that the Execute Process Task was a good fit for the requirements. When I executed the step, the program did begin to execute in that a DOS window opened. But when, I clicked the run button on the warning dialog, the task step ended.

Questions:
1.- How to tell the Execute Process Task not to open the Security Warning dialog?
2.- Have you any suggestions about my approach?

Thanks,
IanO
I am having a very similar issue actually. Any solution will be highly appreciated. I have even tried setting up the group policy and set the batch files/exe file extension to low risk, but that has not helped much either :(|||

Still trying to get past this error! Does anyone have a way to set this up so that the package doesn't ask if we really want to run this program?

Any help would be appreciated,

Dave

|||And what happens when the .Net console application is run from the command line without using SSIS?|||

I have seen this occur also, but only when being run from a network path such as \\myserver.mydomain.slacker.net\f$\MyBatchFile.bat. I found info stating this was because it is being run within the Internet Zone security. (This is because anything with a "." in the name becomes Internet Zone by default - no joke). Had luck changing it to a netbios name like \\myserver\f$\MyBatchFile.bat. I am not saying this is a complete solution but something to consider if you are running from a network path.

On a separate note, if your command line application is a .NET executable it may also need rights assigned via CASPOL (or the Microsoft .NET Framework Configuration Tool) to have enough access to resources.

-David R. K. DeLoveh

|||

It's an attribute of the file. Right click on the file you trying to run, got to properties, click on the Unlock button at the bottom of the dialog.

If you cannot see the unlock button, then this is not the problem

Had the exact same issue a while back.

Open File - Security Warning

The publisher could not be verified. Are you sure you want to run this software?
This is my first SSIS package and the first for my employer. Under DTS we run some overnight tasks that bin with a .Net console application that downloads data. Several of these run in parallel.

Looked to me that the Execute Process Task was a good fit for the requirements. When I executed the step, the program did begin to execute in that a DOS window opened. But when, I clicked the run button on the warning dialog, the task step ended.

Questions:
1.- How to tell the Execute Process Task not to open the Security Warning dialog?
2.- Have you any suggestions about my approach?

Thanks,
IanO

I am having a very similar issue actually. Any solution will be highly appreciated. I have even tried setting up the group policy and set the batch files/exe file extension to low risk, but that has not helped much either :(|||

Still trying to get past this error! Does anyone have a way to set this up so that the package doesn't ask if we really want to run this program?

Any help would be appreciated,

Dave

|||And what happens when the .Net console application is run from the command line without using SSIS?|||

I have seen this occur also, but only when being run from a network path such as \\myserver.mydomain.slacker.net\f$\MyBatchFile.bat. I found info stating this was because it is being run within the Internet Zone security. (This is because anything with a "." in the name becomes Internet Zone by default - no joke). Had luck changing it to a netbios name like \\myserver\f$\MyBatchFile.bat. I am not saying this is a complete solution but something to consider if you are running from a network path.

On a separate note, if your command line application is a .NET executable it may also need rights assigned via CASPOL (or the Microsoft .NET Framework Configuration Tool) to have enough access to resources.

-David R. K. DeLoveh

|||

It's an attribute of the file. Right click on the file you trying to run, got to properties, click on the Unlock button at the bottom of the dialog.

If you cannot see the unlock button, then this is not the problem

Had the exact same issue a while back.

Open File - Security Warning

The publisher could not be verified. Are you sure you want to run this software?
This is my first SSIS package and the first for my employer. Under DTS we run some overnight tasks that bin with a .Net console application that downloads data. Several of these run in parallel.

Looked to me that the Execute Process Task was a good fit for the requirements. When I executed the step, the program did begin to execute in that a DOS window opened. But when, I clicked the run button on the warning dialog, the task step ended.

Questions:
1.- How to tell the Execute Process Task not to open the Security Warning dialog?
2.- Have you any suggestions about my approach?

Thanks,
IanO

I am having a very similar issue actually. Any solution will be highly appreciated. I have even tried setting up the group policy and set the batch files/exe file extension to low risk, but that has not helped much either :(|||

Still trying to get past this error! Does anyone have a way to set this up so that the package doesn't ask if we really want to run this program?

Any help would be appreciated,

Dave

|||And what happens when the .Net console application is run from the command line without using SSIS?|||

I have seen this occur also, but only when being run from a network path such as \\myserver.mydomain.slacker.net\f$\MyBatchFile.bat. I found info stating this was because it is being run within the Internet Zone security. (This is because anything with a "." in the name becomes Internet Zone by default - no joke). Had luck changing it to a netbios name like \\myserver\f$\MyBatchFile.bat. I am not saying this is a complete solution but something to consider if you are running from a network path.

On a separate note, if your command line application is a .NET executable it may also need rights assigned via CASPOL (or the Microsoft .NET Framework Configuration Tool) to have enough access to resources.

-David R. K. DeLoveh

|||

It's an attribute of the file. Right click on the file you trying to run, got to properties, click on the Unlock button at the bottom of the dialog.

If you cannot see the unlock button, then this is not the problem

Had the exact same issue a while back.

Open File - Security Warning

The publisher could not be verified. Are you sure you want to run this software?
This is my first SSIS package and the first for my employer. Under DTS we run some overnight tasks that bin with a .Net console application that downloads data. Several of these run in parallel.

Looked to me that the Execute Process Task was a good fit for the requirements. When I executed the step, the program did begin to execute in that a DOS window opened. But when, I clicked the run button on the warning dialog, the task step ended.

Questions:
1.- How to tell the Execute Process Task not to open the Security Warning dialog?
2.- Have you any suggestions about my approach?

Thanks,
IanO
I am having a very similar issue actually. Any solution will be highly appreciated. I have even tried setting up the group policy and set the batch files/exe file extension to low risk, but that has not helped much either :(|||

Still trying to get past this error! Does anyone have a way to set this up so that the package doesn't ask if we really want to run this program?

Any help would be appreciated,

Dave

|||And what happens when the .Net console application is run from the command line without using SSIS?|||

I have seen this occur also, but only when being run from a network path such as \\myserver.mydomain.slacker.net\f$\MyBatchFile.bat. I found info stating this was because it is being run within the Internet Zone security. (This is because anything with a "." in the name becomes Internet Zone by default - no joke). Had luck changing it to a netbios name like \\myserver\f$\MyBatchFile.bat. I am not saying this is a complete solution but something to consider if you are running from a network path.

On a separate note, if your command line application is a .NET executable it may also need rights assigned via CASPOL (or the Microsoft .NET Framework Configuration Tool) to have enough access to resources.

-David R. K. DeLoveh

|||

It's an attribute of the file. Right click on the file you trying to run, got to properties, click on the Unlock button at the bottom of the dialog.

If you cannot see the unlock button, then this is not the problem

Had the exact same issue a while back.

open an ODBC connection to a DB and must use a connection that looks like this: "DSN=myDSNn

In my ssis package,

I have a DSN connection like this: "DSN=myDSNname". Which decide from i have to pull the data.

By using OLE DB Source Editor, I want to assign that ODBC Connection to it.

By data source Reader i can achive this but where i have to pass the hard-code SQL Query that i don't want.

i'm using the variable for dynamic SQL command.

Thanks.

Manoj

Manoj;

You can use an expression to build dinamically the SQL statement at run time. The explanation on this trhead is for an OLE DB Command transform; but the procedure is the same for a data reader:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1005847&SiteID=1

I hope thsi helps

|||

This is not working in my case.

Lets assume i have a DSN defined in my system.

Now i want to to import export the data.

I have to use the DSN for connecting the Source server and i'm passing my TSQL in the variable.

and for destination i can use OLE-DB or else what ever be fastest way.

my problem is that how can i achive such functionality,

I have to use ODBC for connecting the source server and passingt he variable for executing the TSQL statement.

Thanks

Manoj

|||

Manoj Verma wrote:

I have to use ODBC for connecting the source server and passingt he variable for executing the TSQL statement.

So, what you need is to 'pass' a query to a Data reader component right?

may be I was not clear on my previous post. If you are using a ODBC source; yes you have to use Data Reader as your source component. But Data reader does not allow you to provide the SQL statement via variable; instead you can use an expression to build the query dinamically and overwrite the SQLCommand property of the data reader comoponent. The link I provided in my previous post explains the steps for that. The expression you need to build will have the same logic of the variable you currently have for the SQL query.

|||

thanks

your reply helps us alot.

open an ODBC connection to a DB and must use a connection that looks like this: "DSN=my

In my ssis package,

I have a DSN connection like this: "DSN=myDSNname". Which decide from i have to pull the data.

By using OLE DB Source Editor, I want to assign that ODBC Connection to it.

By data source Reader i can achive this but where i have to pass the hard-code SQL Query that i don't want.

i'm using the variable for dynamic SQL command.

Thanks.

Manoj

Manoj;

You can use an expression to build dinamically the SQL statement at run time. The explanation on this trhead is for an OLE DB Command transform; but the procedure is the same for a data reader:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1005847&SiteID=1

I hope thsi helps

|||

This is not working in my case.

Lets assume i have a DSN defined in my system.

Now i want to to import export the data.

I have to use the DSN for connecting the Source server and i'm passing my TSQL in the variable.

and for destination i can use OLE-DB or else what ever be fastest way.

my problem is that how can i achive such functionality,

I have to use ODBC for connecting the source server and passingt he variable for executing the TSQL statement.

Thanks

Manoj

|||

Manoj Verma wrote:

I have to use ODBC for connecting the source server and passingt he variable for executing the TSQL statement.

So, what you need is to 'pass' a query to a Data reader component right?

may be I was not clear on my previous post. If you are using a ODBC source; yes you have to use Data Reader as your source component. But Data reader does not allow you to provide the SQL statement via variable; instead you can use an expression to build the query dinamically and overwrite the SQLCommand property of the data reader comoponent. The link I provided in my previous post explains the steps for that. The expression you need to build will have the same logic of the variable you currently have for the SQL query.

|||

thanks

your reply helps us alot.

open an ODBC connection to a DB and must use a connection that looks like this: "DSN=my

In my ssis package,

I have a DSN connection like this: "DSN=myDSNname". Which decide from i have to pull the data.

By using OLE DB Source Editor, I want to assign that ODBC Connection to it.

By data source Reader i can achive this but where i have to pass the hard-code SQL Query that i don't want.

i'm using the variable for dynamic SQL command.

Thanks.

Manoj

Manoj;

You can use an expression to build dinamically the SQL statement at run time. The explanation on this trhead is for an OLE DB Command transform; but the procedure is the same for a data reader:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1005847&SiteID=1

I hope thsi helps

|||

This is not working in my case.

Lets assume i have a DSN defined in my system.

Now i want to to import export the data.

I have to use the DSN for connecting the Source server and i'm passing my TSQL in the variable.

and for destination i can use OLE-DB or else what ever be fastest way.

my problem is that how can i achive such functionality,

I have to use ODBC for connecting the source server and passingt he variable for executing the TSQL statement.

Thanks

Manoj

|||

Manoj Verma wrote:

I have to use ODBC for connecting the source server and passingt he variable for executing the TSQL statement.

So, what you need is to 'pass' a query to a Data reader component right?

may be I was not clear on my previous post. If you are using a ODBC source; yes you have to use Data Reader as your source component. But Data reader does not allow you to provide the SQL statement via variable; instead you can use an expression to build the query dinamically and overwrite the SQLCommand property of the data reader comoponent. The link I provided in my previous post explains the steps for that. The expression you need to build will have the same logic of the variable you currently have for the SQL query.

|||

thanks

your reply helps us alot.

OOAD concepts in SSIS

Hi,

Has anyone tried to explore the possibility of inheritence and instantiation within SSIS? For example, a derived column component being used in multiple data flow component or a same lookup component used multiple times in different data flow components.

Something very similiar to defining a class and instantiating it when needed.

Any thoughts?

-AnandSomething similar to the concept of instantiation may be the Execute Package Task.
So considering a package as a logical unit like a container or a task, I imagine that an ipothetical "Execute Internal Task Task" (referred to a task in the control flow prepared once and reusable with different variables value etc..) could be a cool feature.
But I'm referring to Tasks in Control Flow, not to Data Flow trasformations (as you did in your post). A piece of a trasformation isn't a unit of your dts, only the whole Data Flow do is.
|||

Anand Desai wrote:

Hi,

Has anyone tried to explore the possibility of inheritence and instantiation within SSIS? For example, a derived column component being used in multiple data flow component or a same lookup component used multiple times in different data flow components.

Something very similiar to defining a class and instantiating it when needed.

Any thoughts?

-Anand

Yeah, loads of thoughts about it. The lack of reusability, the like of which you're talking about here, is one of main whinges about SSIS (as anyone that reads my blog will tell you).

As Umberto says, the only real way of doing this currently is to siphon functionality off into another package but even when doing this you're only talking about reusing tasks, not components which is what you want to do.

So yeah, lots of things that CAN be done, I've no doubt we'll see great strides made in this area in v2.

-Jamie|||Thanks for your thoughts!!
Using "Execute Package Task" will provide control flow synchronization. However, it doesn't not provide reusable components. At this point, making a single change in the data model trickles through all of my packages and it is quite cumbersome to copy, cut & paste. Also, copy/cut/paste is sometimes corrupting DTSX xml configuration by making lineage ids out of synch. The only way to resolve it is deleting the component and re-adding it.

I hope that we see some major improvements in v2.0 wrt reusability.

-Anand

OnVariableChangedEvent Log Message

I have posted a very simple request to have the message in the SSIS log from an OnVariableValueChanged Event to include the vale the variable has been set to.

If you like the idea of this enhancement please go and vote and validate it here

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=238803

Phil,

What does it have in there currently?

-Jamie

|||Just the name of the variable that changed