dbTalk Databases Forums  

RE: mssql 2005 express - dtswizard fails

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts RE: mssql 2005 express - dtswizard fails

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss RE: mssql 2005 express - dtswizard fails in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Subhen Kar [MSFT]
 
Posts: n/a

Default RE: mssql 2005 express - dtswizard fails - 05-06-2008 , 03:56 PM





Hi Hugo,

I think the following action plan may help you out on this problem.Please
understand that this is what I think might help the situation and this may
very well not resolve the problem.

1. Login with an user that has local administrator rights in the computer
(SQL
Server)
2. Check that SQL Server is not registered using the IP address in SQL
Server
Management Studio
3. Verify if the results of this command:
Select @@server_name
Return a SQL Server name that is the same as the HOST computer name
4. Create a new simple SSIS package with single SQL Task. This task query's
from
one of the user tables.
5. Execute the SSIS in SQL Server BI Studio to verify that is works
6. Login in SQL Server Management Studio as SA
7. Deploy the SSIS package to SQL server
8. Create a NEW job (owner = SA)
9. Create a NEW Schedule (owner = SA)

Try to run the JOB

If it fails again then :

==>Test to create/schedule the job from a workstation that has SQL 2005
tools
installed and let me know the outcome. Does it work?
==> Is this specific to only SSIS jobs? Is the problem only for this SSIS
job or any
new SSIS jobs?
==> Does it matter who you're logged in as - for exampe can admins view
properties
fine but non-admins cannot?
==> From the error we have, it does not look like the error is when
specifying the
job schedule. It looks like the error is seen when trying to edit the job
step
properties for an SSIS job. Please confirm.
==>Is this a 32 bit or 64 bit machine?
==> Does it matter where SSIS pkg is stored, if on file system or in msdb?

==> Collect a Backup of regkey: HKCR\CLSID

==> Check if these DLL's are present and/or registered:
- C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvrUtil.dll
- C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTSLog.dll
- C:\Program Files (x86)\Microsoft SQL
Server\90\DTS\Binn\Resources\1033\DTSLOG.rll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.M anagedDTS\9.0.242.0__89845
dcd8080c
c91\Microsoft.SqlServer.ManagedDTS.dll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.D TSRuntimeWrap\9.0.242.0__8
9845dcd8
080cc91\Microsoft.SqlServer.DTSRuntimeWrap.dll

Thanks in advance,
Subhen
--------------------
Quote:
|>|From: Hugo Ahlenius <mssql_usenet (AT) oxel (DOT) net
|>|Newsgroups: microsoft.public.sqlserver.dts
|>|Subject: mssql 2005 express - dtswizard fails
|>|Date: Mon, 23 Jul 2007 08:27:50 -0700
|>|Organization: http://groups.google.com
|>|Lines: 42
|>|Message-ID: <1185204470.224125.205580 (AT) i13g2000prf (DOT) googlegroups.com
|>|NNTP-Posting-Host: 193.10.147.87
|>|Mime-Version: 1.0
|>|Content-Type: text/plain; charset="iso-8859-1"
|>|X-Trace: posting.google.com 1185204471 16256 127.0.0.1 (23 Jul 2007
15:27:51 GMT)
|>|X-Complaints-To: groups-abuse (AT) google (DOT) com
|>|NNTP-Posting-Date: Mon, 23 Jul 2007 15:27:51 +0000 (UTC)
|>|User-Agent: G2/1.0
|>|X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0;
Maxthon; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR
3.0.04506; Tablet PC 2.0),gzip(gfe),gzip(gfe)
Quote:
|>|Complaints-To: groups-abuse (AT) google (DOT) com
|>|Injection-Info: i13g2000prf.googlegroups.com;
posting-host=193.10.147.87;
|>| posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
|>|Bytes: 2694
|>|Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TFEEDS02.phx.gbl!news-out.
cwix.com!newsfeed.cwix.com!newscon02.news.prodigy. net!prodigy.net!border1.nn
tp.dca.giganews.com!nntp.giganews.com!postnews.goo gle.com!i13g2000prf.google
groups.com!not-for-mail
Quote:
|>|Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:3107
|>|X-Tomcat-NG: microsoft.public.sqlserver.dts
|>|
|>|Hi,
|>|
|>|I have just installed SQL Server 2005 sp2 w/ analysis services on my
|>|new Vista Ultimate machine. I am not able to run the DTS Wizard though
|>|- it fails with the error below. Any tips on how to fix this? I have
|>|tried reinstalling the Backward Compability components, as well as the
|>|DTS components.
|>|
|>|-------------------------------------
|>|===================================
|>|
|>|This wizard will close because it encountered the following error:
|>|(Microsoft SQL Server)
|>|
|>|------------------------------
|>|For help, click:

|>|http://go.microsoft.com/fwlink?ProdN...er&ProdVer=9.0
0.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI .WizardFrameworkErrorSR&Ev
tID=UncaughtException&LinkId=20476
Quote:
|>|
|>|===================================
|>|
|>|The specified module could not be found. (Exception from HRESULT:
|>|0x8007007E) (Microsoft.SqlServer.DTSRuntimeWrap)
|>|
|>|------------------------------
|>|Program Location:
|>|
|>| at

|>|Microsoft.SqlServer.Dts.Runtime.Wrapper.Applica tionClass.get_DBProviderI
nfos()
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.Get DtsDbProviderInfos(Wizard
Inputs
|>|wizardInputs)
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DataSourceCom bo.PopulateProviders(Bool
ean
|>|fSources, WizardInputs wizardInputs)
|>| at
|>|Microsoft.SqlServer.Dts.DtsWizard.Step1.OnIniti alizePage(EventArgs e)
|>| at Microsoft.SqlServer.Management.UI.WizardPage.Raise EnterPage()
|>| at Microsoft.SqlServer.Management.UI.WizardForm.NextP age(WizardPage
|>|nextPage)
|>| at Microsoft.SqlServer.Management.UI.WizardForm.Next_ Click(Object
|>|sender, EventArgs e)
|>|
|>|
Subhen Kar,MCTS
SQL Server Core Group
MICROSOFT



Reply With Quote
  #2  
Old   
Subhen Kar [MSFT]
 
Posts: n/a

Default RE: mssql 2005 express - dtswizard fails - 05-06-2008 , 03:56 PM





Hi Hugo,

I think the following action plan may help you out on this problem.Please
understand that this is what I think might help the situation and this may
very well not resolve the problem.

1. Login with an user that has local administrator rights in the computer
(SQL
Server)
2. Check that SQL Server is not registered using the IP address in SQL
Server
Management Studio
3. Verify if the results of this command:
Select @@server_name
Return a SQL Server name that is the same as the HOST computer name
4. Create a new simple SSIS package with single SQL Task. This task query's
from
one of the user tables.
5. Execute the SSIS in SQL Server BI Studio to verify that is works
6. Login in SQL Server Management Studio as SA
7. Deploy the SSIS package to SQL server
8. Create a NEW job (owner = SA)
9. Create a NEW Schedule (owner = SA)

Try to run the JOB

If it fails again then :

==>Test to create/schedule the job from a workstation that has SQL 2005
tools
installed and let me know the outcome. Does it work?
==> Is this specific to only SSIS jobs? Is the problem only for this SSIS
job or any
new SSIS jobs?
==> Does it matter who you're logged in as - for exampe can admins view
properties
fine but non-admins cannot?
==> From the error we have, it does not look like the error is when
specifying the
job schedule. It looks like the error is seen when trying to edit the job
step
properties for an SSIS job. Please confirm.
==>Is this a 32 bit or 64 bit machine?
==> Does it matter where SSIS pkg is stored, if on file system or in msdb?

==> Collect a Backup of regkey: HKCR\CLSID

==> Check if these DLL's are present and/or registered:
- C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvrUtil.dll
- C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTSLog.dll
- C:\Program Files (x86)\Microsoft SQL
Server\90\DTS\Binn\Resources\1033\DTSLOG.rll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.M anagedDTS\9.0.242.0__89845
dcd8080c
c91\Microsoft.SqlServer.ManagedDTS.dll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.D TSRuntimeWrap\9.0.242.0__8
9845dcd8
080cc91\Microsoft.SqlServer.DTSRuntimeWrap.dll

Thanks in advance,
Subhen
--------------------
Quote:
|>|From: Hugo Ahlenius <mssql_usenet (AT) oxel (DOT) net
|>|Newsgroups: microsoft.public.sqlserver.dts
|>|Subject: mssql 2005 express - dtswizard fails
|>|Date: Mon, 23 Jul 2007 08:27:50 -0700
|>|Organization: http://groups.google.com
|>|Lines: 42
|>|Message-ID: <1185204470.224125.205580 (AT) i13g2000prf (DOT) googlegroups.com
|>|NNTP-Posting-Host: 193.10.147.87
|>|Mime-Version: 1.0
|>|Content-Type: text/plain; charset="iso-8859-1"
|>|X-Trace: posting.google.com 1185204471 16256 127.0.0.1 (23 Jul 2007
15:27:51 GMT)
|>|X-Complaints-To: groups-abuse (AT) google (DOT) com
|>|NNTP-Posting-Date: Mon, 23 Jul 2007 15:27:51 +0000 (UTC)
|>|User-Agent: G2/1.0
|>|X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0;
Maxthon; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR
3.0.04506; Tablet PC 2.0),gzip(gfe),gzip(gfe)
Quote:
|>|Complaints-To: groups-abuse (AT) google (DOT) com
|>|Injection-Info: i13g2000prf.googlegroups.com;
posting-host=193.10.147.87;
|>| posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
|>|Bytes: 2694
|>|Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TFEEDS02.phx.gbl!news-out.
cwix.com!newsfeed.cwix.com!newscon02.news.prodigy. net!prodigy.net!border1.nn
tp.dca.giganews.com!nntp.giganews.com!postnews.goo gle.com!i13g2000prf.google
groups.com!not-for-mail
Quote:
|>|Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:3107
|>|X-Tomcat-NG: microsoft.public.sqlserver.dts
|>|
|>|Hi,
|>|
|>|I have just installed SQL Server 2005 sp2 w/ analysis services on my
|>|new Vista Ultimate machine. I am not able to run the DTS Wizard though
|>|- it fails with the error below. Any tips on how to fix this? I have
|>|tried reinstalling the Backward Compability components, as well as the
|>|DTS components.
|>|
|>|-------------------------------------
|>|===================================
|>|
|>|This wizard will close because it encountered the following error:
|>|(Microsoft SQL Server)
|>|
|>|------------------------------
|>|For help, click:

|>|http://go.microsoft.com/fwlink?ProdN...er&ProdVer=9.0
0.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI .WizardFrameworkErrorSR&Ev
tID=UncaughtException&LinkId=20476
Quote:
|>|
|>|===================================
|>|
|>|The specified module could not be found. (Exception from HRESULT:
|>|0x8007007E) (Microsoft.SqlServer.DTSRuntimeWrap)
|>|
|>|------------------------------
|>|Program Location:
|>|
|>| at

|>|Microsoft.SqlServer.Dts.Runtime.Wrapper.Applica tionClass.get_DBProviderI
nfos()
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.Get DtsDbProviderInfos(Wizard
Inputs
|>|wizardInputs)
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DataSourceCom bo.PopulateProviders(Bool
ean
|>|fSources, WizardInputs wizardInputs)
|>| at
|>|Microsoft.SqlServer.Dts.DtsWizard.Step1.OnIniti alizePage(EventArgs e)
|>| at Microsoft.SqlServer.Management.UI.WizardPage.Raise EnterPage()
|>| at Microsoft.SqlServer.Management.UI.WizardForm.NextP age(WizardPage
|>|nextPage)
|>| at Microsoft.SqlServer.Management.UI.WizardForm.Next_ Click(Object
|>|sender, EventArgs e)
|>|
|>|
Subhen Kar,MCTS
SQL Server Core Group
MICROSOFT



