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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply