June 9, 2008 at 12:00 pm
User has dbo on all databases in sql server 2005 and dtsoperator in msdb. He cannot export from these complete tables in the db to a text file. He is limited to 5000 rows to text file using the DTS 2000 Import Export Wizard. User also has bulkadmin rights. Any ideas?
¤ §unshine ¤
June 9, 2008 at 12:23 pm
I might be misreading something, but why are you using DTS 2000 on an SQL 2005 database?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 9, 2008 at 12:26 pm
Users are out in another country and have not been trained for SSIS. DTS Import/Export Wizard works for imports but only exports up to 5k to text files.
¤ §unshine ¤
June 9, 2008 at 2:23 pm
Might need to set them up with an SSIS package that exports the tables they are looking for. Or with a bcp command for it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 9, 2008 at 2:28 pm
We have not given them access to anything but the dts import/export. They do adhoc imports and exports to this database. That's all they know how to do.
¤ §unshine ¤
June 9, 2008 at 2:30 pm
Can't help you with that one then. I'd recommend bcp, but if you say they can't, I don't know what else to suggest. Maybe someone else can help.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 9, 2008 at 2:40 pm
ok, thank you so much for your help.
¤ §unshine ¤
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply