ssis Questions
6
Solved
I am trying to deploy an SSIS 2012 project to an SSIS Catalog on a newly built SQL Server machine. It throws an error with the following message whilst creating the folder.
Failed to create appdom...
Clinandrium asked 16/2, 2013 at 16:51
5
This is what I am trying to do in the SSIS package:
Copy blank excel sheet with headers as new file
Run a data flow task populate data in the sheet.
When a open the excel, all numeric data is sho...
Ossiferous asked 13/8, 2010 at 12:33
13
Solved
I'm trying to import a flat file into an oledb target sql server database.
here's the field that's giving me trouble:
here are the properties of that flat file connection, specifically the fiel...
Dichloride asked 28/8, 2014 at 17:14
6
Solved
DECLARE @PATH NVARCHAR(1000) = N'\\MY-SERVER\C$\Folder\\'
DECLARE @TABLE NVARCHAR(50) = SUBSTRING(@FILENAME,0,CHARINDEX('.',@FILENAME))
DECLARE @SQL NVARCHAR(4000) =
N'IF OBJECT_ID(''dbo.' + @TAB...
Onondaga asked 30/11, 2017 at 16:50
5
Solved
SSIS Catalog Package error - Version of FlatFile destination not compatible with version of DataFlow
Getting error
"The version of flat file destination is not compatible with this version of the dataflow"
when trying to execute a SSIS package from the catalog, the package executes well from v...
Devoir asked 7/4, 2020 at 15:17
6
Solved
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 put a break point in my code and ran the entir...
Synn asked 22/6, 2011 at 21:11
9
Solved
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 message I was getting only warning but today the job...
Eisinger asked 15/2, 2012 at 16:17
7
Solved
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 one binary of this dll on my development machine...
Titty asked 28/7, 2009 at 14:34
12
I used the script found here
... And every time that I generate this dynamic package, it needs to open the script task and click "Ok" because the "The binary code for the script is not found." err...
Aquiculture asked 7/5, 2014 at 21:0
4
Solved
How do I open a DTSX file for editing using Visual Studio 2019?
I have generated a DTSX file by using the Import Data wizard found in SQL Server Management Studio, using the same process outlined ...
Piperidine asked 3/10, 2019 at 16:47
9
I am trying to import the data from Excel file into SQL Server database. I am unable to do so because I am getting following errors in the log file. Please help. The log erros are as as follows:-
...
Yeager asked 2/10, 2013 at 20:11
5
Solved
I recently deployed a update to one of my SSIS projects, and ever since the project has failed it's scheduled runs.
The SSIS package appears to be stuck at the "Created Execution" status. There ar...
Bivalve asked 17/6, 2015 at 18:4
2
Solved
I am trying to use Ado.Net Sql command to select data from a table with a date filter.
SELECT COLUMN1
, COLUMN2
FROM TABLENAME
WHERE DATE_INSERTED > @[User::LastInsertDate]
Both Date_Inserte...
Shanonshanta asked 9/10, 2012 at 10:41
7
i have a SQL server job that runs a SSIS package. This job has 9 steps and in each step it extracts data from a different database. the connections strings are defined as parameters in each step.
...
Manchineel asked 22/6, 2013 at 7:51
6
Solved
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 destination server (not optimal, but it works).
Wh...
Vaticide asked 5/6, 2012 at 21:11
4
Solved
I created and executed a dtsx with SSMS corresponding wizard:
This was to import a flat file in an existing table.
At the end I saved the "package" as a .dtsx file
Now I need to modify the colu...
Ternopol asked 22/1, 2019 at 11:25
4
Solved
Im inserting data into Excel using SSIS.
Im getting the following exception:
'[Excel Destination [32]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000400...
4
Solved
In SQL Server 2005, Import Data (SSIS), my desire is to import a text file and have it append to an existing table. The first time through the wizard on the Column Mappings step I swear the Append ...
Bifocal asked 6/8, 2010 at 16:45
6
I created SSIS packages and used the Integration Services Deployment Wizard to deploy it out to the server. I'm manually going to the Integration Services Catalog access through SQL Server 2012 and...
Foch asked 11/2, 2016 at 18:51
4
Solved
I am trying to stay away from another batch file, is possible. I have an SSIS package that pulls data from SQL, creates a text file and then sends those file(s) to an external ftp site. The package...
2
I try to get the "Last modified" excel file in a folder and load it in SSIS. I found a C# code to get the name of most recent excel sheet in a folder path, and copy that in the Script Tas...
Widmer asked 25/6, 2020 at 12:57
12
When I open up the solution that contains SSIS packages created by a colleague, I get this awkward error that tells me nothing about what I'm supposed to do to fix it.
He left instructions to take...
Achromat asked 29/9, 2009 at 14:57
4
Solved
I see several examples that show how to use the Execute SQL task. One such example I see this screen shot:
There are a lot of tasks there that I don't have in my task list. The one I am looking ...
Weightless asked 23/8, 2011 at 23:36
10
Solved
When an excel data source is used in SSIS, the data types of each individual column are derived from the data in the columns. Is it possible to override this behaviour?
Ideally we would like ever...
2
Solved
I'm working on a Data Mart loading package in SSIS 2012. When attempting to execute the package in Visual Studio I get this error:
"The AcquireConnection method call to the connection manager D...
Newland asked 19/12, 2012 at 0:31
© 2022 - 2024 — McMap. All rights reserved.