Custom Handling Flat File Output of an SSIS Package with the Script Component
I recently had a requirement to remove the last Carriage Return <CR> and Line Feed <LF> characters when outputting a...
2017-04-02
3,710 reads
I recently had a requirement to remove the last Carriage Return <CR> and Line Feed <LF> characters when outputting a...
2017-04-02
3,710 reads
Typically, making the output of an SSIS Package available to a client application for further processing is achieved by outputting...
2014-11-11
4,831 reads
I’ve been actively seeking out opportunities to do more stuff with Powershell of late.
I had wanted to script out only...
2014-03-21
4,013 reads
In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.
I used the API that...
2014-03-09
4,588 reads
One of the nice things about SQL Server Integration Services (SSIS) is its extensibility.
If you find you have need for...
2013-08-25
27,972 reads
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers