January 15, 2010 at 7:00 am
Hi,
The problem was long enough to take my whole day. To make story short-- i have SQL to Ms aceess migration. It failed in some cases where we have data in file_url column
Query which is being used manipulate the data
declare @customdns nvarchar(80)
select @customdns =
case(left(@@servername,7))
when 'D2DBA03' then 'https://d2web01/custom/'
when 'T2DBA03' then 'https://alphacustom.a1.cvent.com/'
when 'T2DBA02' then 'https://custom.t2.OKS.com/'
when 'S2DBA02' then 'https://custom.t2.OKS.com/'
when 'S2DBA04' then 'https://custom.s2.OKS.com/'
when 'P2DBA02' then 'https://custom.OKS.com/'
else ''
end
SELECT
respondent_id = di.respondent_id,
survey_id = di.survey_id,
qstn_id = di.qstn_id,
original_file_name = di.friendly_file_name,
file_url = @customdns + replace(cast(acct_stub as nvarchar(36)), '-', '') + '/files/Survey/' + replace(cast(di.survey_stub as nvarchar(36)), '-', '') + '/' + physical_file_name
FROM [dbo].[DMP_SURVEY_RESPONDENT] di (NOLOCK)
Data from above query’s column ( 3 records)
1)
2)
3)
But now the problem is I added a data conversation in my dataflow which is converting string [DT_str] 50 into database timestamp, which is my sql table destination datatype. Following is the error i get when i run the task--
ERROR:--
Error : there was an error with inout column “file_url” (8893) on input “ OLEDB destination input “ (8802) .the column status was returned
"The value could not be converted because of a potential loss of data.".
The input “ OLEDB destination input “ (8802) failed because error code 0xC0209077 occurred, and the error row disposition on input “ OLEDB destination input “ (8802) specified the failure
But inspite of the data get migrated but obstruct a follow up process( in which we transfer that file to a shared location)
can someone help me?
thanks
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 15, 2010 at 7:16 am
Other than "can someone help me", there is no question in your post, it's just a statement about what you're doing.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy