Concluído

SSIS Package

Create a SSIS Package for Sql server 2008 that allows us to export data from a specific table to excel format, and then email that excel document to a contact person.

Use the following SQL as a dummy:

SELECT * FROM Products WHERE Date BETWEEN [FirstOfMonth] and [LastOfMonth]

This SSIS package should run the first day of every month and select data from the previous month. The SSIS Package should dynamicly enter the [FirstOfMonth] and [LastOfMonth] values as this should be allowed to run automaticly without us entering the start and end-dates.

So if this was to run juli 1, the SQL would look like:

SELECT * FROM Products WHERE Date BETWEEN '2009-06-01' and '2009-06-30'

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, SQL

Veja mais: SSIS SQL, Sql ssis, sql server ssis, package, sql server 2008 export excel, ssis email, sql run package, export sql table excel, sql server 2008 ssis, look table excel, export data email, export sql excel php, sql server export sql, sql server document management, sql dummy, project management excel format, export data excel sql, excel format project management, ssis package, excel sql server 2008

Acerca do Empregador:
( 38 comentários ) Denmark

ID do Projeto: #2816464

Concedido a:

dotnetsqlCoder

See private message.

$85 USD em 1 dia
(88 Comentários)
5.5

8 freelancers estão ofertando em média $63 para esse trabalho

canlevw

See private message.

$85 USD em 1 dia
(55 Comentários)
6.8
Robotapps

See private message.

$72.25 USD em 1 dia
(93 Comentários)
5.4
vw7258315vw

See private message.

$25.5 USD em 1 dia
(48 Comentários)
4.7
rvstech

See private message.

$68 USD em 1 dia
(44 Comentários)
4.7
payalagrawal

See private message.

$42.5 USD em 1 dia
(14 Comentários)
5.2
angan

See private message.

$85 USD em 1 dia
(28 Comentários)
4.5
SharkByte2008

See private message.

$42.5 USD em 1 dia
(8 Comentários)
2.6