ETL library

We are looking for an ETL library or callable application that would
allow us to transfer and transform data between platforms but mainly
into a SQL server database. We would be calling this tool from
javascript programs. Is there something out there in the midrange
price-wise? So far I am finding just high-end ETL tools that are a
little over kill for us.

Thanks."elizabeth" <ezelasky@.hotmail.com> wrote in message
news:78393913.0409150439.818af56@.posting.google.co m...
> We are looking for an ETL library or callable application that would
> allow us to transfer and transform data between platforms but mainly
> into a SQL server database. We would be calling this tool from
> javascript programs. Is there something out there in the midrange
> price-wise? So far I am finding just high-end ETL tools that are a
> little over kill for us.
>
> Thanks.

Have you looked at DTS, which is included with MSSQL? It has a command-line
executable and a COM interface available. See "Data Transformation Services"
in Books Online for more details.

If DTS isn't suitable for you, you might want to be more specific about what
features you require.

Simon|||Folks here felt that DTS was slow (copied record by record) and buggy
that is why I was asked to search for something else. What we need is
fairly basic...to be able to move large amounts of data (in some
cases > 2 gigs) between a variety of sources (flat files, FoxPro &
Dbase) into a SQL Server database. We need to be able to set or
specify the table structure "on-the-fly" thus the reason for calling
it from a scripting environment or another environment.

Thanks.
> Have you looked at DTS, which is included with MSSQL? It has a command-line
> executable and a COM interface available. See "Data Transformation Services"
> in Books Online for more details.
> If DTS isn't suitable for you, you might want to be more specific about what
> features you require.
> Simon|||DTS can use 'fast load' bulk insert techniques to import data. This is the
fastest way to get data into SQL Server. You can create DTS packages 'on
the fly' programmatically and have control over the object model.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"elizabeth" <ezelasky@.hotmail.com> wrote in message
news:78393913.0409151028.7fcc0aca@.posting.google.c om...
> Folks here felt that DTS was slow (copied record by record) and buggy
> that is why I was asked to search for something else. What we need is
> fairly basic...to be able to move large amounts of data (in some
> cases > 2 gigs) between a variety of sources (flat files, FoxPro &
> Dbase) into a SQL Server database. We need to be able to set or
> specify the table structure "on-the-fly" thus the reason for calling
> it from a scripting environment or another environment.
> Thanks.
>>
>> Have you looked at DTS, which is included with MSSQL? It has a
>> command-line
>> executable and a COM interface available. See "Data Transformation
>> Services"
>> in Books Online for more details.
>>
>> If DTS isn't suitable for you, you might want to be more specific about
>> what
>> features you require.
>>
>> Simon|||One alternative is a "roll your own" solution. Create linked servers and
just run UPDATE/INSERT/ SELECT INTO statements. The problem is always
making sure you have the relevant drivers on th dev and production
enviroments. The enclosed link gives most of the connection strings needed.

http://www.able-consulting.com/ADO_Conn.htm

I'll warn you before you start this can get messy.

Regards

Adrian

elizabeth wrote:

> Folks here felt that DTS was slow (copied record by record) and buggy
> that is why I was asked to search for something else. What we need is
> fairly basic...to be able to move large amounts of data (in some
> cases > 2 gigs) between a variety of sources (flat files, FoxPro &
> Dbase) into a SQL Server database. We need to be able to set or
> specify the table structure "on-the-fly" thus the reason for calling
> it from a scripting environment or another environment.
> Thanks.
>>Have you looked at DTS, which is included with MSSQL? It has a command-line
>>executable and a COM interface available. See "Data Transformation Services"
>>in Books Online for more details.
>>
>>If DTS isn't suitable for you, you might want to be more specific about what
>>features you require.
>>
>>Simon

Estimated Query Plan

Hi,

I am writing a client application that shows estimated queries plans and statistics. I know how to obtain estimated plans by using SQL Server Management Studio. But is it possible to obtain by using database functions?

I have found sys.dm_exec_query_plan, but it seems that this function can only be used for executed (or executing) queries...

Thanks

SET SHOWPLAN_XML ON

go

exec YourSP

go

SET SHOWPLAN_XML OFF

go

|||

I do not want to obtain the execution plan for a stored procedure. I do want to use a stored procedure (that may be invoked by a client application) to obtain the execution plan for a user-submmitted query. (It is just like SQL Manager Studio does).

Thanks

Estimated Execution Time

