A carbocation (/ËkÉËrboÊËkÃ¦taÉªÉn/) is an ion with a positively charged carbon atom.
You can run your package using DTEXEC, and change your connection by passing in a /CONNECTION parameter. Probably save it as a batch so next time you don't need to type the whole thing and just change the datasource as required. You can use the SSIS XML package configuration file. Here is a walk through.
SELECT. 1  ANSI standard for variable assignment. 2  Non-ANSI standard when assigning variables. 3  Can only assign one variable at a time.  Can assign values to more than one variable at a 1  time. When assigning from a query and the query returns no result, SET will assign a NULL value to the variable. DECLARE @CustomerID NCHAR(5) SET @CustomerID = 'XYZ' SET @CustomerID = (SELECT [CustomerID] FROM [dbo].[Customers] WHERE [CustomerID] = 'ABC') SELECT @CustomerID -â Returns NULL.