Intermittent ole db error

I have this problem occuring intermittently:

When I try to add a package to the project, and click on the Package path button. I get a oledb error x080004005 (client unable to establish connection)...

After I click ok, and click on the Package path again 2 or 3 times, the error goes away and I get the list of packages displayed. Some time I get an empty list box.

Similar to this happens when I execute a package also. When I execute it 2nd or 3 rd time it works fine. The error happens only when I am trying to connect to the server\database. Once it is in the database I do not get any error message.

This is what I have:

I have sql 2005 installed.

Microsoft SQL Server Management Studio 9.00.1399.00

Microsoft Analysis Services Client Tools2005.090.1399.00

Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)

Thank you in advance!!!

Well, what database are you connecting to in your OLE DB connector?|||It should be the msdb database since the ssis packages reside there, right?|||No. What source database are you getting your data from in the data flow?|||

Let me clarify:

I have a project. From the solution explorer window, I right click on "SSIS Packages" and choose "Add Existing Package".

In the window that pops I choose "SQL server" for the "Package Location" and I choose my server name for the "server" and when I click on the button next to the "Package path" I get intermittent ole db errors.

Some times I do not get errors and the list of packages get displayed. Some times it takes one, two or three tries and then I get the list.

Again Thanks for your help.

|||Yes, but what the data flow looks like...what Databases is the apckage using as Source and destination. Also provide the full errror message.|||

There are many packages(about 20) in the server and each package uses different databases in that server. In the problem I explained before I have not yet connected to any package. I am just trying to add a package to my project.

For Example, some package is used to bulk insert a file to a table and for that package source is the "flat file" and the destination is a "Native ole db\sql native client". Again, my problem is not executing the package. The intermittent problem is adding the package to my project.

Thank you.

intermittent OLE DB error

I have this problem occuring intermittently:

When I try to add a package to the project, and click on the Package
path button. I get a oledb error x080004005 (client unable to
establish connection)...

After I click ok, and click on the Package path again 2 or 3 times,
the error goes away and I get the list of packages displayed. Some
time I get an empty list box.

Similar to this happens when I execute a package also. When I execute
it 2nd or 3 rd time it works fine. The error happens only when I am
trying to connect to the server\database. Once it is in the database
I do not get any error message.

This is what I have:

I have sql 2005 installed.

Microsoft SQL Server Management
Studio
9.00.1399.00

Microsoft Analysis Services Client
Tools
2005.090.1399.00

Microsoft Data Access Components
(MDAC)
2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)

Thank you in advance!!!(gelangov@.hotmail.com) writes:

Quote:

Originally Posted by

After I click ok, and click on the Package path again 2 or 3 times,
the error goes away and I get the list of packages displayed. Some
time I get an empty list box.
>
Similar to this happens when I execute a package also. When I execute
it 2nd or 3 rd time it works fine. The error happens only when I am
trying to connect to the server\database. Once it is in the database
I do not get any error message.

I have no idea what this may be. However, I noted one thing:

Quote:

Originally Posted by

I have sql 2005 installed.
>
Microsoft SQL Server Management
Studio
9.00.1399.00
>
Microsoft Analysis Services Client
Tools
2005.090.1399.00

This is the RTM version of SQL 2005. There is an SP1 out. There is also an
SP2 in progress, currently a preview of SP2 is available. I would recommend
that you download an install SP1, and that you keep an eye open for the
release of SP2. No promises that it will resolve your problem, though.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thank you, Erland...I will try that!

On Jan 29, 6:07 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

(gelan...@.hotmail.com) writes:

Quote:

Originally Posted by

After I click ok, and click on the Package path again 2 or 3 times,
the error goes away and I get the list of packages displayed. Some
time I get an empty list box.

>

Quote:

Originally Posted by

Similar to this happens when I execute a package also. When I execute
it 2nd or 3 rd time it works fine. The error happens only when I am
trying to connect to the server\database. Once it is in the database
I do not get any error message.I have no idea what this may be. However, I noted one thing:

>

Quote:

Originally Posted by

I have sql 2005 installed.

>

Quote:

Originally Posted by

Microsoft SQL Server Management
Studio
9.00.1399.00

>

Quote:

Originally Posted by

Microsoft Analysis Services Client
Tools
2005.090.1399.00This is the RTM version of SQL 2005. There is an SP1 out. There is also an

