Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Flat file src error-"The value could not be converted beca..

 
   Database Forums (Home) -> DTS RSS
Next:  Using Flattened table COSTLIER than using JOINS w..  
Author Message
Arjun

External


Since: Dec 05, 2006
Posts: 1



(Msg. 1) Posted: Mon Aug 06, 2007 9:22 pm
Post subject: Flat file src error-"The value could not be converted because of a
Archived from groups: microsoft>public>sqlserver>dts (more info?)

Hello,

I have a flat file source with ragged right format. It has three columns.



My package fails when the last column has null values.

It says "The value could not be converted because of a potential loss of
data".



I tried lot changing row delimiter and column delimiter but to no avail.



So any idea on this?



Thanks in advance.

 >> Stay informed about: Flat file src error-""The value could not be converted beca.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Flat file connection error - I have a SSIS package the makes a flat file connection to a file on our network which has the same name and location everyday. I can connect to when the package is executed from BIDS but fails with the following error when executed as scheduled job ..

Flat File import - Hello, I need to import data from a flat file into a sql server 2000 database. The Fate file has no delimiters. I have the specs for this file so I do knowthe layout of this file. Can somebody point me in the rigvht direction to accomplish this. ..

Flat File - Different row types - still confused - I'm trying to process header/detail lines in a flat file, something I've seen a few examples of, but still have some questions. I've seen Allan Mitchell's comments and an example on sqlis.com (thanks for the fine examples!), and tried an example from...

SSIS - Flat File Location - I have a SSIS package that imports data from a flat file into a table. The file is in a network share. The package itself is in my local machine. The sql server itself is running on my local machine. This will be changed later to a server. The packag...

Flat file text delimiter - I am using SQL2005 management studio to export the data from a table to a flat file. If I include a text delimiter it adds it to every column, i have checked the columns with the edit transforms button and some of them are ints. Is there a setting..
   Database Forums (Home) -> DTS All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]