Create a import from Excel - 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

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Create a import from Excel

Author

Topic

jfkennedy5
Starting Member

6 Posts

Posted - 2007-02-17 : 20:47:43

Hello All

First time setting up A SSIS

Trying to import a excel that creates a new table called lockbox.

Does not import any records from Columns-Contract Id, Owner ID,
that have a null value.

Then in the Site Id -that is a number value- change to a text value
and update it to it text value.

for example: Site Id Column
2 = Ell
3 = CSI
12 = Ell2

Can someone get me started in the right direction?

Thanks for your time and help

JK

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-02-19 : 10:36:03

Start searching around in Books Online and MSDN Library and you'll find documentation of everything you want to do, for example
http://support.microsoft.com/kb/321686
http://msdn2.microsoft.com/en-us/library/ms141683.aspx
http://msdn2.microsoft.com/en-us/library/ms403358.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources