ssis Questions
6
Solved
i'm using the new project deployment model.
I have a master package called ETL. The first thing my ETL package does is run a package called get SFTP files as shown.
Within Get SFTP files a fore...
Halley asked 29/11, 2013 at 15:14
11
Solved
I am developing a SSIS package, trying to update an existing SQL table from a CSV flat file. All of the columns are successfully updating except for one column. If I ignore this column on truncate,...
5
Using:
Windows 7 Enterprise; Visual Studio Pro 2017 (15.3.5); SSDT 15.1
Can't get Data Viewer to pop up on my SSIS package. I did do some Google-fu, and can't find anything relevant (or newer than...
Fruiterer asked 3/10, 2017 at 20:40
3
Solved
I'm trying to orchestrate Snowflake from SSIS.
I'm using an ODBC connection and the execute SQL Task. A truncate table statement works fine and the task completes successfully. Changing this to a ...
Drava asked 5/3, 2019 at 10:15
7
Solved
In an SSIS package that I'm writing, I have a CSV file as a source. On the Connection Manager General page, it has 65001 as the Code page (I was testing something). Unicode is not checked.
The col...
Bradway asked 26/1, 2018 at 0:56
3
I was Trying to deploy SSIS package from Visual studio 2019 into MS SQL Server 2016, I have been facing deployment error as shown below:
"“A .NET Framework error occurred during execution of ...
Aedile asked 14/7, 2020 at 15:55
10
I am not able to decrypt my file without secret key. I know this question is asked on this before, solutions on this question did not help me.
This is my problem's scenario.
This error I receive on...
Irfan asked 20/4, 2017 at 8:11
5
Solved
I have created a SSIS Package and now want to deploy it, for that I am required to create the Integration Service Catalog,so I have SQL Server Evaluation Set up in that when I m trying to connect t...
Thermistor asked 30/9, 2013 at 7:59
14
I have a SQL Server job that runs monthly that runs in server. Job is using an SSIS package and is supposed to extract the data from database and and create an Excel sheet and copy the data into Ex...
Versus asked 4/6, 2014 at 4:1
5
Solved
I am receiving the following error when trying to run the package from the Integration Services catalog in SSMS. I changed the 64BitRuntime option to FALSE but it still does not work. The error bel...
Outfoot asked 29/3, 2017 at 13:48
13
I have an ssis package where I am using an OLEDB source linking to SQL Server 2005 table. All columns except a date column are NVARCHAR(255). I am using an Excel destination and using a SQL stateme...
Realism asked 21/3, 2013 at 12:28
6
I'm currently updating all of our ETLs using Visual Studio 2015 (made in BIDS 2008) and redeploying them to a new reporting server running on SQL Server 2016 (originally 2008R2).
While updating o...
Ashwin asked 29/12, 2016 at 21:0
3
Solved
I am using SQL Server 2008 import and export wizard. I need to import a database. I opened the SQL server import/export wizard and I went through the following actions:-
for the destination I cho...
Spur asked 6/1, 2014 at 11:14
4
Solved
There was a communication link error while I was using SQL Server Native Client 10 in an SSIS Data Flow component.
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has
occurred. Error c...
Photodisintegration asked 6/2, 2014 at 13:7
4
Solved
I am new to Azure Data Factory and have an interesting requirement.
I need to move files from Azure Blob storage to Amazon S3, ideally using Azure Data Factory.
However S3 isnt supported as a s...
S asked 25/10, 2018 at 12:49
5
I defined parameters as shown below on my SSIS project
then I would like to change those optional over my sql agent- job, i defined as below.
even I tried to set a fix date value instead of g...
Dad asked 19/12, 2014 at 16:11
6
Solved
I'm getting a persistent error:
The element cannot be found in a collection.
This error happens when you try to retrieve an element from a collection on a container during execution of the pack...
3
Solved
Are staging tables used only in Data warehouse project or in any SSIS Project? I would like to know what is a staging table? Can anyone give me some examples on how to use it and in what circumstan...
Unattended asked 28/3, 2015 at 12:29
4
Solved
I have made an SSIS-package in Visual Studio 2015. A bit after, I had to reinstall VS because there was some trouble with an unrelated package. Now when I try to open the SSIS-package, I first get ...
Australasia asked 16/5, 2016 at 15:6
6
Here is my latest effort at revising this question. But this time, I am trying to follow the good counsel given by Oded in his article Getting good answers on StackOverflow.
I need to find out how...
Labefaction asked 21/5, 2013 at 16:47
14
Solved
I have an SSIS package which reads an Excel File (Data Flow Source) and transfer the data to SQL Server using OLEDB Destination Data Flow Item. The OLEDB Connection Manager used for the destination...
Cudweed asked 14/4, 2009 at 15:27
4
Solved
I was trying to create a SSIS package where i want to upload an excel file into my DB but its giving me an error that
Microsoft.ACE.Oledb.12.0 is not registered on your local machine
I have in...
Galloping asked 8/6, 2016 at 18:59
7
Solved
I'm setting up an ETL process for my company's S3 buckets so we can track our usage, and I've run into some trouble breaking up the columns of the S3 log file because Amazon uses spaces, double quo...
7
Solved
I have 3 SSIS packages with script tasks that all do very similar things - query a SQL Server database, loop through the results, and then call a SOAP webservice for each row.
These packages run fi...
Gas asked 1/3, 2013 at 19:53
8
I have read a lot of the responses to previous versions of this issue but none seem to work.
Every time I open my script component in Visual Studio 2015 (v14.0.25431.01 update 3) it tells me I am ...
Taritariff asked 5/3, 2018 at 1:38
© 2022 - 2025 — McMap. All rights reserved.