Reply With Quote
  #3  
Old   
Subhen Kar [MSFT]
 
Posts: n/a

Default RE: mssql 2005 express - dtswizard fails - 05-06-2008 , 03:56 PM


Hi Hugo,

I think the following action plan may help you out on this problem.Please
understand that this is what I think might help the situation and this may
very well not resolve the problem.

1. Login with an user that has local administrator rights in the computer
(SQL
Server)
2. Check that SQL Server is not registered using the IP address in SQL
Server
Management Studio
3. Verify if the results of this command:
Select @@server_name
Return a SQL Server name that is the same as the HOST computer name
4. Create a new simple SSIS package with single SQL Task. This task query's
from
one of the user tables.
5. Execute the SSIS in SQL Server BI Studio to verify that is works
6. Login in SQL Server Management Studio as SA
7. Deploy the SSIS package to SQL server
8. Create a NEW job (owner = SA)
9. Create a NEW Schedule (owner = SA)

Try to run the JOB

If it fails again then :

==>Test to create/schedule the job from a workstation that has SQL 2005
tools
installed and let me know the outcome. Does it work?
==> Is this specific to only SSIS jobs? Is the problem only for this SSIS
job or any
new SSIS jobs?
==> Does it matter who you're logged in as - for exampe can admins view
properties
fine but non-admins cannot?
==> From the error we have, it does not look like the error is when
specifying the
job schedule. It looks like the error is seen when trying to edit the job
step
properties for an SSIS job. Please confirm.
==>Is this a 32 bit or 64 bit machine?
==> Does it matter where SSIS pkg is stored, if on file system or in msdb?

==> Collect a Backup of regkey: HKCR\CLSID

==> Check if these DLL's are present and/or registered:
- C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvrUtil.dll
- C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTSLog.dll
- C:\Program Files (x86)\Microsoft SQL
Server\90\DTS\Binn\Resources\1033\DTSLOG.rll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.M anagedDTS\9.0.242.0__89845
dcd8080c
c91\Microsoft.SqlServer.ManagedDTS.dll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.D TSRuntimeWrap\9.0.242.0__8
9845dcd8
080cc91\Microsoft.SqlServer.DTSRuntimeWrap.dll

Thanks in advance,
Subhen
--------------------
Quote:
|>|From: Hugo Ahlenius <mssql_usenet (AT) oxel (DOT) net
|>|Newsgroups: microsoft.public.sqlserver.dts
|>|Subject: mssql 2005 express - dtswizard fails
|>|Date: Mon, 23 Jul 2007 08:27:50 -0700
|>|Organization: http://groups.google.com
|>|Lines: 42
|>|Message-ID: <1185204470.224125.205580 (AT) i13g2000prf (DOT) googlegroups.com
|>|NNTP-Posting-Host: 193.10.147.87
|>|Mime-Version: 1.0
|>|Content-Type: text/plain; charset="iso-8859-1"
|>|X-Trace: posting.google.com 1185204471 16256 127.0.0.1 (23 Jul 2007
15:27:51 GMT)
|>|X-Complaints-To: groups-abuse (AT) google (DOT) com
|>|NNTP-Posting-Date: Mon, 23 Jul 2007 15:27:51 +0000 (UTC)
|>|User-Agent: G2/1.0
|>|X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0;
Maxthon; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR
3.0.04506; Tablet PC 2.0),gzip(gfe),gzip(gfe)
Quote:
|>|Complaints-To: groups-abuse (AT) google (DOT) com
|>|Injection-Info: i13g2000prf.googlegroups.com;
posting-host=193.10.147.87;
|>| posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
|>|Bytes: 2694
|>|Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TFEEDS02.phx.gbl!news-out.
cwix.com!newsfeed.cwix.com!newscon02.news.prodigy. net!prodigy.net!border1.nn
tp.dca.giganews.com!nntp.giganews.com!postnews.goo gle.com!i13g2000prf.google
groups.com!not-for-mail
Quote:
|>|Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:3107
|>|X-Tomcat-NG: microsoft.public.sqlserver.dts
|>|
|>|Hi,
|>|
|>|I have just installed SQL Server 2005 sp2 w/ analysis services on my
|>|new Vista Ultimate machine. I am not able to run the DTS Wizard though
|>|- it fails with the error below. Any tips on how to fix this? I have
|>|tried reinstalling the Backward Compability components, as well as the
|>|DTS components.
|>|
|>|-------------------------------------
|>|===================================
|>|
|>|This wizard will close because it encountered the following error:
|>|(Microsoft SQL Server)
|>|
|>|------------------------------
|>|For help, click:

|>|http://go.microsoft.com/fwlink?ProdN...er&ProdVer=9.0
0.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI .WizardFrameworkErrorSR&Ev
tID=UncaughtException&LinkId=20476
Quote:
|>|
|>|===================================
|>|
|>|The specified module could not be found. (Exception from HRESULT:
|>|0x8007007E) (Microsoft.SqlServer.DTSRuntimeWrap)
|>|
|>|------------------------------
|>|Program Location:
|>|
|>| at

|>|Microsoft.SqlServer.Dts.Runtime.Wrapper.Applica tionClass.get_DBProviderI
nfos()
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.Get DtsDbProviderInfos(Wizard
Inputs
|>|wizardInputs)
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DataSourceCom bo.PopulateProviders(Bool
ean
|>|fSources, WizardInputs wizardInputs)
|>| at
|>|Microsoft.SqlServer.Dts.DtsWizard.Step1.OnIniti alizePage(EventArgs e)
|>| at Microsoft.SqlServer.Management.UI.WizardPage.Raise EnterPage()
|>| at Microsoft.SqlServer.Management.UI.WizardForm.NextP age(WizardPage
|>|nextPage)
|>| at Microsoft.SqlServer.Management.UI.WizardForm.Next_ Click(Object
|>|sender, EventArgs e)
|>|
|>|
Subhen Kar,MCTS
SQL Server Core Group
MICROSOFT