Hi,
Is it possible to know the Estimated Execution Time of a stored procedure
before actual execution from VB/SQL Server Application ?DMP wrote:
> Hi,
> Is it possible to know the Estimated Execution Time of a stored
> procedure before actual execution from VB/SQL Server Application ?
Sure. From Query Analyzer, enter the execution text for the procedure
with the parameters you want and use the Query | Display Estimated
Execution Plan (CTRL + L). You can also use SET SHOWPLAN_ALL ON / OFF in
batches before the procedure to see a textual execution plan.
David Gugick
Imceda Software
www.imceda.com|||Yes of course, just look at this example:
SET SHOWPLAN_ALL ON
GO
Select sc.name,st.name,st.length from syscolumns sc
Inner join sysobjects so on
sc.id = so.id
Inner join systypes st on
sc.xtype = st.xtype
Where so.Xtype = 'U' And
so.name like 'Orders'
GO
SET SHOWPLAN_ALL OFF
GO
SET SHOWPLAN_TEXT ON
GO
Select sc.name,st.name,st.length from syscolumns sc
Inner join sysobjects so on
sc.id = so.id
Inner join systypes st on
sc.xtype = st.xtype
Where so.Xtype = 'U' And
so.name like 'Orders'
GO
SET SHOWPLAN_TEXT OFF
HTH, Jens Smeyer.
"DMP" <debdulal.mahapatra@.fi-tek.co.in> schrieb im Newsbeitrag
news:O2U$n5%23PFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is it possible to know the Estimated Execution Time of a stored procedure
> before actual execution from VB/SQL Server Application ?
>

Errors when running DBCC CheckCatalog command

One of my users reported an error when testing against one of our Development
Servers, against a user databases. The error the application generated
contained the following:
Could not find row in sysindexes for database ID 9, object ID 1284406774,
index ID -1. Run DBCC CHECKTABLE on sysindexes.
I ran DBCC CHECKTABLE (sysindexes) and it came back clean.
I then ran DBCC CHECKDB, which came back clean.
Then, I ran DBCC CHECKALLOC, which came back clean.
Next, I ran DBCC CHECKCATALOG, which gave the following errors:
Server: Msg 2513, Level 16, State 2, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOMMENTS' and 'SYSOBJECTS'.
DBCC results for 'current database'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
I was not too worried, since this was a DEV server, but then I ran the DBCC
CHECKCATAOG command against our QA and then our Production server, and all
of them gave me the same error for the DBCC CHECKCATAOG command.
Any ideas on what I can try next? I don't think this is a corrupt index and
I can't run DBCC DBREINDEX against a system table.
Thank you in advance.
Sam
Are you on 7.0? If so, search KB for 2513, I found a few articles. If you are on 2000, I suggest you
open a case with MS Support for this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:9FF30A6F-9DC1-4DE6-838E-8BA9D1FD15F4@.microsoft.com...
> One of my users reported an error when testing against one of our Development
> Servers, against a user databases. The error the application generated
> contained the following:
> Could not find row in sysindexes for database ID 9, object ID 1284406774,
> index ID -1. Run DBCC CHECKTABLE on sysindexes.
> I ran DBCC CHECKTABLE (sysindexes) and it came back clean.
> I then ran DBCC CHECKDB, which came back clean.
> Then, I ran DBCC CHECKALLOC, which came back clean.
> Next, I ran DBCC CHECKCATALOG, which gave the following errors:
> Server: Msg 2513, Level 16, State 2, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match between
> 'SYSCOMMENTS' and 'SYSOBJECTS'.
> DBCC results for 'current database'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> I was not too worried, since this was a DEV server, but then I ran the DBCC
> CHECKCATAOG command against our QA and then our Production server, and all
> of them gave me the same error for the DBCC CHECKCATAOG command.
> Any ideas on what I can try next? I don't think this is a corrupt index and
> I can't run DBCC DBREINDEX against a system table.
> Thank you in advance.
> Sam
>
>
sql

Errors when running DBCC CheckCatalog command

