Upgrade pacakges from SQL 2008 R2 to SQL 2014

Hello everyone, I've around 14 dtsx files, which needs to be upgraded from SQL server 2008 R2 to SQ…

LogShipping Dynamic Port Number

Hi, how to configure the logshipping dynamic port number. is there anyway to create manually on the…

CAST VARCHAR date to datetime at load

Hi im doing an OLE DB load from a table with time date field stored as a nvarchar , this is the fie…

SSIS "for loop" container EvalExpression confusion

Hi - This is the first time using this container and it is not behaving like I think it should. I'…

RESOURCE_SEMPAHORE wait type

Hi All, From the sys.dm_os_Wait_stats i see the below wait_type waiting_tasks_countwait_time_m…

LOGSHIPPING WANT TO SYNC WITH SECONDARY DATABASE

Hi, I want to configure the logshipping to secondary database. scenorio ===== Already the primary d…

Query to bring through today's values only

Hello I have a query where: WHERE a.jobdate >=GETDATE()-1 This brings though data from today and…

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Hello Experts, Many a times see the below error in SQL Error log. Login failed for user 'NT AUTHORI…

SSRS report times out within asp.net reportviewer on web form

I have an SSRS report that's called within an asp.net web form via the ReportViewer control. It's …

Maze Runner The Scorch Trials Full Movie Download

Maze Runner The Scorch Trials Full Movie Download Online https://www.facebook.com/MazeRunnerTheScor…

Renaming columns surrounded in double quotes

Never mind. Figured it out. How do I delete a post?

VMWare as a high(er) availability option

I've inherited several SQL Server instances, all in VMware. We're in the process of shoring up the …

Will Project Deployment redeploy all SSIS Packages within the project?

With SQL Server 2014 EE SP1, using Project Deployment and a SSIS Project with 20 packages. You chan…

Inserting into SQLite using Openquery - can't make it work if the SQLLite col is TEXT

Dear All, Having set up a linked server as a SQLite DB, I am able to select and sometimes insert to…

sql error