Questions tagged [ssis]

0 votes
0 replies
SSIS call to SMO works in Visual Studio but fails when run from a SQL Agent Job on the server. Jobs not using SMO work fine
I wrote an SSIS 2017 package that uses SMO (sql server management ojects) to synch my disaster recovery (DR) server with my production server. B...
asked 4 months ago
4 votes
1 replies
How to execute SSIS package from SQL Server stored procedure and pass arguments
I'm trying to execute a SSIS package via a stored procedure. I'm able to successfully execute that stored procedure only when the parameters are...
asked 4 months ago
1 votes
1 replies
Assembly in Script Component through reflection works for random cases
I have a weird problem. I have a SSIS package with multiple DataFlows and within them I am using a Script component as a destination to write AVR...
asked 4 months ago
-1 votes
3 replies
How to get decimal point after first 2 digit?
I am getting data as 123456 or 12.3456 in database using ssis i wish to transform all data in given column like 12.3456, can anyone help here?...
asked 4 months ago
2 votes
1 replies
Evaluated variable and successfully evaluated package in VS-2017 SSIS does not work when executed in ssms
In VS-2017 I have written a variable with the datatype "string". This variable uses another variable in order to determine from what moment in ti...
2 votes
4 replies
Ignoring column from Excel file while importing to SQL Server
I have multiple Excel files that have the same format. I need to import them into SQL Server. The issue I currently have is that there are two...
asked 4 months ago
1 votes
0 replies
Problem when create new Catalog in SSMS 18
Currently I using SSMS v18.0. When I want to create a new Catalog in Integration Services Catalogs, I have to use Azure account to continue. Is...
asked 4 months ago
3 votes
1 replies
SSIS newbie How to get data output to file
OK so I'm a complete Novice to SSIS but i needed to export images stored in our DB relating to specific sales orders , I attempted to do this in...
asked 4 months ago
1 votes
1 replies
How to execute url using SSIS
I need my SSIS package to just execute or hit an url (which loads a SQL server table). I don't need any parameters to be passed as input other th...
asked 4 months ago
1 votes
0 replies
Add an SSIS packge once an OLE DB Source added
I'm working currently on staging to prepare my data warehouse. I want to have an SSIS package added automatically(with the name of the recently a...
asked 4 months ago
0 votes
0 replies
How can Load unstructured Excel to SQL table
deleted becuase of reasons thank you all please please please 0 Please do not post images. What have you tried? What DB technology are...
asked 4 months ago
1 votes
0 replies
Database is not getting updated
The application flow I configured in my SSRS/DTSX file is not updating/inserting any record in database. When I deploy same code on DEV and PRO,...
asked 4 months ago
0 votes
1 replies
SSIS Download the files using FTP Task inside the For Each loop by passing the Variable Enumerator
Download the files using FTP Task inside the For Each loop by passing the Variable Enumerator to set the Remote Path Variable I am loading the...
asked 4 months ago
4 votes
2 replies
Renaming a file source
I've been developing an SSIS package from a flat file source. The file comes daily and the file name has datetime indication like this: Filenam...
asked 4 months ago
2 votes
1 replies
Finding the column throwing exception during data migration with SSIS from Oracle to MS SQL
I am working on a data migration project. In current task, I have to select data from n number of tables from Oracle, join them and insert the da...
asked 4 months ago
1 votes
0 replies
Unzip multiple files in multiple folders in ssis [duplicate]
I have a .tar.gz file. Now i need to unpack these files with SSIS package. Previously did unzip and delete for .zip files with the help of For ea...
asked 4 months ago
-2 votes
0 replies
How to update SharePoint lists using SSIS Script Task
I have CSV files that I have used to upload my database that is connected to SSIS and I need to update the information that I have on my SharePoi...
asked 4 months ago
1 votes
1 replies
SSIS Transactions: Does Supported option create a new transaction if it does not exist?
Required starts a new transaction while Supported joins an existing transaction. However, if a transaction does not already exist, then does the...
asked 4 months ago
2 votes
1 replies
How can we insert row after row from flat file to OLEdb destnation db?
I have a flat file with many rows and columns separated by delimiter(|). Before inserting row into destination I have to be check whether record...
asked 4 months ago
0 votes
0 replies
Ho do I get return column value from Lookup to insert into Oledb destination db?
I am very new to SSIS: my requirement is to load the flat file with some columns (planid, name, start date, agentid), in flat file name column ha...
asked 4 months ago
-1 votes
1 replies
How to copy latest file from multiple directory to single directory using ssis package?
I want to copy a latest created file(.orig) from multiple directories into one common directory using SSIS package. The filename starts with PSA...
asked 4 months ago
1 votes
0 replies
Problems outputting a file from SSIS Visual C# script package or job [closed]
I developed a Visual C# script in Visual Studio that takes output from several queries and the results of each query become a worksheet in a MS E...
asked 4 months ago
1 votes
2 replies
SSIS Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection
I'm using MS SQL Server 2016. I have a SSIS package, with one execute SQL task. I can execute it fine with Visual Studio. When I deploy to the...
2 votes
1 replies
Is there any way to pass connection string (connection manager) for SSIS package while adding job in command parameter
How to pass connection manager(connection string)while creating a Job using T-SQL statement, having SSIS package as steps or process? Example:...
1 votes
2 replies
How to make a Script Component Failure in Data Flow Task?
I have a requirement that is columns validation in the Script component. If the column value found null it should be stopped task with red cross...
asked 4 months ago