Reply With Quote
  #4  
Old   
Subhen Kar [MSFT]
 
Posts: n/a

Default RE: mssql 2005 express - dtswizard fails - 05-06-2008 , 03:56 PM


Hi Hugo,

I think the following action plan may help you out on this problem.Please
understand that this is what I think might help the situation and this may
very well not resolve the problem.

1. Login with an user that has local administrator rights in the computer
(SQL
Server)
2. Check that SQL Server is not registered using the IP address in SQL
Server
Management Studio
3. Verify if the results of this command:
Select @@server_name
Return a SQL Server name that is the same as the HOST computer name
4. Create a new simple SSIS package with single SQL Task. This task query's
from
one of the user tables.
5. Execute the SSIS in SQL Server BI Studio to verify that is works
6. Login in SQL Server Management Studio as SA
7. Deploy the SSIS package to SQL server
8. Create a NEW job (owner = SA)
9. Create a NEW Schedule (owner = SA)

Try to run the JOB

If it fails again then :

==>Test to create/schedule the job from a workstation that has SQL 2005
tools
installed and let me know the outcome. Does it work?
==> Is this specific to only SSIS jobs? Is the problem only for this SSIS
job or any
new SSIS jobs?
==> Does it matter who you're logged in as - for exampe can admins view
properties
fine but non-admins cannot?
==> From the error we have, it does not look like the error is when
specifying the
job schedule. It looks like the error is seen when trying to edit the job
step
properties for an SSIS job. Please confirm.
==>Is this a 32 bit or 64 bit machine?
==> Does it matter where SSIS pkg is stored, if on file system or in msdb?

==> Collect a Backup of regkey: HKCR\CLSID

==> Check if these DLL's are present and/or registered:
- C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvrUtil.dll
- C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTSLog.dll
- C:\Program Files (x86)\Microsoft SQL
Server\90\DTS\Binn\Resources\1033\DTSLOG.rll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.M anagedDTS\9.0.242.0__89845
dcd8080c
c91\Microsoft.SqlServer.ManagedDTS.dll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.D TSRuntimeWrap\9.0.242.0__8
9845dcd8
080cc91\Microsoft.SqlServer.DTSRuntimeWrap.dll

Thanks in advance,
Subhen
--------------------
Quote:
|>|From: Hugo Ahlenius <mssql_usenet (AT) oxel (DOT) net
|>|Newsgroups: microsoft.public.sqlserver.dts
|>|Subject: mssql 2005 express - dtswizard fails
|>|Date: Mon, 23 Jul 2007 08:27:50 -0700
|>|Organization: http://groups.google.com
|>|Lines: 42
|>|Message-ID: <1185204470.224125.205580 (AT) i13g2000prf (DOT) googlegroups.com
|>|NNTP-Posting-Host: 193.10.147.87
|>|Mime-Version: 1.0
|>|Content-Type: text/plain; charset="iso-8859-1"
|>|X-Trace: posting.google.com 1185204471 16256 127.0.0.1 (23 Jul 2007
15:27:51 GMT)
|>|X-Complaints-To: groups-abuse (AT) google (DOT) com
|>|NNTP-Posting-Date: Mon, 23 Jul 2007 15:27:51 +0000 (UTC)
|>|User-Agent: G2/1.0
|>|X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0;
Maxthon; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR
3.0.04506; Tablet PC 2.0),gzip(gfe),gzip(gfe)
Quote:
|>|Complaints-To: groups-abuse (AT) google (DOT) com
|>|Injection-Info: i13g2000prf.googlegroups.com;
posting-host=193.10.147.87;
|>| posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
|>|Bytes: 2694
|>|Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TFEEDS02.phx.gbl!news-out.
cwix.com!newsfeed.cwix.com!newscon02.news.prodigy. net!prodigy.net!border1.nn
tp.dca.giganews.com!nntp.giganews.com!postnews.goo gle.com!i13g2000prf.google
groups.com!not-for-mail
Quote:
|>|Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:3107
|>|X-Tomcat-NG: microsoft.public.sqlserver.dts
|>|
|>|Hi,
|>|
|>|I have just installed SQL Server 2005 sp2 w/ analysis services on my
|>|new Vista Ultimate machine. I am not able to run the DTS Wizard though
|>|- it fails with the error below. Any tips on how to fix this? I have
|>|tried reinstalling the Backward Compability components, as well as the
|>|DTS components.
|>|
|>|-------------------------------------
|>|===================================
|>|
|>|This wizard will close because it encountered the following error:
|>|(Microsoft SQL Server)
|>|
|>|------------------------------
|>|For help, click:

|>|http://go.microsoft.com/fwlink?ProdN...er&ProdVer=9.0
0.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI .WizardFrameworkErrorSR&Ev
tID=UncaughtException&LinkId=20476
Quote:
|>|
|>|===================================
|>|
|>|The specified module could not be found. (Exception from HRESULT:
|>|0x8007007E) (Microsoft.SqlServer.DTSRuntimeWrap)
|>|
|>|------------------------------
|>|Program Location:
|>|
|>| at

|>|Microsoft.SqlServer.Dts.Runtime.Wrapper.Applica tionClass.get_DBProviderI
nfos()
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.Get DtsDbProviderInfos(Wizard
Inputs
|>|wizardInputs)
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DataSourceCom bo.PopulateProviders(Bool
ean
|>|fSources, WizardInputs wizardInputs)
|>| at
|>|Microsoft.SqlServer.Dts.DtsWizard.Step1.OnIniti alizePage(EventArgs e)
|>| at Microsoft.SqlServer.Management.UI.WizardPage.Raise EnterPage()
|>| at Microsoft.SqlServer.Management.UI.WizardForm.NextP age(WizardPage
|>|nextPage)
|>| at Microsoft.SqlServer.Management.UI.WizardForm.Next_ Click(Object
|>|sender, EventArgs e)
|>|
|>|
Subhen Kar,MCTS
SQL Server Core Group
MICROSOFT



