ETL : rows with Errors

I'm using a "Execute SQL Task" to run a stored procedure to populate a Fact table in our dimensional datawarehouse. There is one row which violates a foreign key constraint, which causes the entire task to fail so zero rows are loaded. Is there any way to grab the offending row and send it off to some holding ground and go ahead and load the rest of the rows.

I'm using Execute SQL Task mostly because I am very comfortable with writing SQL whereas the rest of SSIS is a bit unfamiliar to me, but I'm guessing that to handle error rows I might have to change to a different kind of task ?

Thanks

Richard

The best way to do this is to use a lookup in the dataflow to determine if the incoming record violates foreign key rules.

As far as your stored procedure goes, head over to the Transact-SQL forum for help with that.

Errors: SQL Reporting Services with CRM 3.0

Good Day All ...

I am currently trying to install CRM 3.0 onto one of our test servers.
I have managed with no problem to get everything ready for installation ... but having a problem with reporting services.

On the system requirements results page i have green for everything but reporting services.

ERROR;
Specified Reporting Services Reports Server http://XXXXXX/ReportsServer was not found.

I have reporting services installed, can someone please give me some direction on where to go from here to get this up and working.

Thanks

Do you habe any Sharepoint Server installed on the machine or any other program which tries to bind port 80 to itself ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Yes i do have sharepoint installed.
Would you recommend removing that?|||

Hi,

no defintely not, but you should have a look on my site under the Screencast Section, this will whow you a way to solve your problem.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Thanks for all of your help.
Works fine.

Thanks Again ... Great Advice!!|||If this helped please mark post as answer and (for me) rate the screencast and give additional feedback if you want to :-)

HTH, Jens K. SUessmeyer.

http://www.sqlserver2005.de

Errors: Recovery Mode: Full and Simple

Hi
I have a production database that is set to Recovery Mode: Simple.
However I decided to change this to Recovery Mode: Full. A scheduled
backup of the database was then run that night.
Unfortunately I was then told to reset the Recovery Mode back to
Simple as not enough testing had been done. So I did this.
The next day we received error messages that "The log file for the
database is full. Back up the transaction log for the database to free
up some log space."
The production db was then unusable for the apps. As a quick solution
I changed the recovery mode back to full and backed up the transaction
log ( because you cannot backup the transaction log in simple mode).
This made the database operational again.
I then changed the Recovery mode back to simple for the next night's
scheduled backup.
So..... the nightly backup goes ahead with the db still in simple
mode.
HOWEVER we are still getting the log full error messages and I keep
having to change to recovery mode full and backup the transaction log
and then swap back again to simple mode.
I realise that if the database is set to Recovery Mode: Full then the
transaction log must be backed up regularly. But we are no longer
running in Full mode and I don’t not want to run in full mode
and the transaction logs never used to get full in Simple mode and we
never had to back them up.
I would just like things to get back to how they were - the database
running in simple mode and nightly backups taking place. Then those
nightly backups - which are in one file - restoring ok on a test
machine.
Has anyone got any ideas?
Many thanks!
Thiko!Thiko
How large is your transaction log? Even with simple
recovery model the transaction log is still used.
It is just cleared when transactions complete. If you have
some/one very large transaction running on the system you
may still fill up the transaction log even in simple
recovery mode.
If your transaction log is quite small, you may solve your
problem by increasing it.
Regards
Johnsql

Errors: Event Ids 17055 and 19011.

Hi everyone,
Occasionally we get timeout errors in our custom applications, which are
inserting/updating data.
They seem to coincide with the following errors:
Event ID: 19011
SuperSocket info: ConnectionListen(Shared-Memory (LPC)) : Error 5.
Event ID: 17055
17113 :
initconfig: Error 32(error not found) opening 'D:\Microsoft SQL
Server\MSSQL\data\master.mdf' for configuration information.
We cannot determine the cause of the errors.
Any help will be appreciated.
Best Regards.Hi Sezgin,
The symptom is similar to what is described in the
following KB article:
815249 FIX: Performance of a query that is run from a
client program on a SQL
http://support.microsoft.com/?id=815249
You may want to try the workaround first to see if it
works for you.
Generally, random issues can be caused by various
factors, and it is difficult to locate the root cause in
a newsgroup thread. If the issue still exists after you
have tried the workaround in the KB815249, to
efficiently troubleshoot this issue, we recommend that
you contact Microsoft Product Support Services and open
a support incident and work with a dedicated Support
Professional.
Please be advised that contacting phone support will be
a charged call. However, if you are simply requesting a
hotfix be sent to you and no other support then charges
are usually refunded or waived.
To obtain the phone numbers for specific technology
request please take a look at the web site listed below.
http://support.microsoft.com/defaul...scid=fh;EN-US;P
HONENUMBERS
If you are outside the US please see
http://support.microsoft.com for regional support phone
numbers.
If anything is unclear, feel free to let me know.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
This posting is provided "AS IS" with no warranties, and
confers no rights.
--
>From: "Sezgin Rafed" <anonymous@.anonymous.com>
>Subject: Errors: Event Ids 17055 and 19011.
>Date: Wed, 2 Feb 2005 17:51:39 +0200
>Lines: 22
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.181
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
>Message-ID: <#kTmW8TCFHA.3908@.TK2MSFTNGP12.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host:
host-213-194-84-162.borusantelekom.com 213.194.84.162
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.p
hx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.server:376662
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi everyone,
>Occasionally we get timeout errors in our custom
applications, which are
>inserting/updating data.
>They seem to coincide with the following errors:
>Event ID: 19011
>SuperSocket info: ConnectionListen(Shared-Memory (LPC))
: Error 5.
>
>Event ID: 17055
>17113 :
>initconfig: Error 32(error not found) opening
'D:\Microsoft SQL
>Server\MSSQL\data\master.mdf' for configuration
information.
>We cannot determine the cause of the errors.
>Any help will be appreciated.
>Best Regards.
>
>|||We've experienced the same problem and it started when we used
sp_addlinkedserver and began querying that server. Our query was creating
threads that it could not close and created problems.
The MS article you mentioned talked about a hot fix, however, they also said
that the hot fix is in testing.
Does anyone know when the next hot fix will be out?
Thanks!
Ed Klopfenstein
Visual String
Boise, Idaho
"William Wang[MSFT]" wrote:

> Hi Sezgin,
> The symptom is similar to what is described in the
> following KB article:
> 815249 FIX: Performance of a query that is run from a
> client program on a SQL
> http://support.microsoft.com/?id=815249
> You may want to try the workaround first to see if it
> works for you.
> Generally, random issues can be caused by various
> factors, and it is difficult to locate the root cause in
> a newsgroup thread. If the issue still exists after you
> have tried the workaround in the KB815249, to
> efficiently troubleshoot this issue, we recommend that
> you contact Microsoft Product Support Services and open
> a support incident and work with a dedicated Support
> Professional.
> Please be advised that contacting phone support will be
> a charged call. However, if you are simply requesting a
> hotfix be sent to you and no other support then charges
> are usually refunded or waived.
> To obtain the phone numbers for specific technology
> request please take a look at the web site listed below.
> http://support.microsoft.com/defaul...scid=fh;EN-US;P
> HONENUMBERS
> If you are outside the US please see
> http://support.microsoft.com for regional support phone
> numbers.
> If anything is unclear, feel free to let me know.
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> This posting is provided "AS IS" with no warranties, and
> confers no rights.
> --
> host-213-194-84-162.borusantelekom.com 213.194.84.162
> cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.p
> hx.gbl!TK2MSFTNGP12.phx.gbl
> microsoft.public.sqlserver.server:376662
> applications, which are
> : Error 5.
> 'D:\Microsoft SQL
> information.
>

Errors: Event Ids 17055 and 19011.

Hi everyone,
Occasionally we get timeout errors in our custom applications, which are
inserting/updating data.
They seem to coincide with the following errors:
Event ID: 19011
SuperSocket info: ConnectionListen(Shared-Memory (LPC)) : Error 5.
Event ID: 17055
17113 :
initconfig: Error 32(error not found) opening 'D:\Microsoft SQL
Server\MSSQL\data\master.mdf' for configuration information.
We cannot determine the cause of the errors.
Any help will be appreciated.
Best Regards.
Hi Sezgin,
The symptom is similar to what is described in the
following KB article:
815249 FIX: Performance of a query that is run from a
client program on a SQL
http://support.microsoft.com/?id=815249
You may want to try the workaround first to see if it
works for you.
Generally, random issues can be caused by various
factors, and it is difficult to locate the root cause in
a newsgroup thread. If the issue still exists after you
have tried the workaround in the KB815249, to
efficiently troubleshoot this issue, we recommend that
you contact Microsoft Product Support Services and open
a support incident and work with a dedicated Support
Professional.
Please be advised that contacting phone support will be
a charged call. However, if you are simply requesting a
hotfix be sent to you and no other support then charges
are usually refunded or waived.
To obtain the phone numbers for specific technology
request please take a look at the web site listed below.
http://support.microsoft.com/default...cid=fh;EN-US;P
HONENUMBERS
If you are outside the US please see
http://support.microsoft.com for regional support phone
numbers.
If anything is unclear, feel free to let me know.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
This posting is provided "AS IS" with no warranties, and
confers no rights.
--
>From: "Sezgin Rafed" <anonymous@.anonymous.com>
>Subject: Errors: Event Ids 17055 and 19011.
>Date: Wed, 2 Feb 2005 17:51:39 +0200
>Lines: 22
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.181
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
>Message-ID: <#kTmW8TCFHA.3908@.TK2MSFTNGP12.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host:
host-213-194-84-162.borusantelekom.com 213.194.84.162
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.p
hx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.server:376662
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi everyone,
>Occasionally we get timeout errors in our custom
applications, which are
>inserting/updating data.
>They seem to coincide with the following errors:
>Event ID: 19011
>SuperSocket info: ConnectionListen(Shared-Memory (LPC))
: Error 5.
>
>Event ID: 17055
>17113 :
>initconfig: Error 32(error not found) opening
'D:\Microsoft SQL
>Server\MSSQL\data\master.mdf' for configuration
information.
>We cannot determine the cause of the errors.
>Any help will be appreciated.
>Best Regards.
>
>
|||We've experienced the same problem and it started when we used
sp_addlinkedserver and began querying that server. Our query was creating
threads that it could not close and created problems.
The MS article you mentioned talked about a hot fix, however, they also said
that the hot fix is in testing.
Does anyone know when the next hot fix will be out?
Thanks!
Ed Klopfenstein
Visual String
Boise, Idaho
"William Wang[MSFT]" wrote:

> Hi Sezgin,
> The symptom is similar to what is described in the
> following KB article:
> 815249 FIX: Performance of a query that is run from a
> client program on a SQL
> http://support.microsoft.com/?id=815249
> You may want to try the workaround first to see if it
> works for you.
> Generally, random issues can be caused by various
> factors, and it is difficult to locate the root cause in
> a newsgroup thread. If the issue still exists after you
> have tried the workaround in the KB815249, to
> efficiently troubleshoot this issue, we recommend that
> you contact Microsoft Product Support Services and open
> a support incident and work with a dedicated Support
> Professional.
> Please be advised that contacting phone support will be
> a charged call. However, if you are simply requesting a
> hotfix be sent to you and no other support then charges
> are usually refunded or waived.
> To obtain the phone numbers for specific technology
> request please take a look at the web site listed below.
> http://support.microsoft.com/default...cid=fh;EN-US;P
> HONENUMBERS
> If you are outside the US please see
> http://support.microsoft.com for regional support phone
> numbers.
> If anything is unclear, feel free to let me know.
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> This posting is provided "AS IS" with no warranties, and
> confers no rights.
> --
> host-213-194-84-162.borusantelekom.com 213.194.84.162
> cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.p
> hx.gbl!TK2MSFTNGP12.phx.gbl
> microsoft.public.sqlserver.server:376662
> applications, which are
> : Error 5.
> 'D:\Microsoft SQL
> information.
>

