Select DATEADD(DD,-1,DATEADD(MM,DATEDIFF(MM,0,GETDATE())+1,0))

Check here for more detail.

Using configuration in SSIS package is quite simple, Recently i created a document on enviornement variable type configuration, I tried to make it as prominent as possible -

This article is...

I think it is possible, but we need to do some analysis on that -

Refer the link article, it may help you -

Create a linked server is quite simple. Follow the below steps-

Step 1 – Connect SQL server, using 'Database Engine' as server type along with proper Server name and authentication.

Step 2...

i am vipul and i use this method to truncate all table from database. but constraint was not enabling by

Exec sp_MSforeachtable 'alter table ? check constraint all'

print 'all constraint...