Questions tagged [Microsoft SQL Server Integration Services] (8)

1
answer

How to get rid of the errors SSIS package error 0xC000F427?

In the package are all good starts. As soon as you launch via the task scheduler or through dtexec /f mistake. All the SSIS service installed the latest version. SQL Server standart edition Error: 2018-11-12 09:49:32.76 Code: 0xC000F427 Source: the file to Delete a Rating Description: to run a SSIS package outside of SQL...
Isabelle_Larson95 asked March 13th 20 at 14:21
3
answers

In ssis, how to create a dbf file as the output?

Good day, Please tell me, you need to create a dbf file as the output ssis. Information is taken from mssql. Don't quite understand how to do it. In the source I choose ole db connect with mssql, what's the use to choose to get dbf.
Stanton48 asked March 13th 20 at 13:40
0
answer

Deploy SSIS project in TeamCity — ways + tips

Good evening, colleagues. The task following: there is a package developed in VS 2012, which imports data into MS SQL Server 2008 R2 locally. There is a need to deplot package remotely using TeamCity. This familiar environment is bad, so is not particularly represent where to move. Please share the tips and ways of deployme...
Ethely asked September 30th 19 at 22:27
2
answers

Is it possible to run SSIS package from SSRS?

Good day! Is it possible to run SSIS package through report in SSRS? Found here such method of running the package, but as you can see, it uses a running Job on the server, which of course out, but it would be different.
1
answer

The different behavior of SSIS in MSSQL 2012 and 2014?

To download data from sybase ASE 15.7 in MS SQL using SSIS. Originally the package was created in VS 2010 and successfully worked on MS SQL 2012, then deployed a new MS SQL 2014 and VS2013, the package would migrate to a new server and there was noticed one unpleasant feature. Package contains 26 parallel DataFlow blocks th...
Cleora asked September 17th 19 at 01:48
0
answer

How can I do this scenario: the data sample in the archive, in case of success to indicate that the data is sent?

There is a DB data source and table:CREATE TABLE dbo.Data ( ItemId INT IDENTITY Value NVARCHAR(50) NOT NULL, CreationDtStamp DATETIME2 NOT NULL CONSTRAINT DefaultDtStamp DEFAULT (GETDATE()), Replicated DefaultReplicated BIT NULL CONSTRAINT DEFAULT (0), CONSTRAINT PK_Data PRIMARY KEY CLUSTERED (Itemid) ) ON [PRIMARY] G...
2
answers

How to correctly set the parameters in the query?

The connection with the database is, the request is working, the table in the DB is for DB connection and sending the request is configured correctly, as I understand it. But why can't I substitute the variable value into the query, what do I do wrong?added later: Decided to temporarily this problem so: in the script just d...
1
answer

What literature advise for SSIS?

Good afternoon. Advise, please, that you can read about the creation of integration packages. They are going to develop in Visual Studio. Data processing is quite complex, whether it is necessary to find out in C# ?
1
answer

Something to read on SQL Server Analysis Services?

advise please the literature on SSAS, SSIS.(with regards to intelligence, cubes, mdx, intelligent analysis and architecture) itself is not new, but rather somewhere in the middle
Camren_Quigley6 asked June 1st 19 at 09:33
  • 1