One of my users reported an error when testing against one of our Development
Servers, against a user databases. The error the application generated
contained the following:
Could not find row in sysindexes for database ID 9, object ID 1284406774,
index ID -1. Run DBCC CHECKTABLE on sysindexes.
I ran DBCC CHECKTABLE (sysindexes) and it came back clean.
I then ran DBCC CHECKDB, which came back clean.
Then, I ran DBCC CHECKALLOC, which came back clean.
Next, I ran DBCC CHECKCATALOG, which gave the following errors:
Server: Msg 2513, Level 16, State 2, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOMMENTS' and 'SYSOBJECTS'.
DBCC results for 'current database'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
I was not too worried, since this was a DEV server, but then I ran the DBCC
CHECKCATAOG command against our QA and then our Production server, and all
of them gave me the same error for the DBCC CHECKCATAOG command.
Any ideas on what I can try next? I don't think this is a corrupt index and
I can't run DBCC DBREINDEX against a system table.
Thank you in advance.
SamAre you on 7.0? If so, search KB for 2513, I found a few articles. If you are on 2000, I suggest you
open a case with MS Support for this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:9FF30A6F-9DC1-4DE6-838E-8BA9D1FD15F4@.microsoft.com...
> One of my users reported an error when testing against one of our Development
> Servers, against a user databases. The error the application generated
> contained the following:
> Could not find row in sysindexes for database ID 9, object ID 1284406774,
> index ID -1. Run DBCC CHECKTABLE on sysindexes.
> I ran DBCC CHECKTABLE (sysindexes) and it came back clean.
> I then ran DBCC CHECKDB, which came back clean.
> Then, I ran DBCC CHECKALLOC, which came back clean.
> Next, I ran DBCC CHECKCATALOG, which gave the following errors:
> Server: Msg 2513, Level 16, State 2, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match between
> 'SYSCOMMENTS' and 'SYSOBJECTS'.
> DBCC results for 'current database'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> I was not too worried, since this was a DEV server, but then I ran the DBCC
> CHECKCATAOG command against our QA and then our Production server, and all
> of them gave me the same error for the DBCC CHECKCATAOG command.
> Any ideas on what I can try next? I don't think this is a corrupt index and
> I can't run DBCC DBREINDEX against a system table.
> Thank you in advance.
> Sam
>
>

Errors when running DBCC CheckCatalog command

One of my users reported an error when testing against one of our Developmen
t
Servers, against a user databases. The error the application generated
contained the following:
Could not find row in sysindexes for database ID 9, object ID 1284406774,
index ID -1. Run DBCC CHECKTABLE on sysindexes.
I ran DBCC CHECKTABLE (sysindexes) and it came back clean.
I then ran DBCC CHECKDB, which came back clean.
Then, I ran DBCC CHECKALLOC, which came back clean.
Next, I ran DBCC CHECKCATALOG, which gave the following errors:
Server: Msg 2513, Level 16, State 2, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 2
Table error: Object ID 823165107 (object '823165107') does not match between
'SYSCOMMENTS' and 'SYSOBJECTS'.
DBCC results for 'current database'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
I was not too worried, since this was a DEV server, but then I ran the DBCC
CHECKCATAOG command against our QA and then our Production server, and all
of them gave me the same error for the DBCC CHECKCATAOG command.
Any ideas on what I can try next? I don't think this is a corrupt index and
I can't run DBCC DBREINDEX against a system table.
Thank you in advance.
SamAre you on 7.0? If so, search KB for 2513, I found a few articles. If you ar
e on 2000, I suggest you
open a case with MS Support for this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:9FF30A6F-9DC1-4DE6-838E-8BA9D1FD15F4@.microsoft.com...
> One of my users reported an error when testing against one of our Developm
ent
> Servers, against a user databases. The error the application generated
> contained the following:
> Could not find row in sysindexes for database ID 9, object ID 1284406774,
> index ID -1. Run DBCC CHECKTABLE on sysindexes.
> I ran DBCC CHECKTABLE (sysindexes) and it came back clean.
> I then ran DBCC CHECKDB, which came back clean.
> Then, I ran DBCC CHECKALLOC, which came back clean.
> Next, I ran DBCC CHECKCATALOG, which gave the following errors:
> Server: Msg 2513, Level 16, State 2, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match betwe
en
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match betwe
en
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match betwe
en
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match betwe
en
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match betwe
en
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 2
> Table error: Object ID 823165107 (object '823165107') does not match betwe
en
> 'SYSCOMMENTS' and 'SYSOBJECTS'.
> DBCC results for 'current database'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> I was not too worried, since this was a DEV server, but then I ran the DBC
C
> CHECKCATAOG command against our QA and then our Production server, and al
l
> of them gave me the same error for the DBCC CHECKCATAOG command.
> Any ideas on what I can try next? I don't think this is a corrupt index an
d
> I can't run DBCC DBREINDEX against a system table.
> Thank you in advance.
> Sam
>
>

Errors in SQL Server 2005 Profiler

I notice this running the SQL Server Profiler under the application name Report Server. Every time it runs, it reports an error (in the Error field of Profiler). Does anyone know what this is?

