March 10, 2010 at 11:04 am
I tried to run this query in SQL Server 2005 via SSIS but I keep getting the errors below:
select
'"'+ convert(varchar(10), recno) + '",' +
'"'+ convert(varchar(10), origrecno) + '",' +
'"'+appno+'",'+
'"'+product+'",'+
'"'+channel+'",'+
'"'+agent+'",'+
'"'+sltlid+'",'+
'"'+adjudicatr+'",'+
'"'+ convert(varchar(5), tdsr) +'",'+
'"'+ convert(varchar(3), beacon) +'",'+
'"'+ convert(varchar(3), appscore) +'",'+
'"'+ convert(varchar(3), bni) +'",'+
'"'+reason+'",'+
'"'+safescan+'",'+
'"'+safescanid+'",'+
'"'+reject+'",'+
'"'+decision+'",'+
'"'+action1+'",'+
'"'+action2+'",'+
'"'+outbound+'",'+
'"'+payout+'",'+
'"'+ convert(varchar(10), amtcred) +'",'+
'"'+existcust+'",'+
'"'+error1+'",'+
'"'+error2+'",'+
'"'+error3+'",'+
'"'+ convert(varchar(10), date, 101) +'",'+
'"'+time+'",'+
'"'+void+'",'+
'"'+ip+'",'+
'"'+cif+'",'+
'"'+qofi+'",'+
'"'+ convert(varchar(255), comments) +'",'
from abcd..employee;
Setting Source Connection (Error)
Messages
Error 0xc0207016: Source - Query [1]: There is a data source column with no name. Each data source column must have a name.
(SQL Server Import and Export Wizard)
Exception from HRESULT: 0xC0207016 (Microsoft.SqlServer.DTSPipelineWrap)
Thanks very much for your help.
March 10, 2010 at 4:20 pm
Thanks Guys, I resolved the issue. I just added a column to the query and boom it worked!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply