Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Client can't import flat file to remote DB

Author  Topic 

MrTexasFreedom
Starting Member

13 Posts

Posted - 2010-10-27 : 19:58:28

I've searched the forums and found some advice, but a lot of people encountering this error are trying to schedule batch jobs using packages. I am using SQL Server Management Studio to try to upload to a "Microsoft SQL Server Standard Edition (64-bit)" on a remote machine. I encounter the following error:

[CODE]
- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - 'Corp Carrier Plans$'" (1).
(SQL Server Import and Export Wizard)

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source 1 - Sheet2$" (37).
(SQL Server Import and Export Wizard)
[/CODE]


What needs to be installed or upgraded on the client or server to be able to import flat text files?

Appreciatively,

MrTexasFreedom
   

- Advertisement -