declare @.p1 nvarchar(64)
set @.p1=NULL
exec GetDBVersion @.DBVersion=@.p1 output
select @.p1

Do you mean when running Reporting Service (or just an application named Report Server?), you found errors with the statements you post? If you're talking about Reporting Service, take a look at this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=277072&SiteId=1

To understand the error, you may take a look at:

http://msdn2.microsoft.com/en-us/library/aa256379(SQL.80).aspx

Errors in Event Log

Hello all,
Not having much joy finding information about the following errors that are
appearing in the Event Viewer under Application:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 04/01/2005
Time: 14:37:09
User: N/A
Computer: SQ01
Description:
17066 :
SQL Server Assertion: File: <proc.c>, line=1576
Failed Assertion = 'm_activeSdesList.Head () == NULL'.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 04/01/2005
Time: 14:37:09
User: N/A
Computer: SQ01
Description:
17310 :
SqlDumpExceptionHandler: Process 3400 generated fatal exception c000001d
EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.
Both errors tend to happen quite a bit, and my Application Event log is
chokka with them.
Can anyone assist? If I've got the wrong newsgroup I do apologise, and
please point me to the correct one.
Thanks :-)
PeterThese are either (most likely) SQL Server bugs or data corruption. First step is to search for them
in BK and see if you find anything and also make sure that you are current on service pack etc. IF
that doesn't fix it, open a case with MS Support.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Peter Blackwell" <nobody@.home.com> wrote in message news:uBfHnKn8EHA.4072@.TK2MSFTNGP10.phx.gbl...
> Hello all,
> Not having much joy finding information about the following errors that are
> appearing in the Event Viewer under Application:
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 04/01/2005
> Time: 14:37:09
> User: N/A
> Computer: SQ01
> Description:
> 17066 :
> SQL Server Assertion: File: <proc.c>, line=1576
> Failed Assertion = 'm_activeSdesList.Head () == NULL'.
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 04/01/2005
> Time: 14:37:09
> User: N/A
> Computer: SQ01
> Description:
> 17310 :
> SqlDumpExceptionHandler: Process 3400 generated fatal exception c000001d
> EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.
> Both errors tend to happen quite a bit, and my Application Event log is
> chokka with them.
> Can anyone assist? If I've got the wrong newsgroup I do apologise, and
> please point me to the correct one.
> Thanks :-)
> Peter
>|||Thanks for posting. Please excuse my ignorance but what is 'BK'?
Many thanks,
Peter
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uVT6SVn8EHA.2568@.TK2MSFTNGP10.phx.gbl...
> These are either (most likely) SQL Server bugs or data corruption. First
step is to search for them
> in BK and see if you find anything and also make sure that you are current
on service pack etc. IF
> that doesn't fix it, open a case with MS Support.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Peter Blackwell" <nobody@.home.com> wrote in message
news:uBfHnKn8EHA.4072@.TK2MSFTNGP10.phx.gbl...
> > Hello all,
> >
> > Not having much joy finding information about the following errors that
are
> > appearing in the Event Viewer under Application:
> > Event Type: Error
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 04/01/2005
> > Time: 14:37:09
> > User: N/A
> > Computer: SQ01
> > Description:
> > 17066 :
> > SQL Server Assertion: File: <proc.c>, line=1576
> > Failed Assertion = 'm_activeSdesList.Head () == NULL'.
> >
> > Event Type: Error
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 04/01/2005
> > Time: 14:37:09
> > User: N/A
> > Computer: SQ01
> > Description:
> > 17310 :
> > SqlDumpExceptionHandler: Process 3400 generated fatal exception c000001d
> > EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.
> >
> > Both errors tend to happen quite a bit, and my Application Event log is
> > chokka with them.
> >
> > Can anyone assist? If I've got the wrong newsgroup I do apologise, and
> > please point me to the correct one.
> >
> > Thanks :-)
> >
> > Peter
> >
> >
>|||I think most of us are just as ignorant about this. It took me a few
moments, but I think he meant KB (KnowledgeBase).
http://support.microsoft.com/search/?adv=1&spid=2852
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Peter Blackwell" <nobody@.home.com> wrote in message
news:%23iuEWYn8EHA.2452@.TK2MSFTNGP14.phx.gbl...
> Thanks for posting. Please excuse my ignorance but what is 'BK'?
> Many thanks,
> Peter
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> message news:uVT6SVn8EHA.2568@.TK2MSFTNGP10.phx.gbl...
>> These are either (most likely) SQL Server bugs or data corruption. First
> step is to search for them
>> in BK and see if you find anything and also make sure that you are
>> current
> on service pack etc. IF
>> that doesn't fix it, open a case with MS Support.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Peter Blackwell" <nobody@.home.com> wrote in message
> news:uBfHnKn8EHA.4072@.TK2MSFTNGP10.phx.gbl...
>> > Hello all,
>> >
>> > Not having much joy finding information about the following errors that
> are
>> > appearing in the Event Viewer under Application:
>> > Event Type: Error
>> > Event Source: MSSQLSERVER
>> > Event Category: (2)
>> > Event ID: 17055
>> > Date: 04/01/2005
>> > Time: 14:37:09
>> > User: N/A
>> > Computer: SQ01
>> > Description:
>> > 17066 :
>> > SQL Server Assertion: File: <proc.c>, line=1576
>> > Failed Assertion = 'm_activeSdesList.Head () == NULL'.
>> >
>> > Event Type: Error
>> > Event Source: MSSQLSERVER
>> > Event Category: (2)
>> > Event ID: 17055
>> > Date: 04/01/2005
>> > Time: 14:37:09
>> > User: N/A
>> > Computer: SQ01
>> > Description:
>> > 17310 :
>> > SqlDumpExceptionHandler: Process 3400 generated fatal exception
>> > c000001d
>> > EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.
>> >
>> > Both errors tend to happen quite a bit, and my Application Event log is
>> > chokka with them.
>> >
>> > Can anyone assist? If I've got the wrong newsgroup I do apologise, and
>> > please point me to the correct one.
>> >
>> > Thanks :-)
>> >
>> > Peter
>> >
>> >
>>
>|||Indeed I did mean KB as in KnowledgeBase. That for picking up on that Kalen. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eC9D3rn8EHA.1264@.TK2MSFTNGP12.phx.gbl...
>I think most of us are just as ignorant about this. It took me a few moments, but I think he meant
>KB (KnowledgeBase).
> http://support.microsoft.com/search/?adv=1&spid=2852
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Peter Blackwell" <nobody@.home.com> wrote in message
> news:%23iuEWYn8EHA.2452@.TK2MSFTNGP14.phx.gbl...
>> Thanks for posting. Please excuse my ignorance but what is 'BK'?
>> Many thanks,
>> Peter
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>> message news:uVT6SVn8EHA.2568@.TK2MSFTNGP10.phx.gbl...
>> These are either (most likely) SQL Server bugs or data corruption. First
>> step is to search for them
>> in BK and see if you find anything and also make sure that you are current
>> on service pack etc. IF
>> that doesn't fix it, open a case with MS Support.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Peter Blackwell" <nobody@.home.com> wrote in message
>> news:uBfHnKn8EHA.4072@.TK2MSFTNGP10.phx.gbl...
>> > Hello all,
>> >
>> > Not having much joy finding information about the following errors that
>> are
>> > appearing in the Event Viewer under Application:
>> > Event Type: Error
>> > Event Source: MSSQLSERVER
>> > Event Category: (2)
>> > Event ID: 17055
>> > Date: 04/01/2005
>> > Time: 14:37:09
>> > User: N/A
>> > Computer: SQ01
>> > Description:
>> > 17066 :
>> > SQL Server Assertion: File: <proc.c>, line=1576
>> > Failed Assertion = 'm_activeSdesList.Head () == NULL'.
>> >
>> > Event Type: Error
>> > Event Source: MSSQLSERVER
>> > Event Category: (2)
>> > Event ID: 17055
>> > Date: 04/01/2005
>> > Time: 14:37:09
>> > User: N/A
>> > Computer: SQ01
>> > Description:
>> > 17310 :
>> > SqlDumpExceptionHandler: Process 3400 generated fatal exception c000001d
>> > EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.
>> >
>> > Both errors tend to happen quite a bit, and my Application Event log is
>> > chokka with them.
>> >
>> > Can anyone assist? If I've got the wrong newsgroup I do apologise, and
>> > please point me to the correct one.
>> >
>> > Thanks :-)
>> >
>> > Peter
>> >
>> >
>>
>>
>

