Basically, on the ODBC Source, i can see the tables, i can preview the data, but i when i click on the columns menu nothing is returned and i cant sav...

I have an SSIS project built in Visual Studio 2022 and consists of several packages. They all interrogate a source SQL server database and update a d...

In the dropdown 'Specify how to handle rows with no matching entries' I see 4 options to choose from: Ignore failure Redirect rows to error output Fa...

I will try to explain being the most understandable my concern : I am creating an SSIS package importing data from Excel source and load it to SQL tab...

In our folder, we have file names in this format myFile_yyyyMMddHHmmss.txt, for ex: 20230920095749.txt, 20230919051704.txt. If today is 09/20/2023, in...

Ok, my issue is very similar to this one but the answer doesn't work for me: How do you create destination columns in a custom SSIS component? I'm bui...

Suppose we have two tables with the following values: ID Name Fname 1 aaaa aaaa 2 bbbb bbbb 3 cccc cccc 4 dddd dddd ID AnotherId ...

I have downloaded and installed Visual Studio 2022. Then after click on modify Now, I want to create SSIS package, for this I have started VS22 and ...

I have Jenkins slave of windows server. I'm running SSIS deploy command thought Powershell: $ISDeploymentWizard = Start-Process -FilePath ISDeployment...

I have a SSIS Package which has a simple dataflow with Excel to Excel data transfer. I am using Microsoft.ACE.OLEDB 12.0 driver for connection. Now in...

I create a new package in SSIS and when I try to run the package, SSIS returns the following error (displayed in a Visual Studio Error Dialog): Canno...

I am working on SSIS Package to export the output data to Excel file. ( Excel Destination ). I am running into conversion error. Error Descripti...

In my case, I have to look if my product already exists in a table before insert or update datas, what is the difference between using conditional spl...

I'm using SSIS to create a star schema for a data warehouse with surrogate keys (sg). My process goes like this: find max sg (using SQL) in data f...

SSIS Job was able to run and create CSV files to shared location until last week when it was executed from scheduled job. The ssis package reports suc...

I'm an experienced SQL user, but have limited exposure to creating SSIS packages. I'm putting together a package to transform and upload multiple log...

Query should output a certain list of Items, along with info like store information and manager info. Uses a Cursor to flip through list of various di...

I have programmed some ETL which works OK, the processing finishes without errors. Now I want to create a log using SSIS Loggin feature. However, on...

I am using SSIS with VS2010 (shell) and databases going from SQL Server 2005 (32 bit)to SQL Server 2012 (64 bit). I am developing directly on the dest...

I have a data flow process where I have an OLEDB Source and an OLEDB Destination like below: Source merges data from two staging tables and returns...

I created an SSIS package which is having ftp pull files from ftp server and save to my local drive but I'm getting this issue. With same error messa...

It's simple but I can't make it work, and I read in so many places a lot of solutions but nothing worked for me. How can I accomplished this? Note I...

I am attempting to use a lookup transformation in my data transformation package and all of the other lookup transformations went well but one compone...

I used to have a DTS package that used SQL Server authentication. The userid password was stored in the package itself. Now that I have moved to SSIS,...

I have a very simple component which trims all leading and trailing spaces from (read/write) strings in a pipeline. As far as I can see, I only have ...