Reply With Quote
  #5  
Old   
Subhen Kar [MSFT]
 
Posts: n/a

Default RE: mssql 2005 express - dtswizard fails - 05-06-2008 , 03:56 PM


Hi Hugo,

I think the following action plan may help you out on this problem.Please
understand that this is what I think might help the situation and this may
very well not resolve the problem.

1. Login with an user that has local administrator rights in the computer
(SQL
Server)
2. Check that SQL Server is not registered using the IP address in SQL
Server
Management Studio
3. Verify if the results of this command:
Select @@server_name
Return a SQL Server name that is the same as the HOST computer name
4. Create a new simple SSIS package with single SQL Task. This task query's
from
one of the user tables.
5. Execute the SSIS in SQL Server BI Studio to verify that is works
6. Login in SQL Server Management Studio as SA
7. Deploy the SSIS package to SQL server
8. Create a NEW job (owner = SA)
9. Create a NEW Schedule (owner = SA)

Try to run the JOB

If it fails again then :

==>Test to create/schedule the job from a workstation that has SQL 2005
tools
installed and let me know the outcome. Does it work?
==> Is this specific to only SSIS jobs? Is the problem only for this SSIS
job or any
new SSIS jobs?
==> Does it matter who you're logged in as - for exampe can admins view
properties
fine but non-admins cannot?
==> From the error we have, it does not look like the error is when
specifying the
job schedule. It looks like the error is seen when trying to edit the job
step
properties for an SSIS job. Please confirm.
==>Is this a 32 bit or 64 bit machine?
==> Does it matter where SSIS pkg is stored, if on file system or in msdb?

==> Collect a Backup of regkey: HKCR\CLSID

==> Check if these DLL's are present and/or registered:
- C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvrUtil.dll
- C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTSLog.dll
- C:\Program Files (x86)\Microsoft SQL
Server\90\DTS\Binn\Resources\1033\DTSLOG.rll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.M anagedDTS\9.0.242.0__89845
dcd8080c
c91\Microsoft.SqlServer.ManagedDTS.dll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.D TSRuntimeWrap\9.0.242.0__8
9845dcd8
080cc91\Microsoft.SqlServer.DTSRuntimeWrap.dll

Thanks in advance,
Subhen
--------------------
Quote:
|>|From: Hugo Ahlenius <mssql_usenet (AT) oxel (DOT) net
|>|Newsgroups: microsoft.public.sqlserver.dts
|>|Subject: mssql 2005 express - dtswizard fails
|>|Date: Mon, 23 Jul 2007 08:27:50 -0700
|>|Organization: http://groups.google.com
|>|Lines: 42
|>|Message-ID: <1185204470.224125.205580 (AT) i13g2000prf (DOT) googlegroups.com
|>|NNTP-Posting-Host: 193.10.147.87
|>|Mime-Version: 1.0
|>|Content-Type: text/plain; charset="iso-8859-1"
|>|X-Trace: posting.google.com 1185204471 16256 127.0.0.1 (23 Jul 2007
15:27:51 GMT)
|>|X-Complaints-To: groups-abuse (AT) google (DOT) com
|>|NNTP-Posting-Date: Mon, 23 Jul 2007 15:27:51 +0000 (UTC)
|>|User-Agent: G2/1.0
|>|X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0;
Maxthon; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR
3.0.04506; Tablet PC 2.0),gzip(gfe),gzip(gfe)
Quote:
|>|Complaints-To: groups-abuse (AT) google (DOT) com
|>|Injection-Info: i13g2000prf.googlegroups.com;
posting-host=193.10.147.87;
|>| posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
|>|Bytes: 2694
|>|Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TFEEDS02.phx.gbl!news-out.
cwix.com!newsfeed.cwix.com!newscon02.news.prodigy. net!prodigy.net!border1.nn
tp.dca.giganews.com!nntp.giganews.com!postnews.goo gle.com!i13g2000prf.google
groups.com!not-for-mail
Quote:
|>|Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:3107
|>|X-Tomcat-NG: microsoft.public.sqlserver.dts
|>|
|>|Hi,
|>|
|>|I have just installed SQL Server 2005 sp2 w/ analysis services on my
|>|new Vista Ultimate machine. I am not able to run the DTS Wizard though
|>|- it fails with the error below. Any tips on how to fix this? I have
|>|tried reinstalling the Backward Compability components, as well as the
|>|DTS components.
|>|
|>|-------------------------------------
|>|===================================
|>|
|>|This wizard will close because it encountered the following error:
|>|(Microsoft SQL Server)
|>|
|>|------------------------------
|>|For help, click:

|>|http://go.microsoft.com/fwlink?ProdN...er&ProdVer=9.0
0.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI .WizardFrameworkErrorSR&Ev
tID=UncaughtException&LinkId=20476
Quote:
|>|
|>|===================================
|>|
|>|The specified module could not be found. (Exception from HRESULT:
|>|0x8007007E) (Microsoft.SqlServer.DTSRuntimeWrap)
|>|
|>|------------------------------
|>|Program Location:
|>|
|>| at

|>|Microsoft.SqlServer.Dts.Runtime.Wrapper.Applica tionClass.get_DBProviderI
nfos()
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.Get DtsDbProviderInfos(Wizard
Inputs
|>|wizardInputs)
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DataSourceCom bo.PopulateProviders(Bool
ean
|>|fSources, WizardInputs wizardInputs)
|>| at
|>|Microsoft.SqlServer.Dts.DtsWizard.Step1.OnIniti alizePage(EventArgs e)
|>| at Microsoft.SqlServer.Management.UI.WizardPage.Raise EnterPage()
|>| at Microsoft.SqlServer.Management.UI.WizardForm.NextP age(WizardPage
|>|nextPage)
|>| at Microsoft.SqlServer.Management.UI.WizardForm.Next_ Click(Object
|>|sender, EventArgs e)
|>|
|>|
Subhen Kar,MCTS
SQL Server Core Group
MICROSOFT



