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/