This is a discussion on SQL Server Integration Services within the Microsoft SQL Server forums, part of the Databases category; hi i m not sure where is actual place to post question abt SQL Server Integration Services(SSIS Package)?.so far i ...
| |||||||
|
#1
| ||||
| ||||
| hi i m not sure where is actual place to post question abt SQL Server Integration Services(SSIS Package)?.so far i have created SSIS Package in 2005 is working.basically what my package do is execute procedure and send email to user with all records as attachment.but for all this stuff i m using desinger only. but what i m looking for is do all this stuff(making connection,executing procedure,checking & creating folder ,saving all returns data from procedure into csv file,and atlast sending email with attachment.) programmtically. any body has an idea about SSIS Package? Hope it make some sense.
__________________ Love is physical attraction and mental destruction |
|
#2
| |||
| |||
| Hi, How about making an standard report with the same using SSRS and get that executed on daily basis or as per your needs and attach the report in email to the users. This will save a lot of efforts from you and would also give the good data presentation for the user. Just a thought. ![]() Regards, ~Harish |
![]() |
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cant see tables in SQL Server 2008 | micky | Microsoft SQL Server | 6 | March 3rd, 2009 04:07 AM |
| [Error] Cannot find server error | richyrich | .Net Development | 6 | November 25th, 2008 01:28 PM |
| SQL Server 2008 | stephenhy88 | Microsoft SQL Server | 7 | August 13th, 2008 01:55 AM |
| SQL Server Views | theChris | Microsoft SQL Server | 3 | March 23rd, 2008 07:35 PM |