Reply With Quote
  #6  
Old   
Subhen Kar [MSFT]
 
Posts: n/a

Default RE: mssql 2005 express - dtswizard fails - 05-06-2008 , 03:56 PM


Hi Hugo,

I think the following action plan may help you out on this problem.Please
understand that this is what I think might help the situation and this may
very well not resolve the problem.

1. Login with an user that has local administrator rights in the computer
(SQL
Server)
2. Check that SQL Server is not registered using the IP address in SQL
Server
Management Studio
3. Verify if the results of this command:
Select @@server_name
Return a SQL Server name that is the same as the HOST computer name
4. Create a new simple SSIS package with single SQL Task. This task query's
from
one of the user tables.
5. Execute the SSIS in SQL Server BI Studio to verify that is works
6. Login in SQL Server Management Studio as SA
7. Deploy the SSIS package to SQL server
8. Create a NEW job (owner = SA)
9. Create a NEW Schedule (owner = SA)

Try to run the JOB

If it fails again then :

==>Test to create/schedule the job from a workstation that has SQL 2005
tools
installed and let me know the outcome. Does it work?
==> Is this specific to only SSIS jobs? Is the problem only for this SSIS
job or any
new SSIS jobs?
==> Does it matter who you're logged in as - for exampe can admins view
properties
fine but non-admins cannot?
==> From the error we have, it does not look like the error is when
specifying the
job schedule. It looks like the error is seen when trying to edit the job
step
properties for an SSIS job. Please confirm.
==>Is this a 32 bit or 64 bit machine?
==> Does it matter where SSIS pkg is stored, if on file system or in msdb?

==> Collect a Backup of regkey: HKCR\CLSID

==> Check if these DLL's are present and/or registered:
- C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvrUtil.dll
- C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTSLog.dll
- C:\Program Files (x86)\Microsoft SQL
Server\90\DTS\Binn\Resources\1033\DTSLOG.rll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.M anagedDTS\9.0.242.0__89845
dcd8080c
c91\Microsoft.SqlServer.ManagedDTS.dll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.D TSRuntimeWrap\9.0.242.0__8
9845dcd8
080cc91\Microsoft.SqlServer.DTSRuntimeWrap.dll

Thanks in advance,
Subhen
--------------------
Quote:
|>|From: Hugo Ahlenius <mssql_usenet (AT) oxel (DOT) net
|>|Newsgroups: microsoft.public.sqlserver.dts
|>|Subject: mssql 2005 express - dtswizard fails
|>|Date: Mon, 23 Jul 2007 08:27:50 -0700
|>|Organization: http://groups.google.com
|>|Lines: 42
|>|Message-ID: <1185204470.224125.205580 (AT) i13g2000prf (DOT) googlegroups.com
|>|NNTP-Posting-Host: 193.10.147.87
|>|Mime-Version: 1.0
|>|Content-Type: text/plain; charset="iso-8859-1"
|>|X-Trace: posting.google.com 1185204471 16256 127.0.0.1 (23 Jul 2007
15:27:51 GMT)
|>|X-Complaints-To: groups-abuse (AT) google (DOT) com
|>|NNTP-Posting-Date: Mon, 23 Jul 2007 15:27:51 +0000 (UTC)
|>|User-Agent: G2/1.0
|>|X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0;
Maxthon; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR
3.0.04506; Tablet PC 2.0),gzip(gfe),gzip(gfe)
Quote:
|>|Complaints-To: groups-abuse (AT) google (DOT) com
|>|Injection-Info: i13g2000prf.googlegroups.com;
posting-host=193.10.147.87;
|>| posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
|>|Bytes: 2694
|>|Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TFEEDS02.phx.gbl!news-out.
cwix.com!newsfeed.cwix.com!newscon02.news.prodigy. net!prodigy.net!border1.nn
tp.dca.giganews.com!nntp.giganews.com!postnews.goo gle.com!i13g2000prf.google
groups.com!not-for-mail
Quote:
|>|Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:3107
|>|X-Tomcat-NG: microsoft.public.sqlserver.dts
|>|
|>|Hi,
|>|
|>|I have just installed SQL Server 2005 sp2 w/ analysis services on my
|>|new Vista Ultimate machine. I am not able to run the DTS Wizard though
|>|- it fails with the error below. Any tips on how to fix this? I have
|>|tried reinstalling the Backward Compability components, as well as the
|>|DTS components.
|>|
|>|-------------------------------------
|>|===================================
|>|
|>|This wizard will close because it encountered the following error:
|>|(Microsoft SQL Server)
|>|
|>|------------------------------
|>|For help, click:

|>|http://go.microsoft.com/fwlink?ProdN...er&ProdVer=9.0
0.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI .WizardFrameworkErrorSR&Ev
tID=UncaughtException&LinkId=20476
Quote:
|>|
|>|===================================
|>|
|>|The specified module could not be found. (Exception from HRESULT:
|>|0x8007007E) (Microsoft.SqlServer.DTSRuntimeWrap)
|>|
|>|------------------------------
|>|Program Location:
|>|
|>| at

|>|Microsoft.SqlServer.Dts.Runtime.Wrapper.Applica tionClass.get_DBProviderI
nfos()
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.Get DtsDbProviderInfos(Wizard
Inputs
|>|wizardInputs)
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DataSourceCom bo.PopulateProviders(Bool
ean
|>|fSources, WizardInputs wizardInputs)
|>| at
|>|Microsoft.SqlServer.Dts.DtsWizard.Step1.OnIniti alizePage(EventArgs e)
|>| at Microsoft.SqlServer.Management.UI.WizardPage.Raise EnterPage()
|>| at Microsoft.SqlServer.Management.UI.WizardForm.NextP age(WizardPage
|>|nextPage)
|>| at Microsoft.SqlServer.Management.UI.WizardForm.Next_ Click(Object
|>|sender, EventArgs e)
|>|
|>|
Subhen Kar,MCTS
SQL Server Core Group
MICROSOFT



Reply With Quote
  #7  