ErrorCode=(288)Attempt to release mutex not owned by caller

I keep getting Critical application Errors every night right at the start of
the scheduled NTbackup. It happens right when the SBS Backup runs @. 11PM.
This is the SQL Server 2005 Workgroup edition that comes with SBS Premium.
During installation, they had
me upgrade the Sharepoint Database to the 2005 version for Full-Test
searching. I went through the process w/o error.
I installed the MS Hotfix but the errors still show up.
Here's all the event log
entries that appear at this exact time during backup:
Event Type: Information
Event Source: ESENT
Event Category: ShadowCopy
Event ID: 2001
Date: 8/13/2007
Time: 11:00:44 PM
User: N/A
Computer: SBSERVER1
Description:
wins (2456) Shadow copy 1 freeze started.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp
----
Event Type: Information
Event Source: MSSQL$SHAREPOINT
Event Category: (2)
Event ID: 3197
Date: 8/13/2007
Time: 11:00:44 PM
User: NT AUTHORITY\SYSTEM
Computer: SBSERVER1
Description:
I/O is frozen on database model. No user action is required. However, if I/O
is not resumed promptly, you could cancel the backup.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7d 0c 00 00 0a 00 00 00 }......
0008: 15 00 00 00 53 00 42 00 ...S.B.
0010: 53 00 45 00 52 00 56 00 S.E.R.V.
0018: 45 00 52 00 31 00 5c 00 E.R.1.\.
0020: 53 00 48 00 41 00 52 00 S.H.A.R.
0028: 45 00 50 00 4f 00 49 00 E.P.O.I.
0030: 4e 00 54 00 00 00 06 00 N.T....
0038: 00 00 6d 00 6f 00 64 00 ..m.o.d.
0040: 65 00 6c 00 00 00 e.l...
-----
============================================ ***The above message is the same for all the db's...about 7***
============================================ Event Type: Information
Event Source: ESENT
Event Category: ShadowCopy
Event ID: 2003
Date: 8/13/2007
Time: 11:00:46 PM
User: N/A
Computer: SBSERVER1
Description:
wins (2456) Shadow copy 1 freeze stopped.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp
----
Event Type: Error
Event Source: SQLVDI
Event Category: None
Event ID: 1
Date: 8/13/2007
Time: 11:00:46 PM
User: N/A
Computer: SBSERVER1
Description:
SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex).
ErrorCode=(288)Attempt to release mutex not owned by caller.
. Process=2256. Thread=3220. Client. Instance=SBSMONITORING. VD=.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp
----
It seems to be related to the SBSMONITORING DB's.
Please help. I'm at a loss.
-JoeFWe had a similar problem when backing up databases. Some process had not
released the mutex tables and we ending up restating the server in order to
free it. Hopefully doing this might help you.
If this is not an option download Process Explorer from sysinternals to
see if it can pinpoint the problem. You may be able to free the process
preventing backups,
"JoeF" wrote:
> I keep getting Critical application Errors every night right at the start of
> the scheduled NTbackup. It happens right when the SBS Backup runs @. 11PM.
> This is the SQL Server 2005 Workgroup edition that comes with SBS Premium.
> During installation, they had
> me upgrade the Sharepoint Database to the 2005 version for Full-Test
> searching. I went through the process w/o error.
> I installed the MS Hotfix but the errors still show up.
> Here's all the event log
> entries that appear at this exact time during backup:
> Event Type: Information
> Event Source: ESENT
> Event Category: ShadowCopy
> Event ID: 2001
> Date: 8/13/2007
> Time: 11:00:44 PM
> User: N/A
> Computer: SBSERVER1
> Description:
> wins (2456) Shadow copy 1 freeze started.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> ----
> Event Type: Information
> Event Source: MSSQL$SHAREPOINT
> Event Category: (2)
> Event ID: 3197
> Date: 8/13/2007
> Time: 11:00:44 PM
> User: NT AUTHORITY\SYSTEM
> Computer: SBSERVER1
> Description:
> I/O is frozen on database model. No user action is required. However, if I/O
> is not resumed promptly, you could cancel the backup.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 7d 0c 00 00 0a 00 00 00 }......
> 0008: 15 00 00 00 53 00 42 00 ...S.B.
> 0010: 53 00 45 00 52 00 56 00 S.E.R.V.
> 0018: 45 00 52 00 31 00 5c 00 E.R.1.\.
> 0020: 53 00 48 00 41 00 52 00 S.H.A.R.
> 0028: 45 00 50 00 4f 00 49 00 E.P.O.I.
> 0030: 4e 00 54 00 00 00 06 00 N.T....
> 0038: 00 00 6d 00 6f 00 64 00 ..m.o.d.
> 0040: 65 00 6c 00 00 00 e.l...
> -----
> ============================================> ***The above message is the same for all the db's...about 7***
> ============================================> Event Type: Information
> Event Source: ESENT
> Event Category: ShadowCopy
> Event ID: 2003
> Date: 8/13/2007
> Time: 11:00:46 PM
> User: N/A
> Computer: SBSERVER1
> Description:
> wins (2456) Shadow copy 1 freeze stopped.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> ----
> Event Type: Error
> Event Source: SQLVDI
> Event Category: None
> Event ID: 1
> Date: 8/13/2007
> Time: 11:00:46 PM
> User: N/A
> Computer: SBSERVER1
> Description:
> SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex).
> ErrorCode=(288)Attempt to release mutex not owned by caller.
> . Process=2256. Thread=3220. Client. Instance=SBSMONITORING. VD=.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> ----
> It seems to be related to the SBSMONITORING DB's.
> Please help. I'm at a loss.
> -JoeF

