Thank you. The following is my script. In the last query I want only rows where the login name is Sam.Smith or Michael.Jackson.

CREATE TABLE #tmp (loginNameVARCHAR(50))

INSERT...

Yes, it was. I think I found the issue. When I export the package, it is defaulting the protection level to "EncryptSensitiveWithUserKey" and I need to change this...

I tried another approach to my deployment today. I connected to Integration Services from SSMS and then used the import package feature there to import the package. When...

you may want to check for the existence of all the file in one script and return true if they all exist. true will be a precedent constraint on...