Errors: Event Ids 17055 and 19011.

Hi everyone,
Occasionally we get timeout errors in our custom applications, which are
inserting/updating data.
They seem to coincide with the following errors:
Event ID: 19011
SuperSocket info: ConnectionListen(Shared-Memory (LPC)) : Error 5.
Event ID: 17055
17113 :
initconfig: Error 32(error not found) opening 'D:\Microsoft SQL
Server\MSSQL\data\master.mdf' for configuration information.
We cannot determine the cause of the errors.
Any help will be appreciated.
Best Regards.Hi Sezgin,
The symptom is similar to what is described in the
following KB article:
815249 FIX: Performance of a query that is run from a
client program on a SQL
http://support.microsoft.com/?id=815249
You may want to try the workaround first to see if it
works for you.
Generally, random issues can be caused by various
factors, and it is difficult to locate the root cause in
a newsgroup thread. If the issue still exists after you
have tried the workaround in the KB815249, to
efficiently troubleshoot this issue, we recommend that
you contact Microsoft Product Support Services and open
a support incident and work with a dedicated Support
Professional.
Please be advised that contacting phone support will be
a charged call. However, if you are simply requesting a
hotfix be sent to you and no other support then charges
are usually refunded or waived.
To obtain the phone numbers for specific technology
request please take a look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;P
HONENUMBERS
If you are outside the US please see
http://support.microsoft.com for regional support phone
numbers.
If anything is unclear, feel free to let me know.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
This posting is provided "AS IS" with no warranties, and
confers no rights.
--
>From: "Sezgin Rafed" <anonymous@.anonymous.com>
>Subject: Errors: Event Ids 17055 and 19011.
>Date: Wed, 2 Feb 2005 17:51:39 +0200
>Lines: 22
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.181
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
>Message-ID: <#kTmW8TCFHA.3908@.TK2MSFTNGP12.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host:
host-213-194-84-162.borusantelekom.com 213.194.84.162
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.p
hx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.server:376662
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi everyone,
>Occasionally we get timeout errors in our custom
applications, which are
>inserting/updating data.
>They seem to coincide with the following errors:
>Event ID: 19011
>SuperSocket info: ConnectionListen(Shared-Memory (LPC))
: Error 5.
>
>Event ID: 17055
>17113 :
>initconfig: Error 32(error not found) opening
'D:\Microsoft SQL
>Server\MSSQL\data\master.mdf' for configuration
information.
>We cannot determine the cause of the errors.
>Any help will be appreciated.
>Best Regards.
>
>|||We've experienced the same problem and it started when we used
sp_addlinkedserver and began querying that server. Our query was creating
threads that it could not close and created problems.
The MS article you mentioned talked about a hot fix, however, they also said
that the hot fix is in testing.
Does anyone know when the next hot fix will be out?
Thanks!
Ed Klopfenstein
Visual String
Boise, Idaho
"William Wang[MSFT]" wrote:
> Hi Sezgin,
> The symptom is similar to what is described in the
> following KB article:
> 815249 FIX: Performance of a query that is run from a
> client program on a SQL
> http://support.microsoft.com/?id=815249
> You may want to try the workaround first to see if it
> works for you.
> Generally, random issues can be caused by various
> factors, and it is difficult to locate the root cause in
> a newsgroup thread. If the issue still exists after you
> have tried the workaround in the KB815249, to
> efficiently troubleshoot this issue, we recommend that
> you contact Microsoft Product Support Services and open
> a support incident and work with a dedicated Support
> Professional.
> Please be advised that contacting phone support will be
> a charged call. However, if you are simply requesting a
> hotfix be sent to you and no other support then charges
> are usually refunded or waived.
> To obtain the phone numbers for specific technology
> request please take a look at the web site listed below.
> http://support.microsoft.com/default.aspx?scid=fh;EN-US;P
> HONENUMBERS
> If you are outside the US please see
> http://support.microsoft.com for regional support phone
> numbers.
> If anything is unclear, feel free to let me know.
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> This posting is provided "AS IS" with no warranties, and
> confers no rights.
> --
> >From: "Sezgin Rafed" <anonymous@.anonymous.com>
> >Subject: Errors: Event Ids 17055 and 19011.
> >Date: Wed, 2 Feb 2005 17:51:39 +0200
> >Lines: 22
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 6.00.3790.181
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
> >Message-ID: <#kTmW8TCFHA.3908@.TK2MSFTNGP12.phx.gbl>
> >Newsgroups: microsoft.public.sqlserver.server
> >NNTP-Posting-Host:
> host-213-194-84-162.borusantelekom.com 213.194.84.162
> >Path:
> cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.p
> hx.gbl!TK2MSFTNGP12.phx.gbl
> >Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.server:376662
> >X-Tomcat-NG: microsoft.public.sqlserver.server
> >
> >Hi everyone,
> >
> >Occasionally we get timeout errors in our custom
> applications, which are
> >inserting/updating data.
> >They seem to coincide with the following errors:
> >
> >Event ID: 19011
> >SuperSocket info: ConnectionListen(Shared-Memory (LPC))
> : Error 5.
> >
> >
> >Event ID: 17055
> >17113 :
> >initconfig: Error 32(error not found) opening
> 'D:\Microsoft SQL
> >Server\MSSQL\data\master.mdf' for configuration
> information.
> >
> >We cannot determine the cause of the errors.
> >
> >Any help will be appreciated.
> >
> >Best Regards.
> >
> >
> >
>

errors... lots of errors.

