SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• String_agg not working as needed

  I'm trying to get this string_agg to put all the 'comments' into one result field like instead of: …

  DaveBriCam

  10 replies

  14 hours, 18 minutes ago

  By: pietlinden

• advice as i migrate my winscp based ssis pkg to our prod server

  Hi , i installed winscp on my pc, added it to GAC thru vs (i think a developer script) on my pc as …

  stan

  5 replies

  15 hours, 53 minutes ago

  By: stan

• query to track time spent on individual tasks in SSIS

  Hi everyone I am looking at building a query to determine how much time is being spent on each task…

  water490

  5 replies

  1 weeks, 3 days ago

  By: water490

• how to write this query?

  Hi everyone I asked this earlier but the desired outcome is a bit different this time so I am start…

  water490

  2 replies

  2 weeks ago

  By: pietlinden

• would it be so terrible to install ssms on a few user desktops?

  Hi, ssms is free here.   I can think of other reasons to do this but i would like to install ssms o…

  stan

  4 replies

  2 weeks, 5 days ago

  By: Jo Pattyn

• hops from sql server to mysql to s4 hana - possible?

  Hi when i think of server hops , i think of how kerberos assists with credentials from server to se…

  stan

  9 replies

  3 weeks ago

  By: msm_coretech

• how to write this query?

  hi everyone I am not sure how to write the query that will produce the expected results.  Basically…

  water490

  2 replies

  3 weeks, 5 days ago

  By: Phil Parkin

• how do i map the "current" object entry in for each to one variable

  hi, in an ssis  for each loop over an object variable called MyListVariable, i am trying to map the…

  stan

  5 replies

  1 months ago

  By: stan

• Which 'Where' statement conditional upon a variable

  Thanks in advance for any clues on this. I am trying to write a 'conditional where' statement in a …

  DaveBriCam

  3 replies

  1 months, 1 weeks ago

  By: ScottPletcher

• CAST datetimeoffset(7) as a datetime in UK format

  I have a view where I am casting a datetimeoffset(7) field to smalldatetime or datetime as my repor…

  tylerschuler75

  8 replies

  1 months, 2 weeks ago

  By: frederico_fonseca

• data type gets lost in data flow

  Hi, in a simple oledb source->derived column->oledb destination    data flow, 2 of my date co…

  stan

  12 replies

  3 months, 1 weeks ago

  By: stan

• any reason to avoid asking ssis to extract files from ftp

  hi we have to replace talend which generally was used to move files. talend's replacement except fo…

  stan

  8 replies

  3 months, 2 weeks ago

  By: stan

• is there a no code way to limit an ssis extract from excel to the 1st 21 rows?

  is there a no code way to limit an ssis extract from excel to the 1st 21 rows of the sheet?   for n…

  stan

  2 replies

  3 months, 2 weeks ago

  By: Phil Parkin

• what are the downsides of TDE not running vs running?

  hi for the 2 years i've been here I believe we've had "encryption" turned off in what i only know a…

  stan

  4 replies

  3 months, 3 weeks ago

  By: jasona.work

• Need to overload tempdb

  Yes, you read that title correctly. I have a somewhat hilarious problem. We have some queries that …

  Brandie Tarvin

  9 replies

  3 months, 3 weeks ago

  By: Robert Sterbal