SSDT

• Topics

  Started by

  Posts

  Last post

• Deployment Failure

  Hi all, I'm wondering if someone may be able to point me in the right direction here as after looki…

  NicHopper

  4 replies

  4 years ago

  By: NicHopper

• Use a variable for a file connection manager

  How do I tell a file connection manager that the file in question is not a static name and will cha…

  Jay@Work

  7 replies

  4 years ago

  By: thomaskin

• Build SQL Server Data Project on Ubuntu

  Hi everyone, we are currently designing CI/CD Pipelines and the build server we have available at t…

  Paul Hernández

  3 replies

  4 years, 2 months ago

  By: Paul Hernández

• CDC Source tool in SSIS - varchar data mapping issue

  I'm trying to introduce myself to the change data capture items in the SSIS Toolbox and have hit a …

  James

  3 replies

  4 years, 2 months ago

  By: James

• Azure Blob Upload Task error

  Hi, I am trying to understand an SSIS package where a previous employee who left has written . The …

  spboutput

  2 replies

  4 years, 3 months ago

  By: spboutput

• Need Simple SSIS Tutorial To Pass a Database Connection String to dtexec.exe

  I've purchased a couple of books, worked through a number of SSIS tutorials, googled a bunch, and s…

  shew

  11 replies

  4 years, 5 months ago

  By: shew

• Execute process task SSIS (Powershell Script)

  Hi Guys, I need urgent help. I have a Powershell script that I am executing through "Execute Proces…

  mikesql710

  1 replies

  4 years, 6 months ago

  By: Jeffrey Williams

• SSIS performance issue: Data load from sqlserver2016 (EC2) - Mysql8.0 (RDS)

  Hi, I am trying to Full Load  from Table on sqlserver(2016) to a table on Aurora My Sql database (R…

  sri2016

  2 replies

  4 years, 6 months ago

  By: Jeffrey Williams

• SSDT database project multiple references to another project

  Hi, I'm experimenting a bit with SSDT database projects, and I've hit an issue that I have some sol…

  chris.johnson.0120

  4 replies

  4 years, 7 months ago

  By: Phil Parkin

• how to pass datetime variable from Execute SQL task to the execute process task

  i have created two datetime variables in execute sql task and wanted to pass those variable to exec…

  seshagirikudaravalli 20366

  2 replies

  4 years, 9 months ago

  By: Phil Parkin

• How to dynamically create a table in SQL from a Excel file using SSDT

  Hi, I am fairly new to SSDT and am looking for some help with loading excel files that I have been …

  Nelson B

  9 replies

  4 years, 9 months ago

  By: Nelson B

• SSIS dtexec Error - The 'OraOLEDB.Oracle.1' provider is not registered.

  Hi I am have one SSIS package that connects to Oracle and pulls the data. I am trying to execute th…

  sarang1183

  23 replies

  4 years, 9 months ago

  By: sarang1183

• redirect row on truncation

  I kind of have this working, but for my test row, it did not output to the file.  It is at least cr…

  Sailor

  4 replies

  4 years, 9 months ago

  By: Sailor

• Expression help

  Hi, I am using this expression in precedence constrain. If it is true, then go to the next step. SU…

  mikesql710

  1 replies

  4 years, 10 months ago

  By: Phil Parkin

• SSIS Expression help

  Hi Guys,/ Is anyone can help me convert this SQL to SSIS Expression? SELECT DATEADD(DAY,DATEDIFF(DA…

  rocky_498

  5 replies

  4 years, 10 months ago

  By: rocky_498