sql server dts: New to SSIS and importing csv & .xls - need assistance -- sql server dts

New to SSIS and importing csv & .xls - need assistance

pbrill1
10/25/2007 1:16:01 PM

sql server dts:

From a new SQL DB 'admin' trying to use SQL 2005's BI features,

As a small-company 'SQL DB administrator' (still climbing up the SQL2005
learning curve), I am trying to find resources that would allow me to:

1) Perform an initial import of a .csv / .xls to create a table in SQL 2005
(we use Standard)

2) Be able to syncronize this user's spreadsheet (either on demand or
through a batch process, if that's the only thing available) to modify the
table as it is created.

The purpose of this is to provide a table that I can merge with our ERP
vendor's tables, to supplement information that we don't plan for our ERP
vendor to build into their program.

Any advice or links on how to incorporate Excel/.csv tables into SQL 2005
for eventual use in Analysis Services/Reporting Services would be greatly
appreciated.

(I'm assuming that .DTS is the right forum - please let me know if there is
an SSIS forum that I'm not finding)
--

Re: New to SSIS and importing csv & .xls - need assistance

jhofmeyr NO[at]SPAM googlemail.com
10/26/2007 1:47:59 AM

[quoted text, click to view]

Hi pbrill1,

Have you tried running the Import Data wizard? A good way to get a
quick and dirty look at SSIS is to run the Import wizard and then save
the package at the end instead of simply executing and discarding it.
You can then open up the package generated and see how the bits fit
together.

I'm a big fan of internet resources (check out www.sqlis.com) and of
course BoL is also your friend. There are a few good microsoft white
papers out there, and in particular have a look for the Project Real
case study produced by Hitachi consultants.

Finally, there is a .integrationsvs group, but it seems the .dts group
is used for both anyway.

Good luck!
J