As Phil says, the packages are actually stored as a varbinary in the SSISDB database, rather than files.

When running anoter package, you'll need to ensure it's in the...

You might be right about that it references other packages. In your current 2008 packages, I assume that the location of the package is the full file path? In SSISDB...

I totally agree that SQL Server is not the right place for it. My main aim right now is 2 parts:

1. Can SQL Server really achieve this?

1. If so, is it...

It sounds like what you're after here is dynamic SQL. You can't pass variables as of a SQL statement, so you need to write our the SQL statement into it's...

Duplicate of topic, where discussion already taking place: https://www.sqlservercentral.com/Forums/1892957/Query-optimization-Select-Into-Alter-Table-ADD-CONSTRAINT-PRIMARY-KEY-ID-ASC

Also, your prior topic is in the SQL 2005 forum, and this in in the 2012 forum. If you...

Pretty sure this can't be achieved, but if anyone does have any ideas (or wants to point and laugh) would be greatly appreciated! https://www.sqlservercentral.com/Forums/1892967/Send-and-save-a-copy-of-an-email-as-msg

The first thing is you don't seem to quite understand CASE expressions. There is often little need to NEST them like you have done here. If you have a different...

SQL isn't run on the client side, so you can't "check" the timezone of the client in there. You'd need to check the client's date/timezone some other way and pass...

Your expected output can't be created. When using a Union, you need to return the same number of columns in every resultset. In yours, the first 2 have 6 columns,...