HELP - Importing Data - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

HELP - Importing Data

Author

Topic

jcb267
Constraint Violating Yak Guru

291 Posts

Posted - 2008-11-19 : 20:35:44

I am really stuck importing data. Can anyone help me please? I have tried a couple of things - importing from Excel, Access and a text file. None of it worked......

SimpleSQL
Yak Posting Veteran

85 Posts

Posted - 2008-11-19 : 21:25:49

How are you importing the data, through DTS/SSIS or BCP? You would need to provide more details as to what errors you are getting to get assistance.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-19 : 22:08:16

How did you import?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-20 : 00:44:54

http://www.mssqltips.com/tip.asp?tip=1207

jcb267
Constraint Violating Yak Guru

291 Posts

Posted - 2008-11-20 : 16:43:54

I did not use a wizard - DTS/SSIS or BCP. I just used code from a colleague in the query analyzer of SQL Server Management Studio. I am using SQL Express 2005.

quote:
Originally posted by sodeep

How did you import?

jcb267
Constraint Violating Yak Guru

291 Posts

Posted - 2008-11-20 : 16:44:45

I think it is SSIS with 2005, correct?

quote:
Originally posted by jcb267

I did not use a wizard - DTS/SSIS or BCP. I just used code from a colleague in the query analyzer of SQL Server Management Studio. I am using SQL Express 2005.

quote:
Originally posted by sodeep

How did you import?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-21 : 01:57:44

quote:
Originally posted by jcb267

I think it is SSIS with 2005, correct?
quote:
Originally posted by jcb267

I did not use a wizard - DTS/SSIS or BCP. I just used code from a colleague in the query analyzer of SQL Server Management Studio. I am using SQL Express 2005.

quote:
Originally posted by sodeep

How did you import?

yup. but its not available as default option along with sql 2005 express

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-11-21 : 02:39:08

From where you are expecting the data to be imported? from excel or access?

Arnav
Even you learn 1%, Learn it with 100% confidence.

jcb267
Constraint Violating Yak Guru

291 Posts

Posted - 2008-11-21 : 12:12:20

I got the wizard to work, I am trying to import data from excel. It creates the table but does not import any data. Here is the error message I am getting:

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - '01-01-07 to 06-30-07$'" (1).
(SQL Server Import and Export Wizard)

- Prepare for Execute (Stopped)

- Pre-execute (Stopped)

- Executing (Success)

Do you know what is means and how I can work around it?

quote:
Originally posted by sunsanvin

From where you are expecting the data to be imported? from excel or access?

Arnav
Even you learn 1%, Learn it with 100% confidence.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-21 : 12:18:58

see this

http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

jcb267
Constraint Violating Yak Guru

291 Posts

Posted - 2008-11-21 : 12:40:33

Thanks!