https://github.com/yorek/ssis-queries/blob/master/ssis-execution-package-history.sql

use  SQLCHECK utility ( https://github.com/microsoft/CSS_SQL_Networking_Tools/releases/download/1.0.1422.0/SQL_CHECK.zip )

ref :https://github.com/microsoft/CSS_SQL_Networking_Tools/wiki/SQLCHECK

Download SQL_CHECK.ZIP and extract SQLCHECK.EXE to a folder of your choice, e.g. C:\temp. output txt file will be in same...

as per Microsoft , SQLCHECK utility ( https://github.com/microsoft/CSS_SQL_Networking_Tools/releases/download/1.0.1422.0/SQL_CHECK.zip ) replaces Kerberos Configuration Manager from SQLServer 2022 +

ref : https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/using-kerberosmngr-sqlserver

Download SQL_CHECK.ZIP and extract SQLCHECK.EXE to a folder...

Thank you Amartha dutta

are you member of db_dtsadmin role for that instance ?

Please refer below link for further details

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/8b491f05-8af1-4e74-8cb3-972aea20cce5/

check below url

http://blogs.msdn.com/b/sql_protocols/archive/2008/05/20/connectivity-troubleshooting-in-sql-server-2008-with-the-connectivity-ring-buffer.aspx

Create a new database with same physical file (mdf ,ndf ) name (on same path) and logical name.:)

Stop the sql server services.;)

replace the mdf and ndf files :w00t:

Start the...

we have scheduled all the packages using SQLServer Agent job of type Operating System ( 64 bit DTEXEC )

Please let me know why it is taking long time compared to...

Thanks for the update Steve.

We used to get the installation date using following query in SQL Server 2000

Use Master

declare @root varchar(50)

exec XP_regread @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\Microsoft\MSSQLServer\setup', @value_name='SQLPath', @value = @root...

http://www.microsoft.com/sql/technologies/integration/conchango.mspx

master..xp_cmdshell 'pkzipc -add drivename\path\filename.zip' drivename\path\filetozip '

Provided pkzip is installed on the server.

replace iif with select case....

Hi Bimal,

The DTS Packages look for the associated dll 's in the local system so I believe the dll's associated with FTP components may be missing.To work around do register...

Thanks a lot Greg Charles

we know that the sqlserver service a/c should be exist in the sqlserver login to start the sqlserver successfully.if the service a/c is a domain user a/c then it will...