French Characters Are Not Imported Properly With Bcp

Mar 24, 2006

Hi
I have a script that uses bcp to import data from an ascii text file
into SQL tables. The french characters are not copied properly. They
are converted to letters of the alphabet. I tried to change all the
fields to nvarchar instead of varchar and nchar instead of char, but I
got Greek characters instead.

How can I fix this?

Here is some code:
--------------------------
CREATE TABLE [dbo].[1_HLGT_HLT_COMP_f9.0] (
[hlgt_code] [int] NOT NULL ,
[hlt_code] [int] NOT NULL
) ON [PRIMARY]
GO

PRINT 'HLGT_HLT'
DECLARE @s as nvarchar(300)
SET @s='bcp MedDRA..[1_hlgt_hlt_comp_f9.0] in ' + char(34) +
'F:MedDRA9.0FrenchMedAsciihlgt_hlt.asc' + char(34) + ' -c -t' +
char(34) + '$' + char(34) + ' -r$
-e' + char(34) +
'F:MedDRA9.0Frenchlogshlgt_hlt.err.txt' + char(34) + ' -b250 -m50
-SDEV -Usa -Ppassword -h' + char(34) + 'TABLOCK' + char(34)
EXEC master..xp_cmdshell @s

View 8 Replies


ADVERTISEMENT

Simple Character Problem With French Characters

Sep 5, 2007

Hi, i have a simple character problem.
In the table i have names from the entire europe, looks and works great except for the french names.
This is what i get:
Al?ay Al?abehety Sunharette
This is what it should look like:
Alςay Alςabehety Sunharette
 
I have tried alot of things, but its not working, also tried to change Collation to Latin1, does UTF-8 excist?
I am using MSSQL 2005
 
regards Patrick

View 5 Replies View Related

Storing French Characters To SQL Data Base

May 30, 2008

Hi
I find that users of my web site are using Canadian French character encoding such as ALT0233 (= é) or ALT0244 (= ô) when completing text boxes for data input on .aspx pages.
When saved to the SQL db, these characters are converted to é or ô and when retrieving the data, appear as é or ô in the text box.
The datatype in the table is nvarchar(60).  
Data is saved using command.Parameters.AddWithValue("@PostingTitle", Server.HtmlEncode(Trim(Me.txtPostingTitle.Text)))
How can I save the data with the correct character inserted into the db and subsequently retreive the character.
Thanks in advance.
 
 
 

View 3 Replies View Related

Foreign Characters Are Not Being Imported Into The Table Correctly

Nov 13, 2006

hello everyone,

i have few fields that contain foreign characters with diacritic marks which are not getting imported correctly.

below is the import format:

- File type: ASCII
- Row delimiter: carriage return and line feed {CR/LF}
- Column delimiter: Tab
- Text qualifier: None

Please advice.

Here is the errors i'm getting:

- Executing (Error)



Messages

Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "Country_str_local_long_name" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)


Error 0xc020902a: Data Flow Task: The "output column "Country_str_local_long_name" (37)" failed because truncation occurred, and the truncation row disposition on "output column "Country_str_local_long_name" (37)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)


Error 0xc0202092: Data Flow Task: An error occurred while processing file "L:Country.txt" on data row 6.
(SQL Server Import and Export Wizard)


Error 0xc0047038: Data Flow Task: The PrimeOutput method on component "Source - Country_txt" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
(SQL Server Import and Export Wizard)


Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited with error code 0xC0047038.
(SQL Server Import and Export Wizard)


Error 0xc0047039: Data Flow Task: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
(SQL Server Import and Export Wizard)


Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with error code 0xC0047039.
(SQL Server Import and Export Wizard)


View 1 Replies View Related

French Accent

May 28, 2007

Using MSDE 2000



I made a script to create my database and insert default values in some tables. The problem is that all the accent are replace by junk ("UnitÚs instead of Unités"). But if I insert values with Server Explorer, ADO.Net or oSql it work fine...



Anyone as an idea on why accent are replace by junk only when insertion are made by a script.



Thanks