Error:sql mobile encountered problems when opening the database

I am trying to deploy my mobile app to treo 700wx, but when i test the app, the application gives me an error message:

sql mobile encountered problems when opening the database

It happens when I sync data.

However, when I sync data users and customer info, it doesn't give this message, But when I sync (third time) order info, this message comes out.

--when i run on my PPC (HP ra1950), there is no this error message.

I think it is a bug?

BTW, which cabs file should I install on the Treo phone? (.Net ce, sql ce mobile30 ?)

Please help me out. Thanks

James

This problem may be caused by not disposing the replication object. Make sure you always dispose all the data related objects.

These 2 forum entries refer to this problem:

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

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478902&SiteID=1|||It may be caused by the System.Data.SqlServerCe versioning. if you are doing merge replication in using VS orcas you need to use the compact edition 3.5 instead of 9.0.242.0 Syatem.Data.SqlServerCe assembly. if you insist of using the 9.0242.0 then you need to add those compact 3.5 edition 7's .dlls in to your execution directory. The dlls are sqlceca30.dll, sqlcecompact30.dll, sqlceer30EN.dll, sqlceme30.dll, sqlceoledb30.dll, sqlceqp30.dll, sqlcese30.dll. Try to remove and add the assembly.

Error:sql mobile encountered problems when opening the database

