dbTalk Databases Forums  

Cannot import data into SQL Server database from FileMaker Pro 5.5

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Cannot import data into SQL Server database from FileMaker Pro 5.5 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Marina S.
 
Posts: n/a

Default Cannot import data into SQL Server database from FileMaker Pro 5.5 - 10-05-2004 , 01:00 PM






Hi everyone,

I have some problem,I'm trying to import data using sql statements
into SQL Server,because I have 2124 columns,so I have to devide it
into 3 sql statements.
When I'm trying to execute DTS package,I got some error.
So I'm trying to import only one record into sql server,but it takes
so long,and it seems like File Maker executes all the recors
meanwhile.
Any ideas,friends?

Thanks,
Marina

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Cannot import data into SQL Server database from FileMaker Pro 5.5 - 10-05-2004 , 01:56 PM






What error is the "some error"?

Can you use the same sql statement using the same provider (DSN) using a
different client and it execute any quicker?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Marina S." <marina.sukhnev (AT) thinknet (DOT) com> wrote

Quote:
Hi everyone,

I have some problem,I'm trying to import data using sql statements
into SQL Server,because I have 2124 columns,so I have to devide it
into 3 sql statements.
When I'm trying to execute DTS package,I got some error.
So I'm trying to import only one record into sql server,but it takes
so long,and it seems like File Maker executes all the recors
meanwhile.
Any ideas,friends?

Thanks,
Marina



Reply With Quote
  #3  
Old   
Marina S.
 
Posts: n/a

Default Re: Cannot import data into SQL Server database from FileMaker Pro 5.5 - 10-06-2004 , 09:49 AM



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:
What error is the "some error"?

Can you use the same sql statement using the same provider (DSN) using a
different client and it execute any quicker?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Marina S." <marina.sukhnev (AT) thinknet (DOT) com> wrote in message
news:440f14ee.0410051000.36f87ee6 (AT) posting (DOT) google.com...
Hi everyone,

I have some problem,I'm trying to import data using sql statements
into SQL Server,because I have 2124 columns,so I have to devide it
into 3 sql statements.
When I'm trying to execute DTS package,I got some error.
So I'm trying to import only one record into sql server,but it takes
so long,and it seems like File Maker executes all the recors
meanwhile.
Any ideas,friends?

Thanks,
Marina
Thank you Allan,
I've solved that problem.

Cheers,
Marina


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.