Hot answers tagged

3

So apparently network packet size setting in sp_configure was changed up to 32kb when it needed to be under 16kb. Once I reconfigured the setting, the jobs ran successfully. Who would have thought...


2

You have delivered a solution that uses SSIS. SSIS requires an installation of SQL Server Standard, BI, or Enterprise Edition (depending on components used). At this point, your client will need to spend ~ 8k per core (SE) to 23k per core (EE) for a license of SQL Server for their desktop. That's probably not what they're expecting. What can you do? ...


1

No*, it won't. The Package Deployment Model, if deployed to the database, will store individual packages in msdb.dbo.syspackages90 (SQL Server 2005) and msdb.dbo.sysssispackages (SQL Server 2008+) The Project Deployment Model, deploys to the SSISDB. There it takes the form of Folders/Projects/Packages which are stored in SSISDB.catalog.folders ...


1

How can I tell which type of deployment a package has taken? Look at the definition of your SQL Agent Job Step. If it specifies /file then the package has been to deployed to the file system somewhere. If it specifies /DTS then it's using a well known location on the SQL Server installation path (precise location eludes my memory as of this posting but ...


1

Did I understand this correctly that your customer has MSSQL Server? Source Database MSSQL or other You have two options: Script your own replication Use Oracle Golden Gate to stream the data to your Oracle Database. Golden Gate supports "zero downtime" migration. Source Database Oracle Additionally to the options mentioned in "Source Database MSSQL ...


1

You could use a script component which is supported in 2016 and previous versions. Make sure that when you add the component you select "source" as the type and not destination or transformation. Then you add a reference to System.Web.Extensions.dll to the task and write some code to consume the webservice. This blog post looks like it documents the ...



Only top voted, non community-wiki answers of a minimum length are eligible