![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |