Questions tagged [ssis]

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.

Filter by
Sorted by
Tagged with
1
vote
0answers
25 views

SSIS and multiple API calls, a better way?

I am looking for some guidance on my solution as I am convinced there must be a better way. The below is my setup... SSIS Package API 1 - This calculates invoice totals and payments API 2 - This takes ...
2
votes
0answers
5k views

Active Directory: Retrieve all group members using DirectoryServices

I have written a function that will retrieve all active directory group members via DirectoryServices. I am using ...
8
votes
2answers
217 views

Checking for Duplicates, Except

I have a query that returns records that have duplicate names within a given DBSTATUS. I used to do this with a direct connection to the remote oracle database ...
6
votes
2answers
505 views

The Bucketizer Script

This code is written in a SSIS Script Component that basically accomplishes what I previously had as a T-SQL script, that was reviewed here. I need to split a 80 character string that contains 20 ...
2
votes
1answer
639 views

This brittle OData to SQL Server C# code isn't sustainable over time

The intent of this code is to access a third party OData API to capture only the relevant data to an existing in-house set of MSSQL server tables. Ignore the exception handling for now--the errors ...
3
votes
1answer
7k views

File Exists Script Task for SQL Server SSIS

I have an SSIS package for SQL Server 2008. In this package, I need to verify that a file exists that matches a pattern of SomeFileName_*.txt where the wild card ...