Old   
Subhen Kar [MSFT]
 
Posts: n/a

Default RE: mssql 2005 express - dtswizard fails - 05-06-2008 , 03:56 PM


Hi Hugo,

I think the following action plan may help you out on this problem.Please
understand that this is what I think might help the situation and this may
very well not resolve the problem.

1. Login with an user that has local administrator rights in the computer
(SQL
Server)
2. Check that SQL Server is not registered using the IP address in SQL
Server
Management Studio
3. Verify if the results of this command:
Select @@server_name
Return a SQL Server name that is the same as the HOST computer name
4. Create a new simple SSIS package with single SQL Task. This task query's
from
one of the user tables.
5. Execute the SSIS in SQL Server BI Studio to verify that is works
6. Login in SQL Server Management Studio as SA
7. Deploy the SSIS package to SQL server
8. Create a NEW job (owner = SA)
9. Create a NEW Schedule (owner = SA)

Try to run the JOB

If it fails again then :

==>Test to create/schedule the job from a workstation that has SQL 2005
tools
installed and let me know the outcome. Does it work?
==> Is this specific to only SSIS jobs? Is the problem only for this SSIS
job or any
new SSIS jobs?
==> Does it matter who you're logged in as - for exampe can admins view
properties
fine but non-admins cannot?
==> From the error we have, it does not look like the error is when
specifying the
job schedule. It looks like the error is seen when trying to edit the job
step
properties for an SSIS job. Please confirm.
==>Is this a 32 bit or 64 bit machine?
==> Does it matter where SSIS pkg is stored, if on file system or in msdb?

==> Collect a Backup of regkey: HKCR\CLSID

==> Check if these DLL's are present and/or registered:
- C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvrUtil.dll
- C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTSLog.dll
- C:\Program Files (x86)\Microsoft SQL
Server\90\DTS\Binn\Resources\1033\DTSLOG.rll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.M anagedDTS\9.0.242.0__89845
dcd8080c
c91\Microsoft.SqlServer.ManagedDTS.dll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.D TSRuntimeWrap\9.0.242.0__8
9845dcd8
080cc91\Microsoft.SqlServer.DTSRuntimeWrap.dll

Thanks in advance,
Subhen
--------------------
Quote:
|>|From: Hugo Ahlenius <mssql_usenet (AT) oxel (DOT) net
|>|Newsgroups: microsoft.public.sqlserver.dts
|>|Subject: mssql 2005 express - dtswizard fails
|>|Date: Mon, 23 Jul 2007 08:27:50 -0700
|>|Organization: http://groups.google.com
|>|Lines: 42
|>|Message-ID: <1185204470.224125.205580 (AT) i13g2000prf (DOT) googlegroups.com
|>|NNTP-Posting-Host: 193.10.147.87
|>|Mime-Version: 1.0
|>|Content-Type: text/plain; charset="iso-8859-1"
|>|X-Trace: posting.google.com 1185204471 16256 127.0.0.1 (23 Jul 2007
15:27:51 GMT)
|>|X-Complaints-To: groups-abuse (AT) google (DOT) com
|>|NNTP-Posting-Date: Mon, 23 Jul 2007 15:27:51 +0000 (UTC)
|>|User-Agent: G2/1.0
|>|X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0;
Maxthon; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR
3.0.04506; Tablet PC 2.0),gzip(gfe),gzip(gfe)
Quote:
|>|Complaints-To: groups-abuse (AT) google (DOT) com
|>|Injection-Info: i13g2000prf.googlegroups.com;
posting-host=193.10.147.87;
|>| posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
|>|Bytes: 2694
|>|Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TFEEDS02.phx.gbl!news-out.
cwix.com!newsfeed.cwix.com!newscon02.news.prodigy. net!prodigy.net!border1.nn
tp.dca.giganews.com!nntp.giganews.com!postnews.goo gle.com!i13g2000prf.google
groups.com!not-for-mail
Quote:
|>|Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:3107
|>|X-Tomcat-NG: microsoft.public.sqlserver.dts
|>|
|>|Hi,
|>|
|>|I have just installed SQL Server 2005 sp2 w/ analysis services on my
|>|new Vista Ultimate machine. I am not able to run the DTS Wizard though
|>|- it fails with the error below. Any tips on how to fix this? I have
|>|tried reinstalling the Backward Compability components, as well as the
|>|DTS components.
|>|
|>|-------------------------------------
|>|===================================
|>|
|>|This wizard will close because it encountered the following error:
|>|(Microsoft SQL Server)
|>|
|>|------------------------------
|>|For help, click:

|>|http://go.microsoft.com/fwlink?ProdN...er&ProdVer=9.0
0.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI .WizardFrameworkErrorSR&Ev
tID=UncaughtException&LinkId=20476
Quote:
|>|
|>|===================================
|>|
|>|The specified module could not be found. (Exception from HRESULT:
|>|0x8007007E) (Microsoft.SqlServer.DTSRuntimeWrap)
|>|
|>|------------------------------
|>|Program Location:
|>|
|>| at

|>|Microsoft.SqlServer.Dts.Runtime.Wrapper.Applica tionClass.get_DBProviderI
nfos()
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.Get DtsDbProviderInfos(Wizard
Inputs
|>|wizardInputs)
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DataSourceCom bo.PopulateProviders(Bool
ean
|>|fSources, WizardInputs wizardInputs)
|>| at
|>|Microsoft.SqlServer.Dts.DtsWizard.Step1.OnIniti alizePage(EventArgs e)
|>| at Microsoft.SqlServer.Management.UI.WizardPage.Raise EnterPage()
|>| at Microsoft.SqlServer.Management.UI.WizardForm.NextP age(WizardPage
|>|nextPage)
|>| at Microsoft.SqlServer.Management.UI.WizardForm.Next_ Click(Object
|>|sender, EventArgs e)
|>|
|>|
Subhen Kar,MCTS
SQL Server Core Group
MICROSOFT



Reply With Quote
  #8  
Old   
Subhen Kar [MSFT]
 
