| Author |
Topic |
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
 Posted - 2008-08-14 : 12:48:44
|
| i need to output all the tables but 2 from the database to a TXT file using SSIS? how can i achieve it? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-14 : 12:54:55
|
| With Export/Import wizard,BCP. |
 |
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-08-14 : 13:12:32
|
| imp9ort/export doesnt do itbcp is not ssis |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-14 : 14:35:28
|
| Why import/export doesnt do it? you can use it for outputing to text file. Just give flat file connection as destination. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-14 : 14:53:32
|
quote:
Originally posted by lamujerdetuhermano10
i need to output all the tables but 2 from the database to a TXT file using SSIS? how can i achieve it?
What you need to output ? Data or table structure with data? Explain cleary first? |
|
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-08-14 : 20:00:32
|
| Try it and u find out |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-14 : 21:50:34
|
| Why I have to try? |
|
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-08-15 : 00:29:10
|
| forget it looks like u dont know |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-15 : 00:38:16
|
| Did you get error or sql doesn't let you do what you want? |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-08-15 : 09:44:02
|
quote:
Originally posted by lamujerdetuhermano10
i need to output all the tables but 2 from the database to a TXT file using SSIS? how can i achieve it?
Open SQL Server Business Intelligence Development Studio and create an project that does what you want.CODO ERGO SUM |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2008-08-15 : 10:20:54
|
quote:
Originally posted by lamujerdetuhermano10
forget it looks like u dont know
 Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-08-15 : 10:24:21
|
quote:
Originally posted by lamujerdetuhermano10
forget it looks like u dont know
You have uncovered the awful truth. Nobody on this forum actually knows how to use SSIS.We are sending some agents out to deal with you promptly, and permanently.Boycott Beijing Olympics 2008 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-08-15 : 12:13:22
|
| so do u know yes or no? pls dont waste my time |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-15 : 12:21:07
|
Oh, your time is more valuable than ours?Or are you in distress on the job?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-15 : 12:22:20
|
quote:
Originally posted by Peso
Oh, your time is more valuable than ours?Or are you in distress on the job?
E 12°55'05.25"N 56°04'39.16"
He seems like a funketekun in the making |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-15 : 12:24:05
|
He is Funketekun.lamujerdetuhermano10 is also known as Gonxia649 or escaleraroyal.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-15 : 12:29:13
|
quote:
Originally posted by Peso
He is Funketekun.lamujerdetuhermano10 is also known as Gonxia649 or escaleraroyal.
E 12°55'05.25"N 56°04'39.16"
ah...no wonder  |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-15 : 12:31:11
|
quote:
Originally posted by lamujerdetuhermano10
pls dont waste my time
Remember what you wrote here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72882 ?quote:
Originally posted by funketekun
peso, that is brilliant.I have to start reading about normalization more.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-15 : 13:37:08
|
quote:
Originally posted by lamujerdetuhermano10
so do u know yes or no? pls dont waste my time
Your company's time and money is wasted by having people like you. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Next Page
|
output to TXT file