I did this "And what I usually do is change the SELECT <column list> to a SELECT * or SELECT COUNT(*). The reason I do this is so that I...

The SSIS package is simple. I am getting the data loaded from SAP using XTRACT IS add on in SSIS.

I do create the table first in MariaDB as seen in the screenshot above.

Yes, I connect to tables.

• This reply was modified 1 year, 7 months ago by  yrstruly.

I created a simple pipeline in SSIS, moving data from a source like SQL Server or a flat-file. I am having trouble when I am connecting to the destination table...

Even when i create the table first in Mysql/MariaDB it gives the error:

-- Create the sample database
CREATE DATABASE testdb;

-- Switch to the test database
USE testdb;

-- Create the...

Thank you. The column names were also a problem. I corrected it.

SELECT 
  p.name AS [Plan],
  COUNT(s.ID) AS [Count],
  SUM(t.amount) AS [Amount ($)]
FROM 
...

Thank you for the assistance. Here follows the DDL n DML

-- Create Transactions Table
CREATE TABLE [dbo].[Transactions](
[id] [int] IDENTITY(1,1) NOT NULL,
[transaction_date] [datetime] NOT NULL,
[primary_account_id] [int] NOT NULL,
[group_id] [int]...

I believe the transactions table must be used instead of accounts.

If your intention is not to help me, keep your negative comments and let those who want to help me, assist.

Dont, understand why the "trolls" on here want to chip...

USE [Kazang]
GO

/****** Object:  StoredProcedure [dbo].[AppendPrimaryAccountGroupTracking]    Script Date: 2023/04/18 18:16:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


-- Create the stored procedure
CREATE PROCEDURE [dbo].[AppendPrimaryAccountGroupTracking]
   ...

data http://:https://drive.google.com/file/d/1_8JWxOrAdKEz1dxKITnqW3HZr1GTBgB9/view

This code:

USE [Kazang]
GO

DECLARE@return_value int

EXEC@return_value = [dbo].[AppendPrimaryAccountGroupTracking] 
@TransactionDate = '2023-01-01'

SELECT'Return Value' = @return_value

GO

gives me an output of:

I have created:

USE [Kazang]
GO

-- Create the dimensional table for group tracking
CREATE TABLE [dbo].[PrimaryAccountGroupTracking](
[id] [int] IDENTITY(1,1) PRIMARY KEY,
[primary_account_id] [int] NOT NULL,
[group_id] [int] NOT NULL,
[start_date] [date] NOT NULL,
[end_date] [date]...

What does this insert script look like?