HI, i am learning Intergration services. I was go through all the tasks available in the SSIS. I was trying to use the Bulk insert task but i was getting an error. I have a TXT file as source and created a table in SQL server just following in the text book. can any one guide me on this atleast by giving me small example.
Also i had tried few Maintanance tasks as well as such Rebulid Index,Re-organise index and shrink database. it was successful when i executed but i want to see the database how much it had shrinked compare to earlier.Can any one tell where i have to see this.
Thanks in Advance