Will this affect any foreign keys in other tables that map to your enrollment table, when essentially changing the id field datatype from a unique identifier to a int ?

Just to add in case anyone is interested, You If you really wanted to have the value come through with the parenthesis to your text file , you can convert...

Even once you get past this issue, can't there be another issue with the way data is created in 2008 version versus 2017? Or does some automatic conversion occur when...

AS I dont have version 2017, will it remove two leading or trailing commas instead of one as you showed in your example. Would it Remove two leading 'patriots' in...

Happy Easter. Don't overlook that you also get the access to push this into the package store and create a job, have the job run with an appropriate proxy account...

'a' is the column name here and the dashes is the separator between the column name and values returned for this confused me at first glance.

Can you remote login into the machine you want to deploy to , and run the manifest there? If you dont have the permissions to deploy the package to the...

select * from sys.dm_exec_sessions

There is a row count column in there. I think you need active connection at the time of running this, even though a process may...


select case when NOT( 1 = null ) then 1 else 0 end
select case when ( 1 = null ) then 1 else 0 end


You are referencing columns  in your query that are not in your initial table definition. I dont know even what your business requirement is. Have a look at the link...

One thing I would add ... It seems that for now the data is only being supplied to an Excel workbook , to which then calculations are done. In the...