I am trying to insert data from CSV file into same name table from multiple environments(local1, local2, lo..
Tag : ssis
I am trying to insert data from CSV file into same name table from multiple database (local1, local2, lo..
I’m trying to create a csv file using Flat File Destination from a table in my db. Each time i create it it has a blank row after each row of data. Can anyone suggest why and what I could do to rectify it? ..
Closed 1 min ago
I have a new SSIS project that must target Sql Server 2019. TargetServerVersion is correctly set to SQL Server 2019 in the project properties. However, when I open a package in XML I see DTS:LastModifiedProductVersion=”16.0.5035.3″, which corresponds to Sql 2022. Works fine in VS but when we attempt to run it on the server, a script task fails. As suggested by ChaptGPT, I changed DTS:LastModifiedProductVersion to 16.0.3937.0 (which corresponds to SQL Server 2019) in the XML. Now the package will not open in design view in VS, nor will i..
Are there any matching and survivorship nodes in SSIS besides the one offered by Melissa Data? Any implementations in SQL on survivorship would be great as..