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.
| Author |
Topic |
|
illumna
Starting Member
4 Posts |
 Posted - 2009-06-22 : 15:19:09
|
| First, I have a book showing how to use SSIS to import data into my database. The book instructs the reader to right-click over the database and choose Tasks->Import ....I do not have the option to import. Is it because I'm using SQL Server Management Studio Express version? If so, how do I install professional. I'm already using SQL Server professional or developer edition but not Express.Also, upon using SSIS to import from an OLEDB database, will it create the tables on my local database that I'm importing to? I know DTS does this with a flat file but I can't seem to do it when importing from my OLEDB database because it's asking for an existing table. Is there a way to get the table created dynamically?Thank You. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-24 : 13:32:48
|
| you need to install express toolkit. see belowhttp://www.sqlmag.com/Article/ArticleID/95797/sql_server_95797.html |
 |
|
|
|
|
|
Import to new table