Setando parametros em consulta com SSIS
30/01/2014
0
select login.data ,login.pin ,login.login ,logout.logout from ( select CONVERT(date,UTCOPERATIONDATE) as data ,Agent as pin ,MIN(UTCOPERATIONDATE) as login from baseb.Mig_Claro_OneContactReporting.dbo.ReportAgentState WHERE CONVERT(date,UTCOPERATIONDATE) between convert(date,getdate()-1) and cast(convert(date,getdate()-1) as varchar(10)) + '' 23:59:59'' and [TYPE] = 1001 GROUP BY CONVERT(date,UTCOPERATIONDATE) ,Agent ) as login left join( select CONVERT(date,UTCOPERATIONDATE) as data ,Agent as pin ,MAX(UTCOPERATIONDATE) as logout from baseb.Mig_Claro_OneContactReporting.dbo.ReportAgentState WHERE CONVERT(date,UTCOPERATIONDATE) between convert(date,getdate()-1) and cast(convert(date,getdate()-1) as varchar(10)) + '' 23:59:59'' GROUP BY[img:descricao=tela onde apresenta o erro ao setar parametros]http://arquivo.devmedia.com.br/forum/imagem/340939-20140130-190939.png[/img][img]http://arquivo.devmedia.com.br/forum/imagem/340939-20140130-190949.png[/img] CONVERT(date,UTCOPERATIONDATE) ,Agent ) as logout on login.pin = logout.pin and login.data = logout.data where ISNUMERIC(login.pin) = 1
Claudio Lopes
Posts
30/01/2014
Claudio Lopes
30/01/2014
Claudio Lopes
31/01/2014
Fabiano Carvalho
http://social.msdn.microsoft.com/Forums/sqlserver/pt-BR/4dda9f22-2d66-444a-88f3-ea9bcd3b5d5c/utilizando-variavel-no-execute-sql-task?forum=analysisservicespt
31/01/2014
Isaac Jose
se possível poste o print do pacote em si..
att isaac
31/01/2014
Claudio Lopes
Clique aqui para fazer login e interagir na Comunidade :)