Stack Overflow
Stack Overflow

Questions tagged [ssis-2016]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2016 is a part of SQL Server 2016 Data Tools

96 questions
0
votes
2 answers

ERROR: To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition (64-bit) of Integration Services or higher

I have VS2015 Community and SQL Server 2016 Developer installed. Using the MSFT link, I've ensured to download the latest version of SSDT, which appears to install without error (though, Integration Services do not show in the SQL Configuration…
Evan
  • 3
  • 1
  • 2
0
votes
1 answer

Visual Studio 2015 checks solution file out everytime on opening

currently I'm migrating from SQL Server 2012 to 2016. I branched my ETL-projects, then set the TargetServerVersion to SQL Server 2016 and checked in to TFS. When I open one of these ETL-projects Visual Studio always wants to check out the solution…
Schichti
  • 1
  • 3
0
votes
1 answer

SSIS send mail task failing after deployment

I am working SQL Server 2016 and things are working in Visual Studio, but when I deployed my project to the Integration service catalog, SSIS send email task failed. I am getting below mentioned error: Send Mail Task: Error: An error occurred with…
Mohit
  • 415
  • 2
  • 18
0
votes
1 answer

SSIS Execute File Task In Parent Container If Child Container Process fails

I'm trying to create a package that imports excel files into a database using SSIS. As the operation has to perform this regularly and the file names follow a convention but are not the same, and equally the sheet/tab names are not always the same,…
Keer Kolloft
  • 13
  • 4
0
votes
1 answer

SSIS 2016 VS 2015 Error 0xC001700A Version number in the package is not valid. he version number cannot be greater than current version number

I upgraded an SSIS 2008R2 package to SSIS 2016 using the upgrade wizard. It upgraded successfully. I do have both 2008R2 and 2016 SQL Server loaded on my server. I am executing a batch file that calls the upgraded package. The batch file is…
Laurie
  • 9
  • 2
-4
votes
2 answers

how to capture Package start time with milliseconds in ssis package

I want the package start time including milliseconds, in the below code I am using @[System::StartTime] but have milliseconds like this .000 no numbers are displaying (DT_WSTR,50)(DT_DBTIMESTAMP2,3)@[System::StartTime] How to get the package start…
SQL006
  • 439
  • 6
  • 21
1 2 3 4 5 6
7