View 4 Replies View Related

French Canadian In France That Needs Help

Feb 19, 2004

Peaked a look, hey?
now try answering this


I've got on my computer
- SQL Server 2K
- my database

I open SQL Enterprise Manager

How can I create a new - L O C A L - Server under my Server Group
WITHOUT using the computer name (computernameinstancename)

View 14 Replies View Related

Searching French Words In Server 2008

Feb 17, 2014

I have french word like "Services d'organisation de minaires"..and i want to search word in SQL SERVER 2008. but the main problem is SQL SERVER give an Error because of string break.Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'organisation'.

View 1 Replies View Related

SQL 2012 :: Column Collation For Spanish And For French

Dec 17, 2014

I have a developer that would like to store a column of data in Spanish and another column of data in French. What collation should I set for each column?

View 3 Replies View Related

Cannot Install SQL Express On A French Win2003 Server OS

Mar 30, 2007

This one has me scratching my head. We can install SQL Express on many different English OS without problems, but when we try it on a French OS it doesn't work. We have several French systems and SQL Express does not install on any of them. Even just running the SQLEXPR32.EXE without paramaters give the same error. We have yet to try it on other foreign OS. The command line we use to install is:



SQLEXPR32.EXE /qb INSTANCENAME="TESTINSTANCE" ADDLOCAL=ALL SECURITYMODE=SQL SAPWD=<StrongPassword> DISABLENETWORKPROTOCOLS=0



I've tried various solutions from these links:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=136496&SiteID=1
http://www.developersdex.com/sql/message.asp?p=1870&r=4699024&Page=1
http://www.developersdex.com/sql/message.asp?p=1870&r=4699024&page=2

However, none of them work. Has Microsoft actually tested the installer on a foreign OS? Below is the details of the setup log file:



Microsoft SQL Server 2005 Setup beginning at Thu Mar 29 14:09:31 2007
Process ID : 2232
c:f66fbb131aeb0b5e04aed9ecb936c1setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/2/29 14:9:31
Complete: LoadResourcesAction at: 2007/2/29 14:9:31, returned true
Running: ParseBootstrapOptionsAction at: 2007/2/29 14:9:31
Loaded DLL:c:f66fbb131aeb0b5e04aed9ecb936c1xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/2/29 14:9:31, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: Le fichier spécifié est introuvable.

Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2232"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/2/29 14:9:31
Complete: ValidateWinNTAction at: 2007/2/29 14:9:31, returned true
Running: ValidateMinOSAction at: 2007/2/29 14:9:31
Complete: ValidateMinOSAction at: 2007/2/29 14:9:31, returned true
Running: PerformSCCAction at: 2007/2/29 14:9:31
Complete: PerformSCCAction at: 2007/2/29 14:9:31, returned true
Running: ActivateLoggingAction at: 2007/2/29 14:9:31
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00CBCFC4Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: Le fichier spécifié est introuvable.

Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2232"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2






We really need to get this resolved. Thanks! Jon.

View 1 Replies View Related

Can I Attach A Database Collation= En-us To A French 2005 Instance ?

Apr 24, 2008

Hello,

I want to attach a database collation en-us to an instance ( downloaded as french ).

I would want to know if i may have known problems ( i want download databases samples in english only )

Sql Server 2005 Express SP2 with advanced services

Many thanks beforehand

Have a nice day

View 3 Replies View Related

SQL Server 2005 Unattended Install Bootstrapper Fails On French XP System

Jan 10, 2008

The scenario I have is as follows:

Our product ships with a bootstrapper that installs SQL Server 2005 silently for our clients - basically it's a pre-req which we load for them if it's not already installed.

The bootstrapper supplies the service account identity parameters for the SQL Server install command line in English. It supplies the local system account (NT AUTHORITYSYSTEM).


The problem occurs when we tried to install the product onto a French version of XP. We got the error message "SQL Server setup could not validate the service accounts. Either the service accounts have not been provided for all the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account."


