Problem with my OLDB source (Error with the AquireConnection )
Greeting all , while the daily refresh of my data source , i found this error in my SSIS , anyone faced such thing please ? Thanks in advance .
Unable to cast COM object of type error using SSIS ODBC Connection to PostgreSQL
hi I have one doubt in ssis how to avoid Unable to cast COM object of type error using SSIS ODBC Connection to PostgreSQL I want load data from postgres to sql server using ssis package . In ssis solution I have 50 plus dft for loading data …
Substring C# Issue
Hi I am working on a C# code where I have a requirement to identify the filename in SSIS Package The files which I receive are in the following formats FL_NamePart1.20200909 FL_NamePart1_NamePart2_20200909 …
Finding a program similar to Crystal Reports (used by VB6)
Hi! Not really sure about all the functionality Crystal Reports brought to the table, but it seems that it was in heavy use during the 90's - I do not know that status of this tool today. I am taking over an old VB6-application using Crystal Reports,…
SSIS CSV Loading issue
I am looking for a C# solution to use a script task in SSIS so that I can load multiple csv files to SQL Tables Now If I use a data flow task, then I have to create 1 DFT per file as each file has a different metadata ( unless there is some other…
SSIS Script Task
I have a table which has the list of files in a column Column values are File1.csv, File2.csv etc. Now in SSIS I would like to retrieve the list of files from the above table and then check if each file is present in a directory. If a file is…
SQL Server SSIS Package - IDE
Microsoft®VisualStudio Pro Sub MSDN version is good for SQL Server SSIS Package development
User Account receives primary key violation but not another user
Hi We're trying to set up a proxy user to run an SQL Server job, but there are steps in the SSIS package with are MERGE statements. The user account set up, which has sysadmin rights against the databases, receives a 'Violation of PRIMARY KEY…
SSIS in SQL Job
Hi, I have an SSIS package with an XML file, and it works correctly, but when I use it (the SSIS package) in SQL job I got an error about the path of the XSD file. How Can I handle it in the Config file or invariable in the SSIS package? I…
Printing text query results to pdf fails
when attempting to print query results (to text) to a pdf it fails with error: Value cannot be null. Parameter name: moniker. What is the fix for this.
Unable to start Azure Data Factory SSIS Integration Runtime for my Managed Instance
I'm trying to deploy an Azure Data Factory SSIS Integration runtime for use with my SQL Managed Instance (on the private interface). I keep running into the same issue with this error: Failed to start the integration runtime: SSISintegrationRuntime.…
How to check the TFS SSIS version with MSDB SSIS version ? | SSIS2014| TFS
How to check the TFS SSIS version with MSDB SSIS version ? We have all ssis 2014 packages deployed on SSIS server . Now we need to check if they SSIS packages have the same version as TFS version. Is there way to query them together to see the data…
SSIS/SSAS: How to change only the table name without remap the columns, flows and dimensions?
Hi, My company asked me to change the name of some of my SQL Tables( Dimensions ). But the only way that I know to do that is delete the references to the old table and map them again and recreate the OleDBSource/OleDBDestination ( SSIS ) and recreate…
Table replicate using SSIS
Hi, I'm trying to replicate few tables from a Source DB to destination DB. Both Databases are sql server databases. The only issue is that the source DB gets refreshed from production DB backup every night which breaks its replication to the…
How to get data from a Web Service that has HTTPS, SOAP and WSDL with an SSIS Project
I need to get data from a Web Service that has HTTPS, SOAP and WSDL configuration. Tried following this tutorial https://www.mssqltips.com/sqlservertip/3272/example-using-web-services-with-sql-server-integration-services/ , but stopped on the…
pkg goes down because a connection cant be found
hi we run 2014 standard and develop in vs 2013. i deployed a pkg that has no connector called xxxxxxxx.yyyyyyyyyyy but i get the error the connction xxxxxxxx.yyyyyyyyyyy is not found...oxc001000e...this error is thrown by connections collection when…
dynamic configuration ssdt
HI, i need to know if w can change provider and server name without opening and manually changing in package. i have server name in parameter but not provider (sql client 11.1) i want to change this in 100 package , without opening it , or doing it…
Loading files ( CSV different structures) using SSIS
Hi, I have 5 different files with different columns and I would like to load them into SQL tables via SSIS. I have the option of writing 5 dataflow tasks. however is it possible to load them dynamically with just 1 dataflowtask
BCp command failing with error TCP Provider: An existing connection was forcibly closed by the remote host.
Hi, I am running a bcp command using execute process task via SSIS package.The command copies data from sql table into a flat file. The table has around 100 million records. The SSIS package ran successfully for about 2 weeks and then started failing…
sql Server agent STATUS Failed. The SSIS package executed successfully
Hello , I am bumping into a strange problem. My SQL Agent job reported failure ( Pic. 1), while the step SSIS Package reported success ( Pic. 2 ) and the package did not show any error message in the log. Any idea how to find out/troubleshooting …