I am trying to deploy my mobile app to treo 700wx, but when i test the app, the application gives me an error message:

sql mobile encountered problems when opening the database

It happens when I sync data.

However, when I sync data users and customer info, it doesn't give this message, But when I sync (third time) order info, this message comes out.

--when i run on my PPC (HP ra1950), there is no this error message.

I think it is a bug?

BTW, which cabs file should I install on the Treo phone? (.Net ce, sql ce mobile30 ?)

Please help me out. Thanks

James

This problem may be caused by not disposing the replication object. Make sure you always dispose all the data related objects.

These 2 forum entries refer to this problem:

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

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478902&SiteID=1
|||It may be caused by the System.Data.SqlServerCe versioning. if you are doing merge replication in using VS orcas you need to use the compact edition 3.5 instead of 9.0.242.0 Syatem.Data.SqlServerCe assembly. if you insist of using the 9.0242.0 then you need to add those compact 3.5 edition 7's .dlls in to your execution directory. The dlls are sqlceca30.dll, sqlcecompact30.dll, sqlceer30EN.dll, sqlceme30.dll, sqlceoledb30.dll, sqlceqp30.dll, sqlcese30.dll. Try to remove and add the assembly.

Error:602,Severity:21,State:4

Hi,

In my application i used to do the take the backup of current

database and restore it with a backup which was taken earlier and

execute a select command on a particular table.

My problem is,backup & restore operations get completed

successfully but error is raised when tried to open a recordset

for a select statement.Following error was recorded in the sql

error log.

Error: 602, Severity: 21, State: 4

Could not find row in sysindexes for database ID 15, object ID

1109578991, index ID 1. Run DBCC CHECKTABLE on sysindexes..

After this i terminated my application and repeated the above

operation this time i got the same error but with index ID 0 but

the database id and object id remained the same.

When scanned the sysobjects for the particular objectid and i

found out that the id belong to a SP - dt_setpropertybyid_u

I have encountered the same problem three times,but after that i

did not get the problem

Regards

I would suggest running a CHECKDB on the database. If the database is too large find out which tables the query touches and run a CHECKTABLE on the those tables.

The following article could be helpful:

http://msdn2.microsoft.com/en-us/library/aa258727(SQL.80).aspx

http://msdn2.microsoft.com/en-us/library/aa258762(sql.80).aspx

HTH

error:26 when connecting to sql server express...

