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 |
|
NeilC
Yak Posting Veteran
55 Posts |
 Posted - 2008-03-12 : 13:38:59
|
| Im trying to create a DTS package to import an Excel spreadsheet in to SQL Server 2005 and them Export to a text file. I have successfully imported the data using the import/export wizard, but I am unsure how to add the step that exports the data into a text file. Any ideas or links to a resource that may help me?Thanks in advance! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-12 : 14:14:52
|
| you can create SSIS package . They have so many control flows and data flow task.Use it to get what you want. |
 |
|
|
NeilC
Yak Posting Veteran
55 Posts |
Posted - 2008-03-12 : 14:30:00
|
| I have created the SSIS to import the data, I'm trying to figure out how in the same SSIS package I can export the data using a query |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-12 : 16:04:38
|
| Don't use import/export Wizard for this issue? Go to BIDS(visual studio) and create your own packages. |
|
|
|
NeilC
Yak Posting Veteran
55 Posts |
Posted - 2008-03-12 : 16:35:51
|
| Ok, I opened up BIDS and I don't see anywhere where I can create an SSIS package |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-12 : 16:47:23
|
| goto project-new-integration services and create packages |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-03-14 : 10:10:22
|
| NeilC,Are you familiar with BIDS at all?You need to create a Data Flow and add the correct component to import your data from your .xls to your sql 2005 table and then on that same Data Flow, you can add another .txt file component to to move the data out to a .txt file.If you need that split into 2 separate processes, 1 to move the data from the .xls to the sql table and another one to move the data from the sql table to a .txt file, you can create 2 Data Flows and and have them running separately.The link below should help you out, I hope you're able to figure out how to export it out to a .txt file.http://blogs.techrepublic.com.com/datacenter/?p=205 |
|
|
|
|
|
|
SSIS to Import XLS then Export to TXT