天道酬勤,学无止境

ssis

SSIS - the RPC server is unavailable

I've installed a instance of SQL Server and i select Integration Services in the setup wizard. However, when I run SQL Server Management Studio as 'Administrator', I can see my instance under. Database Engine Analysis Services Reporting Services However, I can't see my instance under 'Integration Services'. The service is running in Configuration Manager. UPDATE 1 When trying to enter the server name manually it gives the following error: the RPC server is unavailable

2022-01-17 09:42:03    分类:问答    sql-server   ssis   ssms   sql-server-2016

Renaming a file source

I've been developing an SSIS package from a flat file source. The file comes daily and the file name has datetime indication like this: Filename_20190509042908.txt I was wondering how I can pass until the date part; I want the package to read the file dynamically, but it should pass without the last 6 digits I just don't need the last 6 digit numbers as it is not consistent. I want to pass Filename_20190509.txt I have figured out how to take the filename until date removing the time part. Hence, I've trouble to let the package read the file name dynamically by ignoring the last 6 digits before

2022-01-17 08:16:49    分类:问答    sql   sql-server   ssis   etl   ssis-2012

How to use the column names specified in Excel file's first row within a package?

Could anyone tell me how to change default column names (F1, F2, F3 etc..) when importing data from Excel source to an OLEDB destination in SSIS 2005. Example: Data in my Excel spreadsheet looks as following Title | ProvinceID | DistrictID | --------------|------------|------------| Construction | 12 | 32 | The problem is that when I import data from sheet it gets the data but column header names are displayed as F1,F2 and F3, I want the column names to be as defined in the Excel spreadsheet. Highly appreciate your assistance

2022-01-17 04:14:16    分类:问答    sql-server   ssis

How do I increase SQL Server read speed?

I'm trying to copy a table from one SQL Server to another. Source is SQL Server 2014, destination is SQL Server 2016. I cannot get speeds faster than about 60MB/s. I have about 1.5 billion rows to copy, total table size of roughly 1TB. The source server has a RAID 5 of SATA SSDs, the destination has a raid 0 of NVME SSDs. Both machines are connected by 10GbE, direct with no switch. I am able to copy a few GB of files in a few seconds, so I think the network and disks are all configured properly. I'm using SSIS, and I've tried just a "table" source, and a select * query. The package creates the

2022-01-17 03:05:33    分类:问答    sql   sql-server   ssis   etl

ISDeploymentWizard.exe command (SSIS deployment ) in CMD doesn't print any indication for status

I'm running the below command in CMD for SSIS: ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:"C:\TEST\Integration Services.ispac" /DestinationServer:"TEST03,1111" /DestinationPath:"/TEST/DEVOPS" and it finished successfully but with no indication to the command line. I can only check with SSMS to make sure it was really deployed. any idea why?

2022-01-17 00:48:27    分类:问答    cmd   ssis   ssms

How to use a variable value created in an Execute SQL Task in Precedence Constraint Editor?

I need to run n-multiple Execute SQL Task based on n-multiple variable value (isnull true or false). This variable is created in a ssms script in the previous execute sql task (CONDITIONAL QUERY). How can I output the variable value from the ssms script to the conditional expression in ssis? my two variables are @beneficiary and @gempar. They either store a date type value or null.

2022-01-16 20:01:22    分类:问答    sql-server   visual-studio   ssis   execute-sql-task

如何使用命令行从 biml 生成 ssis 包并在服务器上部署 ssis(how can i generate ssis packages from biml using commandline and deploy ssis on server)

问题 我致力于创建 biml。 从中生成 ssis 包。 构建 SSIS 项目,然后在服务器上部署 ispac 文件。 但是这些所有手动步骤都可以自动化吗? 我可以使用命令行从 biml 生成 ssis 吗? 除了bidshelper之外,要在机器上安装什么命令和先决条件是什么 之后,我可以构建从 biml 生成 ssis 的集成服务项目并使用命令行将其部署在服务器上吗? 什么是先决条件。 需要为此安装吗? 回答1 从 Biml 自动发送 SSIS 包将需要访问核心 bimlengine。 通过 Mist/soon-to-be-rebrand-BimlStudio 的许可安装访问 biml 引擎 将 dtproj 转换为 ispac 将需要您创建并安装一个 MSBuild 扩展,我在我的演讲中介绍过,SSIS 的 DevOps msbuild 参数和过程在使用 MSBuild 构建 SSIS 2012 – 数据库部署自动化之旅中概述 回答2 安装 Mist 4.0 后使用以下命令从 biml 生成 ispac 文件 bimlc.exe -s "C:\\temp\\Project.biml" -s "C:\\temp\\DwToDw.biml" -t "C:\\temp\\ispacfile\\" -v=2014 --ssisDeploymentModel=Project

2022-01-16 19:17:28    分类:技术分享    ssis   automation   biml

如何将 Codeplex 2017 Sharepoint List Adapter 安装到 SSIS SQL Server 2019(开发/生产环境)(How to install Codeplex 2017 Sharepoint List Adapter onto SSIS SQL Server 2019 (dev/prod environment))

问题 如何使 Codeplex 2017 SharePoint 列表适配器与运行 SSIS 作业的 SQL Server 2019 开发/生产环境一起使用? -- Codeplex 适配器最后一次更新是在 2017 年,似乎没有升级它的计划。 适配器不会在通过 SQL Server 2019 建立的较新文件夹中安装/注册,因为它们仅安装在以下文件夹 \140\DTS 及以下文件夹中。 C:\Program 文件 (x86)\Microsoft SQL Server\140\DTS (SQL Server 2019 有文件夹 \150\DTS): 我们遇到了这个问题,并且在将一些包迁移到 SQL Server 2019 时遇到了困难,因为我们必须对 SharePoint 列表执行插入和更新。 尝试编写我们自己的自定义 C# 脚本来处理插入/更新不能满足我们的紧迫需求,并且不是该语言的专家。 我们考虑或尝试过的事情: CozyRoc 是仅用于与 SharePoint 交互的昂贵(大约 5000 美元的服务器许可证)解决方案。 安装 Codeplex 2017 SharePoint 列表适配器,但仍然无法正常工作,我相信需要更多步骤才能使其正常工作。 比较 Codeplex 中存档的 Adapter Source/Destination 的源代码; 令人惊讶的是,它在 2014/2017

2022-01-16 18:28:27    分类:技术分享    sql-server   sharepoint   ssis   sql-server-data-tools   codeplex

how can i generate ssis packages from biml using commandline and deploy ssis on server

I worked on creating biml. generate ssis packages from that. build SSIS project and then deploy ispac file on server. but can these all manual steps be automated? can i generate ssis from biml using commandline? what are the commands and what are the prerequisites to be installed on machine for this other than bidshelper after that can i build my integration services project having ssis generated from biml and deploy it on server using commandline? again what are the pre-req. required to be installed for this?

2022-01-16 18:12:59    分类:问答    ssis   automation   biml

Unable to Connect to Excel via SSIS

Excel file is not being recognized by SSIS. Error : Could not retrieve table information from connection manager "Excel Connection Manager Failed to connect to the source using the connection manager 'Excel Connection Manager' I have tried installing 32-bit of redistributable which resolved this error but when I run this outside using SQL stored procedure it is failing, which is in turn resolved if i install 64 of redistributable but this is failing in SSIS, Hence, I need 32-bit to run in SP, and 64-bit to run in SSIS but I cannot install both at the same time. Is there any solution to this

2022-01-16 17:55:55    分类:问答    sql-server   excel   ssis   oledb   etl