SSIS Tutorials

truncate table ee;
DBCC CHECKIDENT('ee',reseed,100);


File System task use to create rename folder


FTP Task
Send Or Receive files on Remote Servers
delete local or remote files
create local or remote directories
delete local or remote directories
right click connection manager section ---> new connection --> set properties
Add Ftp task on control flow window --- double click---select ftpConnection
go to second tab fileTransfer---where u set remote path

Send Mail Task:-
go to connection manager section right click ---> select New Connection --- > then select SMTP
set SMTP server name = localhost
now drag send email tak on control flow window -->double click
under mail tab select smtpConnection --- and set other properties
Precedence Constraint

Derived Column
Upper([FirstName]+ ""+[LastName])

DataViewer
right click Prcedence select Data view select Grid OK..

Flate File Source--- take data on file and insert into destination

Union All --- Union two flat to one

Sort ----- sorting column

Audit ---- contain information of the package

SMTP server response: 550 5.7.1 Unable to relay or cannot pick up iis directory

1) Go to: start > settings > control panel > Administrative Tools > Internet Information Services
2) Expand the " (local computer)" node
3) Right click on your SMTP server > go to "Properties"
4) Click "Access" tab
5) Under Relay Restrictions, click the "Relay" button
6) Click "Add"
7) Select "Single Computer" and enter IP address 127.0.0.1
8) Hit OK, OK, OK (until the properties dialog is closed)

and also web.config set smtp server = '127.0.0.1'

mobile application connect

http://www.youtube.com/watch?v=j9XlVUif2G8&NR=1

how to Remove log file on database

http://4rapiddev.com/sql-server/delete-shrink-eliminate-transaction-log-ldf-file/

how to pass particular column rows rows vise values to a procedure like EventId

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                 ds = obj.GetPartEventReportnew(Convert.ToInt32(dlstEventUsercount.Tables[0].Rows[i]["Event_Id"]), attendeeId, fromdate, todate);
            }

how to remove dropdownlist all rcods through java script

 document.getElementById("ctl00$ContentPlaceHolder1$G_drpGD_Type").length = 0;

Date Filtering on Store Procedure

Create procedure [dbo].[PMP_GetPartEventReportnew]  
@Event_Id int, 
@Attendee_Id int,
@Fromdate datetime,
@Todate datetime
AS               
Begin 
select distinct e.Event_Id,ex.Amount,s.State_initials,sim.SpendItem_Name 
from PMP_EventInformation e 
JOIN PMP_StateMaster s ON e.Event_State_Id = s.State_Id 
JOIN PMP_Expenses ex ON e.Event_Id = ex.Eventid 
JOIN PMP_AttendeeInformation ea ON ex.Attendeeid = ea.Attendee_Id 
JOIN PMP_SpendItemMaster sim ON ex.SpendItemid = sim.SpendItem_id  
where e.Event_Id = @Event_Id and ex.Attendeeid = @Attendee_Id  
and CONVERT(VARCHAR(50),ex.Date_Submitted,121) between CONVERT(VARCHAR(50),@Fromdate,121) and CONVERT(VARCHAR(50),@Todate,121)
Order By e.Event_Id 
end