Stack Overflow
Stack Overflow

Questions tagged [ssis-2017]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2017 is a part of SQL Server 2017 Data Tools

116 questions
2
votes
2 answers

Dynamic connection string in SSIS

I am having the following problem with populating a dynamic file path for an XML file from a SSIS variable. In Visual Studio 2017 I have an Execute SQL Task with a MS SQL stored procedure that returns two columns. The first column is a date (stored…
Tim Peters
  • 255
  • 2
  • 15
2
votes
2 answers

Iterating columns of SQL Server table with loop in Visual Studio SSIS

I am building a simple SSIS project using Visual Studio which needs to copy a standardized column from hundreds of flat files into their respective rows into a SQL Server table. All flat files have the same format and are placed into a folder…
Alex
  • 140
  • 6
  • 19
1
vote
0 answers

How can I define text qualifiers in SSIS/C# Script task when importing files?

my task is to import CSV files into SQL tables. The issue comes up when parsing each line within the file. The file is COMMA DELIMITED. Which is easy to handle, but texts are in quotes. For example: 2, 2012-02-14, "David", "David does, not, show up…
Expert_to_be
  • 11
  • 2
1
vote
2 answers

schedule BIML generation of scripts?

I have some BIML scripts that (working together) check a folder for cvs files create packages to import those files This works like a charm, however, wehenever a file is added (or removed) to that folder, I need to regenerate the packages by…
Henrov
  • 1,610
  • 1
  • 24
  • 52
1
vote
1 answer

SSIS Reading Columns from an Object Variable

I have an object variable which is from a SQL Query. This essentially contains two columns: RecordID and Description. I'm not familiar with JavaScript. But how do I read the specific columns and assign them to a local javascript variable? Here's the…
Smiley
  • 3,207
  • 13
  • 49
  • 66
1
vote
1 answer

Output SQL Table to existing Excel file/ new worksheet in SSIS / C# in script task

Good day, I had a request to create a SSIS package that would output an SQL table to an Excel file. I had no problem creating this. However, the client came back asking that they wanted to be able to output the SQL table content to an existing…
MChalut
  • 57
  • 6
1
vote
0 answers

SSIS Catalog : Failed to compile scripts contained in the package

We had an SSIS Package which we used to Download some Excel files from the SharePoint and Load it to the On-Prem SQL Database. The Package will Fetch the Files from Sharepoint having the value Pending in the Status field, Process the file and update…
Jayasurya Satheesh
  • 7,826
  • 3
  • 22
  • 39
1
vote
2 answers

WebRequest The request was aborted, The request was cancelled

[EDIT] my mistake - showed the wrong line on which the error occured. I'm SQL Server developer not a .net developer so bear with me please. Consuming a 3rd party Rest API using a Script Task in SSIS (Visual Studio 2017) and getting the following…
Geezer
  • 513
  • 5
  • 17
1
vote
1 answer

SSIS - How to combine three different flat files

My requirement is to produce one single flat file from three different datasets that should have timestamp value in the name of the file. All three datasets are from SQL server and using SQL query to take these data from source. Source type is OLEDB…
gopi nath
  • 186
  • 3
  • 15
1
vote
2 answers

Import fixed width file with virtual decimals

I have a fixed width master data file. The file contains many columns with costs but no decimal point.This data needs to be imported to SQL server. With the help of specification document, I know the precision and scale of those columns. I tried…
SKa
  • 51
  • 11
1
vote
1 answer

SSIS package accepts password to open package but not to save

I am having issues with my password for SSIS 2017. When I open the package, it asks for the password. I provide the correct one, and it opens up everything properly. When I try to save it, it asks for the password. I provide it the same one, but it…
BigBlue
  • 11
  • 2
1
vote
1 answer

Why does my excel plus source in ssis outputting a fixed one date for all date columns?

I have an excel file that I want to import using SSIS, I have done this process many more times without a problem with other excel files. however, this excel file has three spreadsheets on it. two of them works just fine importing correct data, BUT…
sesy
  • 75
  • 8
1
vote
1 answer

Variables not generated in script task

For some reason my variables which I have added to the readonlyvariables(also tried readwritevariables)are not generated in code when I want to use them in code. What am I missing? I've added this script task in the Control Flow. When adding it in a…
Miscode
  • 57
  • 8
1
vote
0 answers

Convert double to string sql using import export OR SSIS

I have excel which has data like below 2015.0230 2015.1100 2015.9000 I'm using Wizard [import export] to load these values to DB table. However, after loading, it come like below: 2015.023 2015.11 2015.9 When I'm converting this to char or…
AskMe
  • 2,495
  • 8
  • 49
  • 102
1
vote
1 answer

Error SQL Server Data Tools for Visual Studio - DQS - System.NotImplementedException

When I create a Connection to DQS in an SSIS Project I get System.NotImplementedException error after the build. I am using Visual Studio 2017 Running SQL Server Data Tools for Visual Studio 2017 This is the error I get: Severity Code …
Mgcobo Gwampi
  • 11
  • 1
1 2
3
4 5 6 7 8