dbTalk Databases Forums  

transfer data file with BCP

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


Discuss transfer data file with BCP in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Munier Pierre
 
Posts: n/a

Default transfer data file with BCP - 02-04-2004 , 09:46 AM






Hello
I try to transfer a data file into a table of my sqlserver 7
the size of my data file is greater than 1 Go.
the bcp utility copies data , however, the latest data doesn't transfering into my table
Could you help me
thank you for your information


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

Default Re: transfer data file with BCP - 02-04-2004 , 10:14 AM






Errors?
What does the Source look like?
What does the destination look like?
Are you using a format file?
Has this ever worked?
If yes then same file structure?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Munier Pierre" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello,
I try to transfer a data file into a table of my sqlserver 7.
the size of my data file is greater than 1 Go.
the bcp utility copies data , however, the latest data doesn't transfering
into my table.
Could you help me?
thank you for your informations




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.