Good Morning...
Any thoughts...
Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionWrite
(WrapperWrite()).Native error: 4 SQLState: 01000}{[Microsoft][ODBC SQL
Server Driver][Shared Memory]General network error. Check your network
documentation.Native error: 11 SQLState: 08S01}
The following information is part of the event:
IDBInitialize::Initialize, 0x80040e4d, SQLSTATE: 42000, Native Error:
18456
Error state: 1, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: Login failed for user 'NT AUTHORITY\SYSTEM'.
Help and Support for details. The following information is part of the
event: 18456, Login failed for user 'NT AUTHORITY\SYSTEM'.
The following information is part of the event:
IDBInitialize::Initialize, 0x80040e4d, SQLSTATE: 42000, Native Error:
18456
Error state: 1, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: Login failed for user 'NT AUTHORITY\SYSTEM'.
.Heather,
If I had to take a gues I would say someone has removed the build-in
Administrators group from SQL Server without adding a Login for the
local system account. Now the server tries to start, but because the
login doen't exist anymore you get these errors. Change the service
logon account to a domain account which has administrative access to
SQL Server and you should be able to start the server again.
Markus

errors... lots of errors.

Good Morning...
Any thoughts...
Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionWrite
(WrapperWrite()).Native error: 4 SQLState: 01000}{[Microsoft][O
DBC SQL
Server Driver][Shared Memory]General network error. Check your network
documentation.Native error: 11 SQLState: 08S01}
The following information is part of the event:
IDBInitialize::Initialize, 0x80040e4d, SQLSTATE: 42000, Native Error:
18456
Error state: 1, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: Login failed for user 'NT AUTHORITY\SYSTEM'.
Help and Support for details. The following information is part of the
event: 18456, Login failed for user 'NT AUTHORITY\SYSTEM'.
The following information is part of the event:
IDBInitialize::Initialize, 0x80040e4d, SQLSTATE: 42000, Native Error:
18456
Error state: 1, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: Login failed for user 'NT AUTHORITY\SYSTEM'.
.Heather,
If I had to take a gues I would say someone has removed the build-in
Administrators group from SQL Server without adding a Login for the
local system account. Now the server tries to start, but because the
login doen't exist anymore you get these errors. Change the service
logon account to a domain account which has administrative access to
SQL Server and you should be able to start the server again.
Markussql

Errors with SRS in Sharepoint Integration Mode

Hi Everyone,

Our project has two servers. One server is running WSS 3.0 and the SQL Reporting Services web front-end. We have a second server that operates all the databases involved (WSS Content, SRS, and our application specific DB).

We do not have a domain controller in our architecture. The WSS site is configured to use SQL authentication to connnect and modify the WSS Content database. We installed SRS, SRS service pack 2, and the Sharepoint add-in. We are using forms authentication for our WSS site. We would like to use SRS in Sharepoint Integration mode, but we are unable to create datasources, view reports, etc. SRS is configured to use the "Trusted Account" in WSS Central Admin.

When we attempt to create a new datasource, and we received an error stating the object moved and to check that SRS is in Sharepoint integration mode.

When we attempt to view a report, we get an error stating:

"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode."

I have a feeling this has to do with the Windows Service Account and the Web Service Identity for SRS. What type of account should we use since we do not have a domain?

Thank you,

Michael milazzo

As explained here, in Trusted Account mode, WSS sends the requests to the Report Server under the identity of the SharePoint application. By default, the IIS 6.0 application pool runs under NT AUTHORITY\Network Service. Since you don't have a domain setup, try changing the application domain identity to a local Windows user account which has the same name and password as a privileged account on the Report Server that has access to the report catalog. If you had domain setup, the request could have gone under Domain\WSS machine name$ and you could have granted access to that account.

Errors with SQL Cluster running .DTSX packages

I'm experiencing some frustration with my active/passive SQL cluster not running my .DTSX packages. I am hoping someone can shed some light on what I need to do.

I've created some .DTSX packages with the SQL Server Business Intel Dev Studio. I initially built & tested these packages in a non-SQL cluster environment without any problems. I'm now re-creating them to work on our SQL cluster. If I run the package through the Dev Studio it works great.

The packages basically grab .txt files from one of the shared drives (which is a resource of the sql cluster group) and imports the data into the one of the databases. The database does not have any special settings (right-click -> new database... -> enter name -> click ok).

I've setup a SQL Server Agent Job with 1 step with the following properties.

Step name: I Offices
Type: SQL Server Integration Services Package
Run as: SQL Agent Service Account
Package source: File system
Package: G:\ImportRAGFLOffices.dtsx

When I run the SQL Server Agent Job through MSSQL Server Management Studio (right-click -> start job) I get an error on "Execute job 'RAGFL TestJob'".

These are the 2 messages that show up when I view the history of the SQL Server Agent job.

***********************************************************************************************
Date 9/25/2007 1:16:13 PM
Log Job History (RAGFL TestJob)

Step ID 0
Server BADBOYS
Job Name RAGFL TestJob
Step Name (Job outcome)
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
The job failed. The Job was invoked by User sa. The last step to run was step 1 (I Offices).
***********************************************************************************************

***********************************************************************************************
Date 9/25/2007 1:16:13 PM
Log Job History (RAGFL TestJob)

Step ID 1
Server BADBOYS
Job Name RAGFL TestJob
Step Name I Offices
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: THEISLAND\Administrator. The package execution failed. The step failed.
***********************************************************************************************

THEISLAND is our internal domain.

There is a decent article about clustering SSIS in Expert SQL Server 2005 Integration Services from Wrox...

The following are the high level steps:

1. Install SSIS on all nodes that can use the service

2. Create a new cluster group (optional)

3. If you created a new group, create a virtual IP, name, drive as clustered resources.

4. Copy the MsDtsSrvr.ini.xml to the clustered drive

5. Modify the MsDtsSrvr.ini.xml file to change the location of hte packages

6. Change the Registry setting to point to the MsDtsSrvr.ini.xml file

7. Cluster the MsDtsServer service as a generic service

Also, see the following for more information on Clustering SSIS:

http://wiki.sqlis.com/default.aspx/SQLISWiki/ClusterSSIS.html

http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx

|||

What a great name for a server!

Errors with SP4 upgrade... Please Help

I am having problems accessing DTS after install SP4 and was wondering
if someone could offer some advice.

I installed SP4 and got the following error after it competed.

Unable to write to response file 'U:\WINDOWS\setup.iss' during
recording. Please ensure enough space is available on target drive.

I got the error 3 times (3 pop-ups).

