question

Pinkett avatar image
Pinkett asked

Assistance with SSIS

I need to setup an ssis package that does the following: 1.there is an sp with cross server joins, this sp inserts all the resultsets into two temp tables. I have then inserted from the two main temp tables into perm tables (Execute SQL task) 2.Then i join the two temp tables together in a view to query the date for one resultsets 3.Then i need to import the resultsets into an excel spreadsheet. 4.The spreadsheet filename must be created dynamically everytime the package is executed ie: ServerCentral 2012-06-22.xls, the date part being the dynamic part of the name. The rest is constant. Please assist. I've set up the package with: Execute SQL task for the sp Exec SQL task for the view to join the two tables for one resultset Data Flow task( OLEDB Source), (Data Conversion), (Excel Destination) E-mail task (needs to attach the spreadsheet and e-mail) daily Also setup a variable for the spreadsheet (XLFileRootDir)
ssisexcel
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

How far have you got yourself? Is there a particular area you require help with?
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.