显示标签为“loaded”的博文。显示所有博文
显示标签为“loaded”的博文。显示所有博文

2012年3月22日星期四

Flat file destination could not be loaded

Hi,

I have created a package and when i was trying to configure a flat file destination, i am getting the following error:

===================================

The component could not be added to the Data Flow task.
Could not initialize the component. There is a potential problem in the ProvideComponentProperties method. (Microsoft Visual Studio)

===================================

Error at Extract Test Flat File [DTS.Pipeline]: The module containing "component "" (245)" cannot be located, even though it is registered.

===================================

Exception from HRESULT: 0xC0048021 (Microsoft.SqlServer.DTSPipelineWrap)


Program Location:

at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ProvideComponentProperties()
at Microsoft.DataTransformationServices.Design.PipelineTaskDesigner.AddNewComponent(String clsid, Boolean throwOnError)

Please advise.

Thanks & Regards,

Deepak

Was it working before? If yes, what has changed in the meantime?

Thanks,

Bob

Flat file destination could not be loaded

Hi,

I have created a package and when i was trying to configure a flat file destination, i am getting the following error:

===================================

The component could not be added to the Data Flow task.
Could not initialize the component. There is a potential problem in the ProvideComponentProperties method. (Microsoft Visual Studio)

===================================

Error at Extract Test Flat File [DTS.Pipeline]: The module containing "component "" (245)" cannot be located, even though it is registered.

===================================

Exception from HRESULT: 0xC0048021 (Microsoft.SqlServer.DTSPipelineWrap)


Program Location:

at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ProvideComponentProperties()
at Microsoft.DataTransformationServices.Design.PipelineTaskDesigner.AddNewComponent(String clsid, Boolean throwOnError)

Please advise.

Thanks & Regards,

Deepak

Was it working before? If yes, what has changed in the meantime?

Thanks,

Bob

2012年2月26日星期日

first report long loaded

when I start work with my application to load the first report take long time.

after its load good.

my first question is:
Is it possible to load the report server when I start work with my application?

second:
I have a matrix report, is it possible to show all the column, but when I print, to print just the last 4 columns?

thanks alot
and good dayTry this to fasten your report:
Go into IIS >
Open Application Pool (above the "web sites" you probably know) >
Right click your reporting service pool and choose properties >
Choose "performance" tab and remove the selection from the "Shutdown worker process".

You can also try and change (in the first tab) the recycle worker process.
select the "recycle worker process" and give it number of minutes that is about 2-3 days.

HTH,
Roy.