After the install I could not access DTS. I was getting 2 error
pop-ups.
1. 'rebbrui.rll is missing'
2. Snap-In failed to initialize: Meta Data Services

I read the groups and tried several things.

I tried to reinstall MDAC and it did not help.

I tried to register several dlls and it did not help.

I found this post and it seemed to help.
Repair Script:
http://www.experts-exchange.com/Dat...Q_21445589.html

I was then able to access DTS using the profile (which is an
administrator) which
I used to install SP4 and run the above repair script. However, no
other profile can open or run DTS.

I tried running the repair script under the other profiles and it did
not help.

I was receiving 2 errors for the other profiles. I only documented one
and I am no longer getting the other. Now it just goes to a white
screen and hangs.

1st error:
DTS Designer Error
The specified module could not be found.

2nd error:
???

I tried reinstalling client tools and SP4 and it did not help. Now I
get one additional error.

Before I can expand the server node in enterprise manager I get the
following error.
Snap-in failed to initialize
Name: Meta Data Services
CLSID: {1DBA4DD4-EB97-4FD2-AB80-9D0D4BA74034}

Does anyone have a suggestion on how I might fix this?

I am running SQL Server 2000 Enterprise on Windows 2000 Server with 4
GB RAM.

I did notices that someone has set the /3GB switch. I know this is not
supported on this OS but it was not causing major problems before the
upgrade. Could it be the culprit?Finally got this fixed. It was a real pain!

The registry on this server looked all hacked up to me. It looks like
many of the keys referenced U:/ instead of C:/

Some of the necessary dlls were pointing to U: also.

I had to manually uninstall SQL Server. Then reinstall. Then uninstall
via add remove programs. Then I did another uninstall/reinstall
(because i got a few errors).

I reinstalled, upgraded to sp4, stopped the service, swapped my master,
msdb, tempdb with the originals and everything is working great.

Errors with Service Pack 1

Hi Ng,
i have some problems with Rs Sp 1. I installed Sp 1 on the server and on the
pc where vs.net is installed. Now I got the following Problem:
I design a report and go to the preview mode. If an error is found, for
example a syntax problem in an expression, the report isn't displayed. No
problem till here. But now I change the expression, so that it's correct,
the report can't be displayed anyway. And from now on, the report won't show
in preview mode ever, even when the report is complete empty!!!
I deletet the report, copied the rdl code in a new one, and it could be
displayed. Renaming this report to the other name, can't be displayed...
Any Ideas?
Thanks in Advance
G. SchmelzerCould you please send me the exact steps to reproduce? I tried the following
but couldn't reproduce the issue:
1. Go to Layout view in Report Designer
2. Drop a textbox
3. Type the expression =Globals!ReportName in it
4. Preview (works fine)
5. Go back to layout.
6. Change the expression to =zzz_Globals!ReportName
7. Preview (returns an error)
8. Go back to layout.
9. Change the expression back to =Globals!ReportName
10. Preview (works fine)
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"G. Schmelzer" <asdf@.de.de> wrote in message
news:OwPYh2nXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hi Ng,
> i have some problems with Rs Sp 1. I installed Sp 1 on the server and on
the
> pc where vs.net is installed. Now I got the following Problem:
> I design a report and go to the preview mode. If an error is found, for
> example a syntax problem in an expression, the report isn't displayed. No
> problem till here. But now I change the expression, so that it's correct,
> the report can't be displayed anyway. And from now on, the report won't
show
> in preview mode ever, even when the report is complete empty!!!
> I deletet the report, copied the rdl code in a new one, and it could be
> displayed. Renaming this report to the other name, can't be displayed...
>
> Any Ideas?
> Thanks in Advance
> G. Schmelzer
>

Errors with linked server

We have a scheduled job that is running on a server, which gets the data fro
m
other linked server using SP.
OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
[SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005:
Please help
Thanks,
RKHi
0x80004005 means "access denied" in the COM environment.
Check that you have permissions, especially under which account you connect
to the linked server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ram Kumar Koditala" <RamKumarKoditala@.discussions.microsoft.com> wrote in
message news:D460E1EF-7DAA-48E1-A897-6B3A24C024B1@.microsoft.com...
> We have a scheduled job that is running on a server, which gets the data
from
> other linked server using SP.
> OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error
7399)
> [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
> 'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005:
> Please help
>
> Thanks,
> RKsql

Errors with combined use of transactional and merge replication - SQL2005

I am investigating the feasibility of a configuration with 3 databases on SQL2005

DB_A is an OLTP database and serves up transactional publication pub_txn - with updateable subscriptions

DB_B is a subscriber database which subscribes to pub_txn

DB_B is also a publisher which serves up merge publication pub_merge

DB_C is a subscriber database which pulls pub_merge

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

Updates on DB_A are successfully replicated to DB_B

Howvever, when DB_C pulls updates, it doesn't find the update sent to DB_B

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

Updates on DB_B are successfully replicated to both DB_A and DB_C

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

Updates on DB_C initially failed with the error

Msg 916, Level 14, State 1, Procedure trg_MSsync_upd_course_type, Line 0
The server principal "repllinkproxy" is not able to access the database
"DB_C" under the current security context.

I then changed the login repllinkproxy to be a db_owner in DB_C

I now get the error

Msg 208, Level 16, State 1, Procedure sp_check_sync_trigger, Line 23
Invalid object name 'dbo.MSreplication_objects'.

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

I have three questions as a result
1) Is there anything fundamentally wrong with what I am trying to achieve?

2) Why is update on DB_A not reaching DB_C

3) Why can't I update DB_C?

Any suggestions gratefully received

aero1

Just to clarify - I am replicating the same table between all the databases - without any filtering|||quick question - in which order did you create the publications/subscriptions? For the tran pub, are you using immediate updating subscriber, or queue updating subscriber?|||

Setup order was:

1) Transactional publication

2) Transactional subscription (immediate updating)

3) Merge publication

4) Merge subscription

|||

Some progress:

I have got rid of the errors on updating DB_C

- My initial setup was unrepresentative with all the databases, DB_A, DB_B and DB_C on the same server

- I dropped and recreated the whole setup with DB_C on a separate machine - which is more representative of what I am ultimately trying to achieve

- There were then no errors when attempting to update DB_C

However, updates on DB_A don't reach DB_C and updates on DB_C don't reach DB_A.

Updates on DB_B reach DB_A and DB_C OK

|||

Hi aero1, republishing is not supported when using updatable subscriptions, this is documented in SQL 2005 Books Online topic "Updatable Subscriptions for Transactional Replication". Your best bet is to implement Peer-to-Peer instead of updatable subscriptions.

|||

Hi Greg

Thanks - I am investigating peer to peer

aero1

|||

Hello *,

I have a problem very similar to this post, so I don’t open a new thread. The only different think is I use transactional publication WITHOUT updateable subscriptions.

I can cascade n SQL Servers 2005 and every update, insert and delete command change every beneath Database (already described by aero1). Because the end-users work with mobile clients the last Replication must be from type Merge. When I change some data on the top level server these changes comes only to the last transactional subscriber:

Example:

ServerA.DBA ===TR==>ServerB.DBB==TR==>ServerC.DBC==MR==>MobileDB

When I change a datarow on DBB the changes are available on DBC but not on MobileDB (after pull the data from there).

I hope someone can help me

Regards

Markus

|||

You need to set this article property to true: published_in_tran_pub

See the articles below and that should solve your problem of merge subscribers not receiving the data changes. However note that if you make updates at the merge subscribers, they will not flow all the way to the Tran root publisher and can cause non-convergence.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl_11et.asp

http://msdn2.microsoft.com/en-us/library/ms152559.aspx

|||

The issues that I had only involved 2 databases communicating with transactional replication - with merge subscribers hanging off one of these

For this scenario, bidirectional transactional replication seems to work well - but customisation of the replication stored procs is needed to handle conflicts.

Markus appears to have 3 databases communicating with transactional replication. I am not sure whether a chain of 3 bidirectionally replicating databases would work, but I can't think of any reason why it shouldn't. If it did then the merge changes would flow back to the root tran publisher.

Note that peer to peer wouldn't work in my scenario because the updates could not be partitioned suitably

Errors with combined use of transactional and merge replication - SQL2005

I am investigating the feasibility of a configuration with 3 databases on SQL2005

DB_A is an OLTP database and serves up transactional publication pub_txn - with updateable subscriptions

DB_B is a subscriber database which subscribes to pub_txn

DB_B is also a publisher which serves up merge publication pub_merge

DB_C is a subscriber database which pulls pub_merge

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

Updates on DB_A are successfully replicated to DB_B

Howvever, when DB_C pulls updates, it doesn't find the update sent to DB_B

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

Updates on DB_B are successfully replicated to both DB_A and DB_C

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

Updates on DB_C initially failed with the error

Msg 916, Level 14, State 1, Procedure trg_MSsync_upd_course_type, Line 0
The server principal "repllinkproxy" is not able to access the database
"DB_C" under the current security context.

I then changed the login repllinkproxy to be a db_owner in DB_C

I now get the error

Msg 208, Level 16, State 1, Procedure sp_check_sync_trigger, Line 23
Invalid object name 'dbo.MSreplication_objects'.

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

I have three questions as a result
1) Is there anything fundamentally wrong with what I am trying to achieve?

2) Why is update on DB_A not reaching DB_C

3) Why can't I update DB_C?

Any suggestions gratefully received

aero1

Just to clarify - I am replicating the same table between all the databases - without any filtering|||quick question - in which order did you create the publications/subscriptions? For the tran pub, are you using immediate updating subscriber, or queue updating subscriber?|||

Setup order was:

1) Transactional publication

2) Transactional subscription (immediate updating)

3) Merge publication

4) Merge subscription

|||

Some progress:

I have got rid of the errors on updating DB_C

- My initial setup was unrepresentative with all the databases, DB_A, DB_B and DB_C on the same server

- I dropped and recreated the whole setup with DB_C on a separate machine - which is more representative of what I am ultimately trying to achieve

- There were then no errors when attempting to update DB_C

However, updates on DB_A don't reach DB_C and updates on DB_C don't reach DB_A.

Updates on DB_B reach DB_A and DB_C OK

|||

Hi aero1, republishing is not supported when using updatable subscriptions, this is documented in SQL 2005 Books Online topic "Updatable Subscriptions for Transactional Replication". Your best bet is to implement Peer-to-Peer instead of updatable subscriptions.

|||

Hi Greg

Thanks - I am investigating peer to peer

aero1

|||

Hello *,

I have a problem very similar to this post, so I don’t open a new thread. The only different think is I use transactional publication WITHOUT updateable subscriptions.

I can cascade n SQL Servers 2005 and every update, insert and delete command change every beneath Database (already described by aero1). Because the end-users work with mobile clients the last Replication must be from type Merge. When I change some data on the top level server these changes comes only to the last transactional subscriber:

Example:

ServerA.DBA ===TR==>ServerB.DBB==TR==>ServerC.DBC==MR==>MobileDB

When I change a datarow on DBB the changes are available on DBC but not on MobileDB (after pull the data from there).

I hope someone can help me

Regards

Markus

|||

You need to set this article property to true: published_in_tran_pub

See the articles below and that should solve your problem of merge subscribers not receiving the data changes. However note that if you make updates at the merge subscribers, they will not flow all the way to the Tran root publisher and can cause non-convergence.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl_11et.asp

http://msdn2.microsoft.com/en-us/library/ms152559.aspx

|||

The issues that I had only involved 2 databases communicating with transactional replication - with merge subscribers hanging off one of these

For this scenario, bidirectional transactional replication seems to work well - but customisation of the replication stored procs is needed to handle conflicts.

Markus appears to have 3 databases communicating with transactional replication. I am not sure whether a chain of 3 bidirectionally replicating databases would work, but I can't think of any reason why it shouldn't. If it did then the merge changes would flow back to the root tran publisher.

Note that peer to peer wouldn't work in my scenario because the updates could not be partitioned suitably

Errors while upsizing Access database to SQLS2k

