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 |
|
fizzer
Starting Member
10 Posts |
 Posted - 2006-12-21 : 09:50:32
|
Hi,I'm trying to import a text file into sql server 2005. I assume I can do this by creating a Data Transformation Project in Visual Studio under Business Intelligence Projects?I've found a few examples but I haven't got the template in Visual Studio.  Does anybody know what I need to do? |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-12-21 : 11:50:46
|
| Hi - The easiest way to do this is to right-click your database in object explorer and select tasks --> import data. Follow the wizard through, and check the option to save the package.Mark |
 |
|
|
fizzer
Starting Member
10 Posts |
Posted - 2006-12-21 : 12:12:24
|
| Thanks,That looks usefull but can you use that to import into a specific table rather than create a new table? Can't see where you can select a specific table |
|
|
|
|
|
|
Data Transformation Project