ssis

相关标签：javascript jquery android 多少钱 iPhone

How to use SQL Server Integration Services to update production server

I have a development server (SQL Server 2008) it has database. i.e. Employee (database) on it, I have tables,stored procedure and data as well.[详细]

2023-04-09 11:45 分类：问答
SQL Server and SSIS Permission issue?

Hi all i\'m banging my head against a wall with this one and hope someone can help. I have a ssis package w开发者_开发百科ritten in BIDS 2005, which basically selects some data rows from a table in Da[详细]

2023-04-09 11:39 分类：问答
How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I\'m taking values from flat file and insert it into table. I have taken one Execute SQL Task in that creating one temptable[详细]

2023-04-09 07:49 分类：问答
Pull files from FTP using SSIS package and save to folder?

I have FTP location having 2-3 folders from there i need to pull some files on daily bases using SSIS package please help.[详细]

2023-04-09 07:15 分类：问答
SSIS - what do I look for? "Invalid column type from bcp client for colid 1."

I have an issue with a SSIS package which was working up till now but suddenly starts throwing up an error which I don\'t know were to place.[详细]

2023-04-09 06:43 分类：问答
Updating Deployed SSIS Package

I have a deployed SSIS package, with a sche开发者_开发知识库dule and everything. Now, I have made changes to this package. Do I have to re-deploy it, and setup the schedule for it again, or is there a[详细]

2023-04-09 04:30 分类：问答
SSIS - VB Script Component to Convert Input to XML

Im completely new to (VB) scripting, and am trying to find a way in an SSIS script component to convert 3 input columns into one XML structured output column.[详细]

2023-04-09 04:01 分类：问答
ETL sync in every sixth hour

I need to make a ETL sync to add n开发者_如何学Cew data from relational database to the database DW in SSIS. It should take place in every sixth hour.[详细]

2023-04-08 14:34 分类：问答
SSIS: C# Script task: How to change a SQL connection string based on server environment that the dtsx is running on?

I have ascript task where i change the connection string for a db, however, it is missing one vital piece of information which is the server that the package itself is running on.[详细]

2023-04-08 12:17 分类：问答
Why can I run SSIS Fuzzy Grouping from Visual Studio but not the deployed package?

I have written an SSIS package to create a Fuzzy Grouping. I can run it from Visual 开发者_高级运维Studio targeting any of my servers and it will run without any problem. If I try to run the dtsx by r[详细]

2023-04-08 07:52 分类：问答