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
0
votes
1 answer

Multiple Flat File Outputs to a folder in SSIS

I am using SSIS2017 and part of what I am doing involves running several (30ish) SQL scripts to be output into flat files into the same folder. My question is, to do this do I have to create 30 New File Connections or is there a way to define the…
MikeLanglois
  • 25
  • 7
0
votes
0 answers

SSIS doesn't save any changes

I have an SSIS project on VS2017 and in it, I have a connections manager. I also have connection strings to files on the server. I am in the middle of the migration process, so I have to replace the paths to all files. But when I replaced the old…
חיים חדד
  • 512
  • 5
  • 17
0
votes
0 answers

Cannot convert from SQL type 93 to C type 8

I AM using Oracle datasource in my ETL package which uses SQL command as data Access mode. Unfortunately i AM getting error Cannot convert from SQL type 93 to C type 8 I know that query used in Oracle datasource doesn't return any values. How…
LukaszP
  • 11
  • 4
0
votes
1 answer

Text was truncated or one or more characters had no match in the target code page - from SQL Server

I am trying to read a stored procedure and then output that to a flat file in SSIS. and to the flat file It is erroring on the field 'Name' and the file output stops before 'Men[']s Fairisle Jumper - L' Any help appreciated. The apostrophe seems a…
Jakey
  • 21
  • 7
0
votes
1 answer

How to use an SSIS Variable Value or Project Parameter Value as an expression body and then evaluate it to another Variable

I have an SSIS Project (Visual studio 2019 - Project Deployment Model) which contains 100 SSIS Packages. The name structure of each package is TableName_Table.dtsx (For example: If my table name is Employees then the package name will be:…
Panos_Koro
  • 45
  • 6
0
votes
2 answers

Extract data from dtsx

I need to create an automatic process that searches in several *.dtsx (version 2017) which tables are being used, is it possible to do this? And at the end, keep the package name in a table and which table is being used in that package. Thank you…
Ricardo Gonçalves
  • 39
  • 6
0
votes
1 answer

Deduce dataypes from table with only nvarchar fields?

I have a table like this: Create table landingzone.classes( teacher nvarchar(255) ,moment nvarchar(255) ,noOfStudents nvarchar(255) ,scheduledYesNo nvarchar(255) ) INSERT INTO [landingzone].[classes] ([teacher] ,[moment] …
Henrov
  • 1,610
  • 1
  • 24
  • 52
0
votes
1 answer

replace all double quotes with nothing in csv file in BIML script

I am importing flatfile connections using BIML. " is used around text and ; is used as delimiter. However, in some of the files I see this: ;"this is valid text"""; There are double double quotes with nothing between them. If I edit the file and…
Henrov
  • 1,610
  • 1
  • 24
  • 52
0
votes
1 answer

problem replacing hardcoded with parameter values

I have this construction in my BIML file: myColumns = myFile.ReadLine().Replace("\"","").Split('|'); I would like to replace this with: myColumns = myFile.ReadLine().Replace("\"","").Split('<#=delimiter#>'); but apparantly that does not work.…
Henrov
  • 1,610
  • 1
  • 24
  • 52
0
votes
1 answer

how to fill an array in BIML using SQL table as source

I have a table that contains filenames and some other attributes. I want to insert these records in an array in BIML so that I can loop through these files (and import them using the additional attributes). The code to import such a file is mostly…
Henrov
  • 1,610
  • 1
  • 24
  • 52
0
votes
0 answers

Developer specific connection strings for SSIS

There is a way to parametrize the connection string for SSIS. I can deploy the package to the SSIS catalog and then choose the right values when executing it. Is there a way to set developer-specific connection string parameter value that would not…
Dmitrij Kultasev
  • 5,447
  • 5
  • 44
  • 88
0
votes
1 answer

Execute package task in errorhandling gives error

In my OnError eventhandler I try to execute a (child) package but I get this error: Error: Error 0x80040154. Failed to create an instance of empty child package. The Distributed Component Object Model (DCOM) configuration or the installation of SQL…
Henrov
  • 1,610
  • 1
  • 24
  • 52
0
votes
3 answers

How do I check whether all the rows for a column are NULL in SSIS?

I'm working on a SSIS package where I have a text file with 5 columns. I need to check if all the rows for 5th column are NULL values. If all the rows in 5th column are NULL then all the data should go for invalid file table. If any row in 5th…
Sachin
  • 1
  • 2
0
votes
2 answers

Substring from-to

I am working on a SSIS(2017) solution to read and load data from these 3 excel file names: message_EDF_100420202.csv message_UltaBIO_10042020.csv message_SEIDV_10042020.csv What I need to do is get only EDF or UltraBIO or SEIDV as a new column…
Pablo Gûereca
  • 725
  • 1
  • 9
  • 23
0
votes
1 answer

Find success event in SSIS catalog

I want this information to add this in a specific table in my database
tina
  • 1
1 2 3 4 5
6
7 8