Having read the page http://msdn2.microsoft.com/en-us/library/ms143504.aspx#Localized_service_names we have discovered that the system account identity has a different name for French (AUTORITE NTSYSTEM) along with some other languages ... but we're not sure how to resolve the problem.

Can anyone out there tell me whether we ...
1) Can get the machine being installed on to tell us the local system account identity so we can substitute it into our command line in the bootstrapper?
2) Have to write a different bootstrapper for each language that names the local system account identity differently?
3) Have overlooked some other solution?


Also, does anyone know how many languages and which they are that give the local system account a name that's different to "NT AUTHORITYSYSTEM"??

Thanks,
Sara

<EDIT>

Sorry, omitted a vital bit of information. The bootstrapper is written in C++.
We know the .NET code to retrieve an NT account given a well known SID. Can we do the same in C++ somehow??
</EDIT>

View 3 Replies View Related

ReportServer URL Access : French Language Problem For Parameters (dates) After Installing SQL 2005 SP2

Mar 3, 2007

Hello,

We are using ReportServer URL Access. The parameters aren't pass into the URL, they have a default value and it's possible to change them by the "parameter toolbar". We are using datetime parameters with the very usefull calendar...

We are using a French version of : Windows (XP or W2K3), SQL2005+SP1 and VS2005 + SP1. It works fine, the calendar (for datetime parameter) is in French.

After installing the French SP2, the calendar is in English (w2k3 + VS2005 SP1). On a new installation (XP), with SQLExpress SP2 Advanced + Toolkit (in French), we have the same problem.

With this URL (solution 1), the calendar is in English (it was in French before the SP2):

http://localhost/Reportserver$SQLExpress?%2fProjet+de+rapport1%2fReport1&rs:Command=Render

But with this URL (solution 2), the calendar is in French :

http://localhost/ReportServer$SQLExpress/Pages/ReportViewer.aspx?%2fProjet+de+rapport1%2fReport1&rs%3aCommand=Render

In the documentation, we have to use solution 1 (but we have a problem). Is the solution 2 a possible "alternative" ?

Thanks for your help,

Frederic

View 2 Replies View Related

How Can I Store Over 16000 Characters To Sql Table Field With Language Specific Characters?

Feb 19, 2008

In my application I must store over 16000 character in a sql table field . When I split into more than 1 field it gives "unclosed quotation mark" message.
How can I store over 16000 characters to sql table field (only one field) with language specific characters?
 
Thanks
 
 

View 3 Replies View Related

Cannot See DTS Imported By Legacy DTS

Mar 16, 2007

Hi,
I have imported 3 DTS from SQL 2000 to the SQL 2005 server. The wizard went fine, everything is ok. When I close the wizard window, I cannot see any of them. If I reimport it, it asks confirmation to override it. Where are the 3 DTS in the management Studio if they are not under Legacy DTS?
Thanks

View 4 Replies View Related

Separate Lowercase Characters From Uppercase Characters

Mar 5, 2008


Hi everybody,
I would like to know if there is any property in sql2000 database to separate lowercase characters from uppercase characters. I mean not to take the values €˜child€™ and €˜Child€™ as to be the same. We are transferring our ingres database into sqlserver. In ingres we have these values but we consider them as different values. Can we have it in sqlserver too?

Hellen

View 1 Replies View Related

Validating Imported Values

Jan 18, 2005

I am using the following SQl statement in a DTS vb file.
The data is coming from an Excel spreadsheet and being put into a SQl server table.

oCustomTask1.SourceSQLStatement = "select `Order No`,`Country`,`Desc`,`Amount` from `Sheet1$` WHERE `Order No` = 1 "


I want to validate the data being put into the table to ensure no duplicates records are entered UNLESS the record has changed in any way.
E.g. If record 1 had a column called "NumberOne" which changed to "Number1" change this information and move the original value to another table.

View 2 Replies View Related

SQL6.5==>SQL 7 Index & SP Not Imported.

Oct 21, 1998

I installed SQL 7 on a new computer and imported DB from another SQL 6.5.
Tables were imported but index and SPs were not.

I had to script those objects and run it on SQL 7.