I've got an ASP.net 2.0 application that I published and moved to a publicly available server. From my machine it works fine, but not from the production machine.

I'm attempting to connect to a machine that has sql server express installed.

The message in the browser:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

So, I went by the kb article and made sure tcpip is enabled. This uses port 3288. server browser is enabled and the machine accepts remote connections.My connection string is (minus the ip & user/pwd):

<add name="IRRMAConnectionString" connectionString="Data Source=<ip_address>\SQLEXPRESS,3288;Initial Catalog=IRRMA;User ID=<user>;password=<pwd>" providerName="System.Data.SqlClient"/>

I can ping the db server from my app server. On my dev machine it connects. Windows firewall is turned off on the db server.

This seems to be an issue with a firewall, I think?

Any direction would be appreciated.

Thanks,

Scott Jones

Scott@.fourindianajones.com

You should check this out and go from there.

http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

I would say it has to do with the UDP 1434 or the sqlbrowser.exe in the exceptions. But once you follow all the steps you should get closer to the resolution.

error:26 when connecting to sql server express...

I've got an ASP.net 2.0 application that I published and moved to a publicly available server. From my machine it works fine, but not from the production machine.

I'm attempting to connect to a machine that has sql server express installed.

The message in the browser:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

So, I went by the kb article and made sure tcpip is enabled. This uses port 3288. server browser is enabled and the machine accepts remote connections.My connection string is (minus the ip & user/pwd):

<add name="IRRMAConnectionString" connectionString="Data Source=<ip_address>\SQLEXPRESS,3288;Initial Catalog=IRRMA;User ID=<user>;password=<pwd>" providerName="System.Data.SqlClient"/>

I can ping the db server from my app server. On my dev machine it connects. Windows firewall is turned off on the db server.

This seems to be an issue with a firewall, I think?

Any direction would be appreciated.

Thanks,

Scott Jones

Scott@.fourindianajones.com

You should check this out and go from there.

http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

I would say it has to do with the UDP 1434 or the sqlbrowser.exe in the exceptions. But once you follow all the steps you should get closer to the resolution.

Error:20533.Unable to Open Database

In my project I have used VB 6 and CR 8. In my machine the application is working fine. When it was loaded in the customer machine with windows 98 OS, when the report is clicked, it shows the error 'Error:20533 Unable to Open Database'. The Back end used is MS Access. Anybody pl. guide me to install my project? What to do and how to do?

Pl. post your reply due to urgency.Case 1)If u r running ur exe at client side u must place ur Database at the location u have given to ur DSN
Case 2)If u have installed ur setup at client side and just want to replace exe then check whethere u r replacing ur exe in the folder that has been installed on m/c|||Tried. But getting the same error.|||Open the Report and Do verify Database and map the columns if any|||Verify database. In my machine it works. I haven't installed the CR in the client machine. HOw to set right this problem. Is it necessary to load the CR in the client side? Pl. help
Meenakshi.R|||Did you use DSN to connect to CR?|||I haven't used any DSN for CR inthe client side. How to create that DSN for CR? pl. explain.|||How do you connect CR to database? Did you use OLE DB?
Create a DSN pointing to that DB and design reports. In the Client system create the same DSN and point it to that DB.

Otherwise refer this
http://www.businessobjects.com/support/default.asp

Error: Timeout Expired

I have an Update stored procedure that is used to update four tables at the same time. The issue is that it works perfect when i run the application in local server,but when i upload the application on to the server that is located in U.S, it gives an error "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

I think the sqlCommand is timing out and the value is not returned. Is there a workaround to this issue? What could be the reason for this?

Any ideas.. Please help..

Do any of the tables you are tying to update have indexes on them? If not, adding indexes might help.

Ryan

|||How long will it takes to complete update on the local? Try to set the SqlCommand.CommandTimeout (default to 30 secs) to a larger value, as well as the SqlConnection.ConnectionTimeout.|||I haven't given any indexes.. But usually indexes are helpful when you perform a search on the data , rt? Will it help if while i update a table.. Im not sure.. could you give me more info on this? pls..|||I tried specifying the CommandTimeout to a larger value (4 minutes) and it still times out.. Is there a diff approach?|||

Developer_.NET:

I haven't given any indexes.. But usually indexes are helpful when you perform a search on the data , rt? Will it help if while i update a table.. Im not sure.. could you give me more info on this? pls..

Seehttp://www.odetocode.com/Articles/70.aspx.

Ryan

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pipelin

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pipelin

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pipelin

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pip

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.