Posts: n/a

Default RE: mssql 2005 express - dtswizard fails - 05-06-2008 , 03:56 PM


Hi Hugo,

I think the following action plan may help you out on this problem.Please
understand that this is what I think might help the situation and this may
very well not resolve the problem.

1. Login with an user that has local administrator rights in the computer
(SQL
Server)
2. Check that SQL Server is not registered using the IP address in SQL
Server
Management Studio
3. Verify if the results of this command:
Select @@server_name
Return a SQL Server name that is the same as the HOST computer name
4. Create a new simple SSIS package with single SQL Task. This task query's
from
one of the user tables.
5. Execute the SSIS in SQL Server BI Studio to verify that is works
6. Login in SQL Server Management Studio as SA
7. Deploy the SSIS package to SQL server
8. Create a NEW job (owner = SA)
9. Create a NEW Schedule (owner = SA)

Try to run the JOB

If it fails again then :

==>Test to create/schedule the job from a workstation that has SQL 2005
tools
installed and let me know the outcome. Does it work?
==> Is this specific to only SSIS jobs? Is the problem only for this SSIS
job or any
new SSIS jobs?
==> Does it matter who you're logged in as - for exampe can admins view
properties
fine but non-admins cannot?
==> From the error we have, it does not look like the error is when
specifying the
job schedule. It looks like the error is seen when trying to edit the job
step
properties for an SSIS job. Please confirm.
==>Is this a 32 bit or 64 bit machine?
==> Does it matter where SSIS pkg is stored, if on file system or in msdb?

==> Collect a Backup of regkey: HKCR\CLSID

==> Check if these DLL's are present and/or registered:
- C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvrUtil.dll
- C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTSLog.dll
- C:\Program Files (x86)\Microsoft SQL
Server\90\DTS\Binn\Resources\1033\DTSLOG.rll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.M anagedDTS\9.0.242.0__89845
dcd8080c
c91\Microsoft.SqlServer.ManagedDTS.dll
-
C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.D TSRuntimeWrap\9.0.242.0__8
9845dcd8
080cc91\Microsoft.SqlServer.DTSRuntimeWrap.dll

Thanks in advance,
Subhen
--------------------
Quote:
|>|From: Hugo Ahlenius <mssql_usenet (AT) oxel (DOT) net
|>|Newsgroups: microsoft.public.sqlserver.dts
|>|Subject: mssql 2005 express - dtswizard fails
|>|Date: Mon, 23 Jul 2007 08:27:50 -0700
|>|Organization: http://groups.google.com
|>|Lines: 42
|>|Message-ID: <1185204470.224125.205580 (AT) i13g2000prf (DOT) googlegroups.com
|>|NNTP-Posting-Host: 193.10.147.87
|>|Mime-Version: 1.0
|>|Content-Type: text/plain; charset="iso-8859-1"
|>|X-Trace: posting.google.com 1185204471 16256 127.0.0.1 (23 Jul 2007
15:27:51 GMT)
|>|X-Complaints-To: groups-abuse (AT) google (DOT) com
|>|NNTP-Posting-Date: Mon, 23 Jul 2007 15:27:51 +0000 (UTC)
|>|User-Agent: G2/1.0
|>|X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0;
Maxthon; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR
3.0.04506; Tablet PC 2.0),gzip(gfe),gzip(gfe)
Quote:
|>|Complaints-To: groups-abuse (AT) google (DOT) com
|>|Injection-Info: i13g2000prf.googlegroups.com;
posting-host=193.10.147.87;
|>| posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
|>|Bytes: 2694
|>|Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TFEEDS02.phx.gbl!news-out.
cwix.com!newsfeed.cwix.com!newscon02.news.prodigy. net!prodigy.net!border1.nn
tp.dca.giganews.com!nntp.giganews.com!postnews.goo gle.com!i13g2000prf.google
groups.com!not-for-mail
Quote:
|>|Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:3107
|>|X-Tomcat-NG: microsoft.public.sqlserver.dts
|>|
|>|Hi,
|>|
|>|I have just installed SQL Server 2005 sp2 w/ analysis services on my
|>|new Vista Ultimate machine. I am not able to run the DTS Wizard though
|>|- it fails with the error below. Any tips on how to fix this? I have
|>|tried reinstalling the Backward Compability components, as well as the
|>|DTS components.
|>|
|>|-------------------------------------
|>|===================================
|>|
|>|This wizard will close because it encountered the following error:
|>|(Microsoft SQL Server)
|>|
|>|------------------------------
|>|For help, click:

|>|http://go.microsoft.com/fwlink?ProdN...er&ProdVer=9.0
0.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI .WizardFrameworkErrorSR&Ev
tID=UncaughtException&LinkId=20476
Quote:
|>|
|>|===================================
|>|
|>|The specified module could not be found. (Exception from HRESULT:
|>|0x8007007E) (Microsoft.SqlServer.DTSRuntimeWrap)
|>|
|>|------------------------------
|>|Program Location:
|>|
|>| at

|>|Microsoft.SqlServer.Dts.Runtime.Wrapper.Applica tionClass.get_DBProviderI
nfos()
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.Get DtsDbProviderInfos(Wizard
Inputs
|>|wizardInputs)
|>| at

|>|Microsoft.SqlServer.Dts.DtsWizard.DataSourceCom bo.PopulateProviders(Bool
ean
|>|fSources, WizardInputs wizardInputs)
|>| at
|>|Microsoft.SqlServer.Dts.DtsWizard.Step1.OnIniti alizePage(EventArgs e)
|>| at Microsoft.SqlServer.Management.UI.WizardPage.Raise EnterPage()
|>| at Microsoft.SqlServer.Management.UI.WizardForm.NextP age(WizardPage
|>|nextPage)
|>| at Microsoft.SqlServer.Management.UI.WizardForm.Next_ Click(Object
|>|sender, EventArgs e)
|>|
|>|
Subhen Kar,MCTS
SQL Server Core Group
MICROSOFT



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top