SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• dont want pkg to abort if someone is in excel source document

  Hi, is there a way when using excel as a flat file source in ssis to forgive the fact that someone …

  stan

  3 replies

  9 months, 1 week ago

  By: stan

• need help with assigning a value to a variable

  Hi I am trying to assign the value of the  variable using the output of a query but I am getting an…

  water490

  6 replies

  9 months, 1 week ago

  By: Jeffrey Williams

• does netsuite really hide columns from customers?

  Hi we built a gateway from sql server to netsuite using an oracle competitor's odbc driver. once it…

  stan

  5 replies

  9 months, 1 week ago

  By: stan

• how to calculate an average only if a minimum number of records exist?

  Hi I am working on a rolling average calculation that is not working quite right.  Here is the code…

  water490

  3 replies

  9 months, 2 weeks ago

  By: water490

• adding dtc to my pkg

  Hi below i show the control flow of my pkg.   I'd like to enlist any component that updates into dt…

  stan

  1 replies

  9 months, 2 weeks ago

  By: stan

• String Variable and sp_executesql

  I am not understanding why this command completes "successfully" and it seems correct to me. Howeve…

  stevec883

  4 replies

  9 months, 2 weeks ago

  By: stevec883

• New SSIS Package fails in Sql Agent when it includes a script component

  I'm creating a new SSIS package using VS2022 to target Sql Server 2019 server. I have ended up with…

  Grant McAllister

  9 replies

  9 months, 2 weeks ago

  By: Grant McAllister

• How to speed up this query?

  Hi everyone I have a query that is taking a real long time.  It takes close to 30 minutes to proces…

  water490

  6 replies

  9 months, 3 weeks ago

  By: Ken McKelvey

• Restore Procedure not working

  I created a small procedure that reads the backup file and restores the DB daily. But when I execut…

  Chitown

  7 replies

  9 months, 3 weeks ago

  By: Chitown

• Aggregate Data to New Table

  Hi , I am using webedition of 2019 MSSQL on AWS. I don't have SSAS or other license . I have a big …

  thbaig

  4 replies

  9 months, 3 weeks ago

  By: Phil Parkin

• funny character shows in one hdg name in ssis flat file connector

  hi, i spent some time today in an existing pkg replumbing 5 flat file connectors to new tsv files. …

  stan

  6 replies

  9 months, 3 weeks ago

  By: frederico_fonseca

• how to generalize the LAG function so it keeps looking until a value is found?

  Hi everyone There are situations where a value for a particular day is NULL so I use the previous d…

  water490

  3 replies

  9 months, 3 weeks ago

  By: water490

• Need a list of stored procedures that execute multiple stored procedures

  Hello SSC! I hope you all had a happy and safe holiday! Apologies if this post is confusing... I ha…

  Lord Slaagh

  5 replies

  10 months, 1 week ago

  By: Lord Slaagh

• What is the best index strategy for a table that gets truncated?

  Hi everyone My SSIS package does a bulk insert of csv files into a table called tableA.  The nature…

  water490

  6 replies

  10 months, 2 weeks ago

  By: ScottPletcher

• how can i tell if our db2 driver is ms or ibm or other?

  i see this in the definition of a linked server on our wh sql server that i know is db2 based... @p…

  stan

  1 replies

  10 months, 3 weeks ago

  By: stan