I am trying to upsize an Access database to SQL Server 2000. I select
"Create new database" option.
I select "LOCAL" as the database. and check [x] use trusted connection.
SQL server is on this local machine. I supply a name for the new
database and click [Next>] and I get the following error.
================================================== ===============
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist
or access denied.
================================================== ===============
Why am I getting these errors?
SQL Server is installed to accept mixed mode (or Windows authentication
mode)
SQL Server is running.
VS.Net Professional is loaded on this system so an ODBC driver should
be available.
What steps, other than I am taking should I be doing?
Are you doing this on the machine that MSDE is running on? If you are trying
to do this remotely then you will not be able to connect to the database
server, since you supplied DISABLENETWORKPROTOCOLS=1 as a parameter to your
installation. Also since you installed a named instance you will need to
supply the full name to the instance, which in your case will be <your
machine name>\HipMSDE. (local) will not work as the database server name, as
it will try to connect to a server with only the same name as the machine
and not the named instance.
Jim
"dbuchanan" <dbuchanan52@.hotmail.com> wrote in message
news:1107749903.811964.185300@.g14g2000cwa.googlegr oups.com...
>I am trying to upsize an Access database to SQL Server 2000. I select
> "Create new database" option.
> I select "LOCAL" as the database. and check [x] use trusted connection.
> SQL server is on this local machine. I supply a name for the new
> database and click [Next>] and I get the following error.
> ================================================== ===============
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> (Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist
> or access denied.
> ================================================== ===============
> Why am I getting these errors?
> SQL Server is installed to accept mixed mode (or Windows authentication
> mode)
> SQL Server is running.
> VS.Net Professional is loaded on this system so an ODBC driver should
> be available.
> What steps, other than I am taking should I be doing?
>
|||Jim,
Thank you for your reply.
When I changed the name to the name of my computer "SEDNA", it worked!
I thought "(local)" was the proper name to use because the upsizing
wizard offered it in the list. I thought it "discovered" that name, and
after all the name in Enterprize manager is "(local)" not "SEDNA". Now
that you let me in on this sectret, I know. Thank you for tell me the
other scret, that I can upsize to MSDE using "SEDNA\HipMSDE". There is
know whay I could have guessed this!
This all frustrates me very much! How am I supposed to know to use
"SEDNA" rather than "(local)" when "(local)" is offered to me in the
list? and Enterprize manager does not use "SEDNA"? How am I supposed to
know the sintax "SEDNA\HipMSDE" when that is NOT offered in the list?
How am I supposed to know the secret code "SEDNA\HipMSDE"? Nothing
anywhere tells me this sintax!!?!

> it will try to connect to a server with only the same name as the
machine
> and not the named instance
Where the #%$* am I supposed to discover this! I've been reading these
instructions for two days!!!?! I have not seen anything even hinting to
this.
Why does the system mislead me and accept "(local)" under othere
contexts such as VB.NET connection strings. It was the VB.NET
connection string context that lead me to guess "SEDNA" because that
works in a connection string even though the name of the instance is
NOT!!!! "SEDNA", its the name of the machine.
Where do I learn all these mysteries?
Doug
Jim Young wrote:
> Are you doing this on the machine that MSDE is running on? If you are
trying
> to do this remotely then you will not be able to connect to the
database
> server, since you supplied DISABLENETWORKPROTOCOLS=1 as a parameter
to your
> installation. Also since you installed a named instance you will need
to
> supply the full name to the instance, which in your case will be
<your
> machine name>\HipMSDE. (local) will not work as the database server
name, as
> it will try to connect to a server with only the same name as the
machine[vbcol=seagreen]
> and not the named instance.
> Jim
> "dbuchanan" <dbuchanan52@.hotmail.com> wrote in message
> news:1107749903.811964.185300@.g14g2000cwa.googlegr oups.com...
select[vbcol=seagreen]
connection.[vbcol=seagreen]
exist[vbcol=seagreen]
authentication[vbcol=seagreen]
should[vbcol=seagreen]
|||hi,
dbuchanan wrote:
> This all frustrates me very much! How am I supposed to know to use
> "SEDNA" rather than "(local)" when "(local)" is offered to me in the
> list? and Enterprize manager does not use "SEDNA"? How am I supposed
> to know the sintax "SEDNA\HipMSDE" when that is NOT offered in the
> list? How am I supposed to know the secret code "SEDNA\HipMSDE"?
> Nothing anywhere tells me this sintax!!?!
>.....
http://msdn.microsoft.com/library/de...setup_2xmb.asp
you can download BOL (BookOnLine) from
http://www.microsoft.com/sql/techinf...2000/books.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

errors while running ssis packages from the command prompt.

I have created ssis package. It has been successfully running at UI level.

But when i am trying to execute it from the command prompt by using dtexec utility it is showing the following error messages.

Error: 2005-12-23 17:01:57.67
Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: The product level is insufficient for component "Flat File Source" (1).
End Error
Error: 2005-12-23 17:01:57.67
Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: The product level is insufficient for component "Script Component" (9).
End Error

i have entered the command as follows.

dtexec /f "c:\somefolder\package1.dtsx"

Any points regarding this issue would be helpful.

Take a look here:

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

Same problem is being discussed.

HTH,
Ovidiu

|||

I am receiving a similar error. We are running SS2005 Enterprise Edition. We can connect to SSIS with SS Management Studio so that verifies that it's installed. Here is our error log. Did you solve your probelm, and if so, how?

*************************************Run GPS_EXTRACT_QA.dtsx*********************************************
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 5:14:34 PM
Progress: 2006-01-26 17:14:36.01
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2006-01-26 17:14:36.03
Source: Data Flow Task
Validating: 50% complete
End Progress
Progress: 2006-01-26 17:14:36.21
Source: Data Flow Task
Validating: 100% complete
End Progress
Progress: 2006-01-26 17:14:36.53
Source: Execute SQL Task
Executing query "truncate table sap_extract_staging
delete from sap".: 100% complete
End Progress
Progress: 2006-01-26 17:14:36.54
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2006-01-26 17:14:36.56
Source: Data Flow Task
Validating: 50% complete
End Progress
Progress: 2006-01-26 17:14:36.60
Source: Data Flow Task
Validating: 100% complete
End Progress
Error: 2006-01-26 17:14:36.60
Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: The product level is insufficient for component "Flat File Source" (749).
End Error
Warning: 2006-01-26 17:14:36.60
Code: 0x80019002
Source: GPS_EXTRACT_QA
Description: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 5:14:34 PM
Finished: 5:14:36 PM
Elapsed: 2.562 seconds

|||

I am also getting same error.

any sugessions regarding this issue

sql

errors while running ssis packages from the command prompt.

I have created ssis package. It has been successfully running at UI level.

But when i am trying to execute it from the command prompt by using dtexec utility it is showing the following error messages.

Error: 2005-12-23 17:01:57.67
Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: The product level is insufficient for component "Flat File Source" (1).
End Error
Error: 2005-12-23 17:01:57.67
Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: The product level is insufficient for component "Script Component" (9).
End Error

i have entered the command as follows.

dtexec /f "c:\somefolder\package1.dtsx"

Any points regarding this issue would be helpful.

Take a look here:

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

Same problem is being discussed.

HTH,
Ovidiu

|||

I am receiving a similar error. We are running SS2005 Enterprise Edition. We can connect to SSIS with SS Management Studio so that verifies that it's installed. Here is our error log. Did you solve your probelm, and if so, how?

*************************************Run GPS_EXTRACT_QA.dtsx*********************************************
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 5:14:34 PM
Progress: 2006-01-26 17:14:36.01
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2006-01-26 17:14:36.03
Source: Data Flow Task
Validating: 50% complete
End Progress
Progress: 2006-01-26 17:14:36.21
Source: Data Flow Task
Validating: 100% complete
End Progress
Progress: 2006-01-26 17:14:36.53
Source: Execute SQL Task
Executing query "truncate table sap_extract_staging
delete from sap".: 100% complete
End Progress
Progress: 2006-01-26 17:14:36.54
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2006-01-26 17:14:36.56
Source: Data Flow Task
Validating: 50% complete
End Progress
Progress: 2006-01-26 17:14:36.60
Source: Data Flow Task
Validating: 100% complete
End Progress
Error: 2006-01-26 17:14:36.60
Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: The product level is insufficient for component "Flat File Source" (749).
End Error
Warning: 2006-01-26 17:14:36.60
Code: 0x80019002
Source: GPS_EXTRACT_QA
Description: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 5:14:34 PM
Finished: 5:14:36 PM
Elapsed: 2.562 seconds

|||

I am also getting same error.

any sugessions regarding this issue

errors while running ssis packages from the command prompt.

I have created ssis package. It has been successfully running at UI level.

But when i am trying to execute it from the command prompt by using dtexec utility it is showing the following error messages.

Error: 2005-12-23 17:01:57.67
Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: The product level is insufficient for component "Flat File Source" (1).
End Error
Error: 2005-12-23 17:01:57.67
Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: The product level is insufficient for component "Script Component" (9).
End Error

i have entered the command as follows.

dtexec /f "c:\somefolder\package1.dtsx"

Any points regarding this issue would be helpful.

Take a look here:

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

Same problem is being discussed.

HTH,
Ovidiu

|||

I am receiving a similar error. We are running SS2005 Enterprise Edition. We can connect to SSIS with SS Management Studio so that verifies that it's installed. Here is our error log. Did you solve your probelm, and if so, how?

*************************************Run GPS_EXTRACT_QA.dtsx*********************************************
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 5:14:34 PM
Progress: 2006-01-26 17:14:36.01
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2006-01-26 17:14:36.03
Source: Data Flow Task
Validating: 50% complete
End Progress
Progress: 2006-01-26 17:14:36.21
Source: Data Flow Task
Validating: 100% complete
End Progress
Progress: 2006-01-26 17:14:36.53
Source: Execute SQL Task
Executing query "truncate table sap_extract_staging
delete from sap".: 100% complete
End Progress
Progress: 2006-01-26 17:14:36.54
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2006-01-26 17:14:36.56
Source: Data Flow Task
Validating: 50% complete
End Progress
Progress: 2006-01-26 17:14:36.60
Source: Data Flow Task
Validating: 100% complete
End Progress
Error: 2006-01-26 17:14:36.60
Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: The product level is insufficient for component "Flat File Source" (749).
End Error
Warning: 2006-01-26 17:14:36.60
Code: 0x80019002
Source: GPS_EXTRACT_QA
Description: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 5:14:34 PM
Finished: 5:14:36 PM
Elapsed: 2.562 seconds

|||

I am also getting same error.

any sugessions regarding this issue

Errors while running SQLH2 Tool

I am recieving following errors while running SQLH2
can you advice how can i resolve them
Errors:
1.InvalidOperationException Cannot read log entry number 4243737.
2.NullReferenceException Object reference not set to an instance of an
object.
3.Event Log There is no gap in history, but the
previous last event
is out of bounds
What version of SQLH2 are you running? I hope it's updated version
(2.0.024).
1. Quote from SQLH2 V2 Deployment Guide
Cannot read log entry number ###.
This error usually indicates that the event log on the target machine is
corrupted. It's easy to verify using Event Viewer - try to open the
suspected event log and check if you can read events from it (sometimes
Event Viewer is able to show the list of events, but an actual attempt to
read some events fails).
I would need more inofmation regarding the other two.
Please send a mail to SQLH2@.microsoft.com
(with your H2log.txt attached).
Thanks
Grigory
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Aneel Ismaily" <Aneel Ismaily@.discussions.microsoft.com> wrote in message
news:A219CD0B-C253-43E2-90E2-487CE248BAF3@.microsoft.com...
> I am recieving following errors while running SQLH2
> can you advice how can i resolve them
> Errors:
> 1.InvalidOperationException Cannot read log entry number 4243737.
> 2.NullReferenceException Object reference not set to an instance of
an
> object.
> 3.Event Log There is no gap in history, but the
> previous last event
> is out of bounds
>