Prev: NOLOCK SQL Query Safety
Next: Msg 226, Level 16, State 6, Line 4 ALTER DATABASE statement not allowed within multi-statement transaction.
From: "privatenews" on 6 Apr 2006 01:00
Hello Brian,

Before we go further, please let me know if the workaround I mentioned work
for your situation.

I'd like to know the Windows OS edition and SQL 2005 edition? Please note
SQL Server 2005 Integration Services cannot be installed on a Windows
XP-based computer from an installation of SQL Server 2005 Enterprise
Edition. If this is the situation, you may need to install SSIS from
standard editon setup CD.

If it is not the case, please try to remove/reinstall SSIS service via
Add/Remove programs to test.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
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: "Brian VanDyke" <brianv(a)community.nospam>
>References: <#igmlL$VGHA.5692(a)TK2MSFTNGP09.phx.gbl>
<0fmdnfVb9PgvDK_ZRVnysA(a)bt.com> <eo#J0EBWGHA.5044(a)TK2MSFTNGP09.phx.gbl>
<3RgVhoFWGHA.3700(a)TK2MSFTNGXA01.phx.gbl>
>Subject: Re: SQL2005 Import
>Date: Wed, 5 Apr 2006 11:03:28 -0500
>Lines: 142
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <#LqJ#pMWGHA.1348(a)TK2MSFTNGP05.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.programming
>NNTP-Posting-Host: 198.174.61.94
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.programming:591033
>X-Tomcat-NG: microsoft.public.sqlserver.programming
>
>The SSIS tools are installed on the same server as the admin tools. How do
I
>tell if the "full SSIS runtime" is installed? It was selected on
>installation and when I just went through the install again to see if
there
>were any missing check boxes, I did not see any. As far as the derived
>columns are concerned, these are simply files with no data type not
already
>known by SQL Server. I have attempted this on an Access database table, an
>Excel spreadsheet, and even a DBF file without any success. The same error
>about my product level continues to appear.
>
>Thanks!
>
>-Brian
>
>""privatenews"" <petery(a)online.microsoft.com> wrote in message
>news:3RgVhoFWGHA.3700(a)TK2MSFTNGXA01.phx.gbl...
>> Hello Brian,
>>
>> This problem could occur because one or more of the following conditions
>> are true:
>>
>> -The Microsoft SQL Server 2005 Integration Services (SSIS) tools are
>> installed. However, the full SSIS runtime is not installed.
>> - The version of SQL Server 2005 that is installed does not support the
>> derived column transformations that the SSIS package contains.
>> - The Microsoft SQL Server 2005 Integration Services (SSIS) service is
not
>> installed on the computer that has the SQL Server 2005 administration
>> tools
>> installed.
>>
>> I'm not sure the which SQL server edition you installed on the server?
>>
>> To work around the problem with a package that contains a flat file
>> document, create an SSIS package by using the SQL Server Import and
Export
>> Wizard. Then, run the SSIS package in SQL Server Business Intelligence
>> Development Studio.
>>
>> To create an SSIS package by using the SQL Server Import and Export
>> Wizard,
>> follow these steps:
>>
>> 1. On the Save and Execute Package page, clear the Execute immediately
>> check box.
>> 2. Select Save SSIS Package.
>>
>> To run the SSIS package in SQL Server Business Intelligence Development
>> Studio, follow these steps:
>>
>> 1. Open SQL Server Business Intelligence Development Studio, and then
>> create a new Integration Services project.
>> 2. In Solution Explorer, right-click the SSIS Packages node, and then
>> click
>> Add Existing Package.
>> 3. In the Add Copy of Existing Package dialog box, select the package
that
>> you created by using SQL Server Import and Export Wizard.
>> 4. Under the SSIS Packages node, double-click the name of the SSIS
package
>> that you just added.
>> 5. Press CTRL+F5 to run the package.
>>
>> Regards,
>>
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> 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: "Brian VanDyke" <brianv(a)community.nospam>
>>>References: <#igmlL$VGHA.5692(a)TK2MSFTNGP09.phx.gbl>
>> <0fmdnfVb9PgvDK_ZRVnysA(a)bt.com>
>>>Subject: Re: SQL2005 Import
>>>Date: Tue, 4 Apr 2006 12:57:06 -0500
>>>Lines: 41
>>>X-Priority: 3
>>>X-MSMail-Priority: Normal
>>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>>X-RFC2646: Format=Flowed; Original
>>>Message-ID: <eo#J0EBWGHA.5044(a)TK2MSFTNGP09.phx.gbl>
>>>Newsgroups: microsoft.public.sqlserver.programming
>>>NNTP-Posting-Host: 198.174.61.94
>>>Path:
>>
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP0
>> 9.phx.gbl
>>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.programming:590828
>>>X-Tomcat-NG: microsoft.public.sqlserver.programming
>>>
>>>SSIS is installed. The table gets created, but the data does not get
>>>imported.
>>>
>>>-Brian
>>>
>>>"Jack Vamvas" <delete_this_bit_jack(a)ciquery.com_delete> wrote in message
>>>news:0fmdnfVb9PgvDK_ZRVnysA(a)bt.com...
>>>> 1)Could you doublecheck whether SSIS is installed?
>>>> 2)Is the table being created and no data going in?
>>>>
>>>> --
>>>> Jack Vamvas
>>>> ___________________________________
>>>> Receive free SQL tips - www.ciquery.com/sqlserver.htm
>>>>
>>>> "Brian VanDyke" <brianv(a)community.nospam> wrote in message
>>>> news:#igmlL$VGHA.5692(a)TK2MSFTNGP09.phx.gbl...
>>>>> I am attempting to import the contents of an MS Excel spreadsheet
into
>>>>> a
>>>> new
>>>>> table in a SQL 2005 database. However, I keep getting the following
>>>> error...
>>>>>
>>>>> Error 0xc00470fe: Data Flow Task: The product level is insufficient
for
>>>>> component "Source - TellerUse$" (1)
>>>>>
>>>>> ...This is not the first time I've rec'd that error. But I am not
>> certain
>>>>> what the error means. I get a similar error when attempting to import
>>>>> from
>>>>> an Access XP database as well. As a workaround, I was able to import
it
>>>> into
>>>>> a SQL 2000 database using DTS, then import it into SQL 2005 from
there.
>>>>>
>>>>> Any thoughts?
>>>>>
>>>>> -Brian
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>
>
>

First  |  Prev  | 
Pages: 1 2
Prev: NOLOCK SQL Query Safety
Next: Msg 226, Level 16, State 6, Line 4 ALTER DATABASE statement not allowed within multi-statement transaction.