Create an Execute SQL Task and Pass the varaible values as Parameter for an Procedure.

In the Procedure do the sql code to reflect the Changes.

ohh... try the below one. It may help!

Go to Package Properties --> In Security Tab Choose Protection Level --> Then select the option "EncryptSensitiveWithUserKey" --> Save it and run the...

Can you check are you able to access the same database using your database engine server type?

its more like whatever commited transactions are there in backup they will be roll forward and incomplete tran like what Gail said will be rollbacked and will reflect in the...

Thanks Gail sharing all good info. 🙂

opps.. if i can able to take tail backup.

Thanks Ramji29. In this case, if some thing is in a transaction that transaction data will be rolled back rt? I don't know exactly. Please explain.

Great! Thanks Gail Shaw. You are saying tail-log backup which means that transaction log backup or else some other one?

Its varchar data type.

There are the spaces in the flat file itself. I need to remove the space while inserting into the table. Usually, the text files are generated...

Nice Article! It's good to learn for new DBA's like me. Thanks for sharing.

Elliott W (5/4/2010)

---

I'm not 100% sure but I think SSIS will only use assemblies that are installed in the GAC. I'm willing to bet that the DLL's you are...

Hi Dinesh,

Nice Article!!!

Is it possible to use cell name rather than B3,B4? Why i am asking is, because if the position of the cell has changed in future then...

Thanks abader. It help me to solve the problem.

Nice Article!!! Thanks for posting...

Good article Kathi!!! Thanks....

Let me get going on the book now. 🙂