SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• setting an ssis param dynamicaly when the sql agent job runs

  hi i was hoping for a more elegant way of setting a pkg level param from the sql agent job that run…

  stan

  4 replies

  3 hours, 33 minutes ago

  By: stan

• Warning: Could not open global shared memory to communicate with performance DLL

  Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at Update Table, SSIS.P…

  water490

  1 replies

  2 weeks, 2 days ago

  By: frederico_fonseca

• that one limitation in replication

  Hi as shown below a replication target requires a primary key.  if we want to replicate from the db…

  stan

  3 replies

  2 weeks, 3 days ago

  By: deepeshdhake

• 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

  6 replies

  1 months, 1 weeks ago

  By: stan

• 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

  1 months, 1 weeks ago

  By: pietlinden

• 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 months, 3 weeks 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

  1 months, 3 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 months 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

  2 months ago

  By: stan

• 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

  2 months, 1 weeks 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

  2 months, 1 weeks 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

  2 months, 3 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

  3 months 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

  4 months, 3 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

  5 months ago

  By: stan