June 4, 2008 at 6:25 am
Hi,
I have SQL SERVER 2005....when i am exporting around 360 rows to an access file...SQL SERVER doesn't allow me to select 360 rows at time...it ask me to select fewer tables at a time.....
Is there any way by which I can export 360 or more no. of rows to an access file in a single export operation?
Please help me out.....:)
June 4, 2008 at 6:28 am
Exporting 360 rows should not be a problem.
what is the exact error message you get ?
June 4, 2008 at 6:44 am
Error Msg :
"A large no of tables are selected for copying, and the wizard may not be able to copy all the tables in a session.select NO to go back and unselect some tables,or select Yes to attempt to copy all the currently selected tables at one time"
June 4, 2008 at 6:47 am
you said 360 rows, do you mean 360 tables?
June 4, 2008 at 7:00 am
my mistake...it is 360 tables.....
June 4, 2008 at 11:49 am
Really curious.
Are you trying to export 360 tables at the same time, in the same session?
~PD
June 4, 2008 at 10:04 pm
Yes,
We need to deliver the 360 tables data into the one access mdb file.
We used to do the same successfully in SQL Server 2000 using the DTS, but now we have the SQL Server 2005.
In the SQL 2005 we are facing this issue.
I have seen there is one option Optimizing the Export and Import....what does mean?
its get deactivated when I do the Import or Export. Any cLue?
Another Problem ?
1. We are not able to Export a Oracle Data into a access mdb file using the SQL Server 2005 SSIS tool?
we used to do the same in SQL 2000 DTS.
June 5, 2008 at 12:10 am
Why dont you break it into smaller tasks?
Doing 360 things in the same go is a little over the top. What happens if one of the tables has a problem? You will have to redo all 360 if its in the same task
Yes its possible, simply use an Ora source and Access destination
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply