No announcements
-
0 VotesWhat is the process for updating SSIS 2008 Packages to SSIS in SQL Server 2017?
I'm building a new SSIS machine using SQL server 2017. I'm planning to migrate SQL Server 2008 SSIS packages to this new machine. When I look at the SQL Server Data Tools download ...Answered | 4 Replies | 142 Views | Created by lmarkum - Wednesday, June 12, 2019 1:44 AM | Last reply by Joseph Morgan - Saturday, June 15, 2019 4:25 AM
-
0 Votes
Sql Job parameter doesn't work in some servers
Hi I have a parameter in a SSIS package 2015 which runs in SQL job The value of the parameter is: \\ISPAEXk\testing In some server it needs a ...Unanswered | 2 Replies | 114 Views | Created by neonash - Thursday, June 13, 2019 4:48 AM | Last reply by neonash - Saturday, June 15, 2019 3:46 AM -
2 Votes
SSDT won't upgrade to latest version
I have downloaded the latest version of SSDT from here. I went through the installation process and when I open Visual Studio, SSDT still shows as version ...Unanswered | 3 Replies | 752 Views | Created by VegaFl - Thursday, August 23, 2018 2:17 PM | Last reply by tsotso lim - Friday, June 14, 2019 7:36 PM -
3 Votes
Schema compare not updating target
I have some simple changes in one of my databases that I am trying to sync to my db project. Schema compare finds these changes and show's that they additions, but when I check them off and click ...Proposed | 12 Replies | 6605 Views | Created by AlbertoMango - Wednesday, June 12, 2013 9:20 PM | Last reply by GLarimer - Thursday, June 13, 2019 6:13 PM -
1 Votes
Can't run SqlPackage.exe
Hi, I am trying to run the following cmd to get an SQL script for DB creation: SqlPackage.exe /Action:Script /Sourcefile:Database.dacpac ...Answered | 1 Replies | 65 Views | Created by Senglory - Thursday, June 13, 2019 11:25 AM | Last reply by Dan Guzman - Thursday, June 13, 2019 11:48 AM -
0 Votes
SQL Server Data Tools - SSIS and DQS
Hi All Has anyone successfully used the DQS Connection in SSIS (VS2017)? I get the following error when I try build the ...Unanswered | 4 Replies | 355 Views | Created by Mgcobo Gwampi - Thursday, May 23, 2019 11:13 AM | Last reply by Kavish Seechurn - Wednesday, June 12, 2019 5:36 PM -
0 Votes
SSIS package taking a long time to save in Visual Studio 2019
I've noticed over the past few weeks that whenever I save a change in Visual Studio 2019 to an SSIS package, no matter how large or small the number or nature of changes, it takes a long time for the ... -
0 Votes
An error occurred while scripting the catalogue
I am working on an Analysis Services Tabular project. When I tried to save it last time I got an error that it cannot be saved since it's in read-only. Tried to save a few times and kept getting same ...Unanswered | 7 Replies | 784 Views | Created by Luiza Oancea - Monday, June 11, 2018 8:24 AM | Last reply by Morak.Izaac - Tuesday, June 11, 2019 3:15 PM -
0 Votes
SFTP using ssis
i need to load and place file back to sftp server. how to do it using ssis, also how to do it using after deploying package to and run sql server agent job. i ...Unanswered | 1 Replies | 157 Views | Created by coool_sweet - Tuesday, June 4, 2019 2:24 AM | Last reply by Bo Wen - Tuesday, June 11, 2019 3:04 PM -
0 Votes
Stop SSIS inmediately in SSDT 2015
Hi I use the code... bool fireAgain = true; IDTSComponentMetaData100 myMetaData; myMetaData = ... -
0 Votes
BCP 15 shows right truncation warning, but BCP 13 does not
I have been using bcp to import data into a SQL Server table for years. When I updated bcp to version 15, I suddenly started getting right truncation errors. Any ideas or ... -
0 Votes
Scripting a Create SQL Server CE Database
I've used the SQL Server CE Data Tools to script a SQL Server CE SDF database but what I did was script create tables for each of the 10 tables. Is there a way to actually script the ...Answered | 1 Replies | 91 Views | Created by Mimosa Arts - Monday, June 10, 2019 5:24 PM | Last reply by ErikEJ - Tuesday, June 11, 2019 9:19 AM -
0 Votes
Microsoft connector for teradata by attunity
Hi Team, Can we use Microsoft connector for teradata by attunity in SSDT for Visual Studio 2017 (15.9.1) and later versions ? if not , can anyone help me in finding what is ... -
0 Votes
Error When Adding Copy of Existing Package
When I attempt to add an existing package from one of our servers (the packages are stored directly on a SQL Server instance), the following error message ...Unanswered | 5 Replies | 714 Views | Created by geneschultz74 - Thursday, May 2, 2019 10:29 PM | Last reply by rlynn - Friday, June 7, 2019 9:55 PM -
0 Votes
SSMS 18.0 commandline parameters misses -P (password) option
We use internally developed tooling for our devops team to quickly open an SSMS session to a remote database, using the commandline parameters to pass server, username and password to the ssms.exe ... -
0 Votes
The path for 'ISServerExec.exe' cannot be found when deploying a project
HKEY_LOCAL_MACHINE->SOFTWARES and under Microsoft Sql Server in SSIS" TITLE: SQL Server Integration ... -
0 Votes
What is the difference between Rows per batch and max insert commit size?
I use the default configuration but I don't know if it is a good idea.. -
0 Votes
SSIS Script Component fails within SQL Server Agent Job (SqlServer.Dts.Pipeline.ComponentVersionMismatchException)
Hi All, Environment: SQL Server 2016 Visual Studio 2017SSIS Data Flow Script Component (Type: Source, ScriptLanguage: Microsoft Visual C# ...Unanswered | 3 Replies | 1961 Views | Created by Ivan Sho - Friday, February 9, 2018 1:38 AM | Last reply by TANZEEL1994 - Sunday, June 2, 2019 7:23 AM -
2 Votes
SSIS - Why is it trash?
Why after over 10 years is SSIS trash that can't do basic things like detect metadata changes, allow you to update the metadata in any basic manner, and requires you to drop down to third-party ...Unanswered | 1 Replies | 195 Views | Created by mrjminer - Saturday, June 1, 2019 12:35 PM | Last reply by Dan Guzman - Saturday, June 1, 2019 12:43 PM -
0 Votes
SQL:72025: The referenced assembly .DLL is corrupt or invalid
Working with Visual Studio SSDT project, and am receiving an error when I compile the project on a new machine. SQL:72025: The referenced assembly <path>.DLL is ...Unanswered | 3 Replies | 564 Views | Created by subsum44 - Wednesday, March 13, 2019 2:16 PM | Last reply by fxdxdy - Saturday, June 1, 2019 4:28 AM - Items 1 to 20 of 4380 Next ›
No announcements