SP2 in progress, currently a preview of SP2 is available. I would recommend
that you download an install SP1, and that you keep an eye open for the
release of SP2. No promises that it will resolve your problem, though.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Interactive sorting of a list

I have a list data region that has column headings outside the list. I would like to be able to click a column heading and sort the list. However I cannot do this because the scope of the header can't access the list. Has anyone sorted a list by clicking textbox column headings? Please help.

Hi Patrick-

In general, when applying a user sort, you can sort items that are at the same scope, or are in a child scope. You might try setting the textbox to sort on the data set wihch the list is using, and then set the sort expression scope to details. If you are using RS 2005, I've included a sample RDL below. Just copy the text to a file, rename the extension to .rdl and open it in report designer.

-Jon

<?xml version="1.0" encoding="utf-8"?>

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<DataSources>

<DataSource Name="DataSource1">

<ConnectionProperties>

<IntegratedSecurity>true</IntegratedSecurity>

<ConnectString />

<DataProvider>XML</DataProvider>

</ConnectionProperties>

<rd:DataSourceID>8d7185f8-cc23-497e-a4a0-cb6c5ec79844</rd:DataSourceID>

</DataSource>

</DataSources>

<BottomMargin>1in</BottomMargin>

<RightMargin>1in</RightMargin>

<rd:DrawGrid>true</rd:DrawGrid>

<InteractiveWidth>8.5in</InteractiveWidth>

<rd:SnapToGrid>true</rd:SnapToGrid>

<Body>

<ReportItems>

<Textbox Name="textbox1">

<Left>1.25in</Left>

<Top>0.5in</Top>

<rd:DefaultName>textbox1</rd:DefaultName>

<ZIndex>1</ZIndex>

<Width>1in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<UserSort>

<SortTarget>DataSet1</SortTarget>

<SortExpression>=Count(Fields!Col.Value, "DataSet1")</SortExpression>

</UserSort>

<Value>SORT</Value>

</Textbox>

<List Name="list1">

<Left>1in</Left>

<ReportItems>

<Textbox Name="Col">

<Left>0.625in</Left>

<Top>0.375in</Top>

<rd:DefaultName>Col</rd:DefaultName>

<Width>1in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>=Fields!Col.Value</Value>

</Textbox>

</ReportItems>

<DataSetName>DataSet1</DataSetName>

<Top>1in</Top>

<Width>2in</Width>

<Height>1in</Height>

</List>

</ReportItems>

<Height>2.75in</Height>

</Body>

<rd:ReportID>50318574-728b-4b7c-a2f9-82ab09948b39</rd:ReportID>

<LeftMargin>1in</LeftMargin>

<DataSets>

<DataSet Name="DataSet1">

<Query>

<CommandText>&lt;Query&gt;&lt;XmlData&gt;&lt;Root&gt;&lt;Col&gt;1&lt;/Col&gt;&lt;Col&gt;2&lt;/Col&gt;&lt;Col&gt;3&lt;/Col&gt;&lt;/Root&gt;&lt;/XmlData&gt;&lt;/Query&gt;</CommandText>

<DataSourceName>DataSource1</DataSourceName>

</Query>

<Fields>

<Field Name="Col">

<rd:TypeName>System.String</rd:TypeName>

<DataField>Col</DataField>

</Field>

</Fields>

</DataSet>

</DataSets>

<Width>6.5in</Width>

<InteractiveHeight>11in</InteractiveHeight>

<Language>en-US</Language>

<TopMargin>1in</TopMargin>

</Report>

Interactive Sort in Matrix

I have a Matrix in a report - created like below. Each row has a different dataset and I need to make each Column to be sortable so they can click on the column header say "Summary of Accounts" and sort them and do that for each column header. So far I havent seen anything that looks promising that can do this. Is there away this can be done?

6 Columns and 14 Rows

--headers

Summary of Accounts No debts origBal AccrInter PaidDate CurrBal

Activity count() Sum() Sum() First() Sum()

phase count() Sum() Sum() First() Sum()

attorney etc etc

collection

not inititated

resolved

interrupted

cancel

closed

revised

letter service

Totals:

The combination of Interactive Sort and Matrix are not good! I managed to get it working but only for row groups.|||I know they are not how about how did you do the row groups? If they can sort by row then fine that is good enough for me then!