Any shortcut to import all objects directly?

Again I was importing not upgrading.

View 2 Replies View Related

Imported From SQL Server To MSDE 8

Jun 4, 2004

Hi. I am working on a dynamic website and backed up the data from our database (SQL Server) into a .bak file from our server. I want to develop the site locally on another machine (doesn't have SQL Server, but MSDE) using the database so I restored the database backup using RESTORE DATABASE FROM... (in the DOS prompt). I found a tutorial how to do this at

http://www.popkin.com/customers/customer_service_center/tip_of_the_week/01_19_04/tipofweek.htm

It did the restore successfully (or so it said) but all that it restored was the database structure (table structure, user information, etc.) but not the actual data in the database. I am using Specify (www.specifysoftware.org) as a database manager.

Could anyone help me out? Can I not go from SQL Server to MSDE? This doesn't seem to be the case because the structure restored okay.
What should I do to correct this problem?


Thanks for your help in advance!

Nik

View 1 Replies View Related

Proprties Not Imported With Table

Mar 18, 2004

I am developing a DB with others in my group. When I import tables created on other servers to my server, the primary key and other properties do not import with the tables. Can anyone explain why this is happening? Is there a setting I have over looked?

View 3 Replies View Related

DTS To Add A Field On Imported Data

Jul 20, 2005

I am in the process of importing data that is in a text format to thesql server, I want to add couple of fields and insert general data inthe fields added, this data is going to be similar to all the recordsimported. Your help in this regard will be greatly appreciated.

View 1 Replies View Related

How To Keep Tables Updated That Are Imported From Other Database

Apr 9, 2007

Dear All,
 
I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2000 as a back End.
 
Actually I am fetching data from other database(named as retailexcel but in same server). I have wriiten a view (in retailexcel database) to get required data from four table of other database. My problem is when I fetch those data(about 40000 to 50000 record) It  taking to much time. I tried catch feature of asp.net2.0. Time reduced but not significantly. So I am trying to import those tables to my database (named Inventory) from that retailexcel.
 
Now problem is every day or two, record of  those tables changes. How can I keep update my tables (which are importing from retailexcel)
 
 
Please suggest me some idea.
 
Thanks  
 
 

View 1 Replies View Related

How To Use Imported Tables From Multiple Users

May 30, 2003

We have an OLTP application with multiple one to many tables relationships that are edited client side. For Example the primary table has descriptive components. One of the multiple table have things like parts and quantity ordered linked by a record number back to the primary table.

When our client transmits their transaction, they actally running a batch job which sends all the client side tables to the SQL Server and then we are trying to issue a stored procedure server side to push this data into our 'dbo' owned server side master tables.

Our problem is generating the fully qualified table name for the from clause.

We have tried declaring a variable but the stored procedure won't compile. Tried user, user_name().

Any solutions would be greatly appreciated.

View 3 Replies View Related

Anyone Imported Text File Generated From DB2?

Jun 26, 2006

Has anyone import into SQL Server a text file generated by DB2?

the DB2 files has bunch of weird characters in it that look like they are used for formatting...as opposed to actually being data.

Also, SQL can't find a row terminator.

I received a cobol declaration copy book for the data, but I have no idea what to do with the special characters.
Any help would be appreiciated.

There's a sample of the copybook...

* COBOL DECLARATION FOR TABLE @TNJ00.PL_JUDGM_ATTORNEY *
************************************************** ****************
01 DCLPL-JUDGM-ATTORNEY.
10 PJATY-ATTORNEY-KEY.
15 PJATY-JUDGMENT-ID PIC X(14).
15 PJATY-GROUPING-CDE PIC S9(4) USAGE COMP.
15 PJATY-ROLE-CDE PIC X(1).
88 PJATY-CREDITOR VALUE 'C'.
88 PJATY-DEBTOR VALUE 'D'.
88 PJATY-TRUSTEE VALUE 'T'.
15 PJATY-GROUP-SEQ PIC S9(4) USAGE COMP.
15 PJATY-ENTRY-SEQ PIC S9(4) USAGE COMP.
10 PJATY-NAME-PREFIX PIC X(4).
10 PJATY-LAST-NME PIC X(25).
10 PJATY-FIRST-NME PIC X(12).
10 PJATY-MIDDLE-NME PIC X(12).
10 PJATY-NAME-SUFFIX PIC X(4).
10 PJATY-CITY-NME PIC X(25).
10 PJATY-STATE PIC X(2).
10 PJATY-ZIP-CDE PIC X(9).
10 PJATY-TELEPHONE PIC X(10).
10 PJATY-LST-MNT-DTE PIC S9(9) USAGE COMP.
10 PJATY-REC-LOCK-CDE PIC X(1).
10 PJATY-ALT-NAME.
49 PJATY-ALT-NAME-LEN PIC S9(4) USAGE COMP.
49 PJATY-ALT-NAME-TEXT PIC X(75).
10 PJATY-ADDR-LINE-1.
49 PJATY-ADDR-LINE-1-LEN PIC S9(4) USAGE COMP.
49 PJATY-ADDR-LINE-1-TEXT PIC X(50).
10 PJATY-ADDR-LINE-2.
49 PJATY-ADDR-LINE-2-LEN PIC S9(4) USAGE COMP.
49 PJATY-ADDR-LINE-2-TEXT PIC X(50).
10 PJATY-ADDR-LINE-3.
49 PJATY-ADDR-LINE-3-LEN PIC S9(4) USAGE COMP.
49 PJATY-ADDR-LINE-3-TEXT PIC X(50).
************************************************** ****************
* THE NUMBER OF COLUMNS DESCRIBED BY THIS DECLARATION IS 20 *
************************************************** ****************

View 6 Replies View Related

Truncate Value (of Datatype Dt_ntext) Being Imported

May 14, 2008



Hi All,
I am importing data from an oracle db and one of the columns is a nclob. I would like to truncate the value if it is more than a certain length. I want to use a derived column transformation. I cannot use the len and substring functions because it is not a string. I could convert it to a unicode string and use those functions, but I am afraid there is a size limitation (4000 characters) on it. Is there smth I am missing? Can anybody please suggest any ideas?
Thanks a lot.

View 2 Replies View Related

Removing Formatting From Imported File

Jul 17, 2007

I have a file I'm pulling from another type of database into an Excel spreadsheet and then using my dtsx package to import the spreadsheet into my SQL database. The problem I'm having is that one of the fields coming out of the database to the spreadsheet has the thousands seperator in the field that I want to use as a numeric field without the ",". Right now I have a macro that I run on the spreadsheet to reset the field to straight numbers without commas before importing it, but would like to configure my Integration package to do it automatically.

Any ideas would be appreciated.

Thanks in Advance

View 1 Replies View Related

How Do I Edit An Imported DTS Package In SSIS???

Mar 31, 2006

I have used the wizard to import a DTS package from a SQL 2000 server to our new SQL 2005 server and need to make edits to reference the new server and database. I am able to see the package within the SQL Management studio under Integration Services, but I cannot find it in the Development studio?

What am I missing?

Thanks

View 1 Replies View Related

Lost Account Passwords When I Imported A Database

Feb 9, 2006

I used a DTS package to import data from one database to a new database (different servers) and it seemed to work fine with the exception that it lost all the passwords. I got one error telling me that for security reasons, it left all passwords NULL. Sure enough - they are now all blank.

Ideas - any good articles with quick fixes ???

Thanks a bunch - I am just getting into a lot of unusual problems this week.
Nancy

By the way - what happened to the SQL*Pass message boards ??? Nobody visits there now....

View 2 Replies View Related

Counting # Of Imported Rows For Each Import Process

Nov 25, 1998

hi, I am importing data daily to many tables, I want to keep track of the #of rows for each import process. I already have created a trigger as follow:
CREATE TRIGGER tr_bcp_log ON dbo.A
FOR INSERT
AS

declare @name varchar(30),
@row_count int

select @name=name , @row_count= @@rowcount
from inserted

insert into bcp_tracks (name,row_count)
values(@name,@row_count)
GO

The problem is that I am getting a row for each inserted row in table A.for instance if I have 500 rows in table A, I will get 500 rows in the log table like this
table_name,#of rows
A 1
A 1
A 1
etc up to 500 rows for table A

This is not what I want, I want to capture the num of rows for every bcp process , so in the log table I want to see the following :
table_name, #of rows
A 500
B 600
C 450
A 250
etc

Any help ?

thanks

Ali

View 1 Replies View Related

Count Rows Imported By Bulk Insert

Jul 13, 2006

I have a stored procedure which will run automatically. I've got try...catch code in the procedure, but I found a bug with the code where if there are any import errors, it doesn't recognize that that there was an error and it runs through the try code as through there was no problems. (I reported the bug).
I added some code using @@rowcount to check if there were rows imported, and if not, it moves the data file to a error folder so I know there was a problem with the import. But this only checks if at least one row was imported, not if all the rows in the datafile have been imported. (i.e. if the first row imported correctly, and the second did not, it still sees it as successful).
The problem is some of the data files have only one row to import and some have multiple rows. Is there a way to count the number of rows in the datafile, then count the number of rows imported, to verify they are the same number imported?
Thanks,
Laura

View 2 Replies View Related

Import Files Based On Whether They Have Already Been Imported Or If They Have Changed

Feb 9, 2008

Hi there,

Today I tried out Integration Services and after a couple of hours of confusion I am impressed by the power of this product. I was wondering if I might get some help on the 'best practice' for the following requirements:


I have a foreach container that scans a directory and calls a data flow task for each file in the directory. The files import to the database fine, but I want to modify the procedure so it only imports files that have not yet been imported. There are a couple of scenarios:

- a file is created in the directory
- a file is modified in the directory

In both cases I want to insert (or reinsert) the file. How can I modify my package to accomodate this behaviour? Storing the filename is an option, but I am not sure how to also bring in the file creation/modified dates.

Is this the right approach?

Any other ideas?

Cheers,
Alex

View 6 Replies View Related

Count Rows Imported By Bulk Insert

Jul 13, 2006


I have a stored procedure which will run automatically. I've got try...catch code in the procedure, but I found a bug with the code where if there are any import errors, it doesn't recognize that that there was an error and it runs through the try code as through there was no problems. (I reported the bug).
I added some code using @@rowcount to check if there were rows imported, and if not, it moves the data file to a error folder so I know there was a problem with the import. But this only checks if at least one row was imported, not if all the rows in the datafile have been imported. (i.e. if the first row imported correctly, and the second did not, it still sees it as successful).
The problem is some of the data files have only one row to import and some have multiple rows. Is there a way to count the number of rows in the datafile, then count the number of rows imported, to verify they are the same number imported?
Thanks,
Laura

View 6 Replies View Related

Conversion Problem - Data Imported From Access

Dec 7, 2007



Hi,

I have imported some tables from msaccess but as the datetime field from access is different from SQL Server I had to change all columns type from datetime to varchar...

Now in SQL Server i'm trying to convert this data into datetime, and I'm using cast(field as datetime) and sql give me this message..."The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."

how can I select these rows that are giving me errors ??? OR is there a way to convert this data ??

I don't know if in this data it will give the error... but as the table is too big...I can't post everything here...

------------------------------- EDIT

I got the problem...

I have data like 4/11/2006 9:23:19 AM and others like 11/21/2005 6:02:13 PM

So the first one 4/11/2006 9:23:19 AM it converts without problem, but wrongly...cause the month is "4" and not "11"
the other one 11/21/2005 6:02:13 PM it tries to convert the month as 21 and not as 11....

How can I solve this ??

View 1 Replies View Related

Iliminating Characters From Set Of Integers And Characters

Jul 19, 2006

Good day experts,

I wonder if i got an answer for this.
How can i iliminate a letters from a set of integers and characters using a SQL Statement

for ex:

ABC9800468F

is that possible?
is there a function that i can use to iliminate them?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved